Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

8.71 ms Query time

12 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.78 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
2	6.73 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"test_izidore_2"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'test_izidore_2' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
3	0.20 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

#▲

Time

Info

1.78 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

6.73 ms

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME

Parameters:

[
  "test_izidore_2"
]

View formatted query View runnable query Explain query

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'test_izidore_2'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

0.20 ms

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\AbstractEntity	No errors.
App\Entity\UtmCampaign	No errors.
App\Entity\FavoriteAnonymous	No errors.
App\Entity\FavoriteAnonymousAnnounce	No errors.
App\Entity\FavoriteAnonymousStuff	No errors.
App\Entity\Favorite	No errors.
App\Entity\FavoriteAnnounce	No errors.
App\Entity\FavoriteStuff	No errors.
App\Entity\Announce	No errors.
App\Entity\Stuff	No errors.
App\Entity\ContactThread	No errors.
App\Entity\ContactThreadMessage	No errors.
App\Entity\Brand	The association App\Entity\Brand#business refers to the inverse side field App\Entity\UserBusiness#brands which does not exist. The association App\Entity\Brand#searches refers to the owning side field App\Entity\Search#brands which does not exist.
App\Entity\Sponsor	The association App\Entity\Sponsor#utmCampaigns refers to the owning side field App\Entity\Sponsor#sponsor which does not exist.
App\Entity\StuffType	No errors.
App\Entity\AnnounceOrder	No errors.
App\Entity\AnnounceOrderWithdrawal	No errors.
App\Entity\UserBusiness	The field App\Entity\UserBusiness#informations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BusinessInformations#business does not contain the required 'inversedBy="informations"' attribute.
App\Entity\FrenchCity	The field 'App\Entity\FrenchCity#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\FrenchCity#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\User	No errors.
App\Entity\Address	The field 'App\Entity\Address#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Address#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\Room	No errors.
App\Entity\PreFilledRoomImage	No errors.
App\Entity\AnnounceLibraryImage	No errors.
App\Entity\AnnounceOption	No errors.
App\Entity\PaymentTransaction	No errors.
App\Entity\CalendarAvailability	No errors.
App\Entity\BusinessShop	No errors.
App\Entity\AnnounceOrderStuff	The field App\Entity\AnnounceOrderStuff#negotiation is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Negotiation#stuff does not contain the required 'mappedBy="negotiation"' attribute. If association App\Entity\AnnounceOrderStuff#negotiation is one-to-one, then the inversed side App\Entity\Negotiation#stuff has to be one-to-one as well.
App\Entity\AnnouncePreOrderStuff	No errors.
App\Entity\StuffPicture	No errors.
App\Entity\StuffTag	No errors.
App\Entity\ProCertificator	No errors.
App\Entity\ProVoucher	No errors.
App\Entity\Negotiation	The mappings App\Entity\Negotiation#announceOrderStuff and App\Entity\AnnounceOrderStuff#negotiation are inconsistent with each other.
App\Entity\ContactThreadMessageDocument	No errors.
App\Entity\Search	The mappings App\Entity\Search#brand and App\Entity\Brand#searches are inconsistent with each other.
App\Entity\ProValuator	No errors.
App\Entity\DeliveryProviderStuffTypePolicy	No errors.
App\Entity\StuffTypeTranslation	No errors.
App\Entity\AnnounceOrderPickupDate	No errors.
App\Entity\PaymentAuthorization	No errors.
App\Entity\Delivery	No errors.
App\Entity\Voucher	No errors.
App\Entity\BankAccount	No errors.
App\Entity\BusinessAccess	No errors.
App\Entity\BusinessInformations	No errors.
App\Entity\Picture	The field App\Entity\Picture#userBusiness is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserBusiness#logo does not contain the required 'inversedBy="userBusiness"' attribute. The field App\Entity\Picture#proValuator is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProValuator#logo does not contain the required 'inversedBy="proValuator"' attribute. The field App\Entity\Picture#proCertificator is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProCertificator#logo does not contain the required 'inversedBy="proCertificator"' attribute.
App\Entity\ConfigCatalogAlgolia	No errors.
App\Entity\KycProcess	No errors.
App\Entity\NotificationToken	No errors.
App\Entity\Cart	No errors.
App\Entity\NotificationPreferences	No errors.
App\Entity\Business	No errors.
App\Entity\CGUVersion	No errors.
App\Entity\SearchUser	No errors.
App\Entity\RoomType	No errors.
App\Entity\Discount	No errors.
App\Entity\AnnouncePreOrder	No errors.
App\Entity\Valuation	No errors.
App\Entity\DeliveryProvider	No errors.
App\Entity\PaymentCard	No errors.
App\Entity\DeliveryOption	No errors.
App\Entity\BusinessDocument	No errors.
App\Entity\AlertNewsletter	No errors.
App\Entity\AlertNewsletterCampaign	No errors.
App\Entity\RoomTypeTranslation	No errors.
App\Entity\ValidationCode	No errors.
App\Entity\DeliveryCityGroup	The association App\Entity\DeliveryCityGroup#deliveryProvider refers to the inverse side field App\Entity\DeliveryProvider#deliveryCityGroups which does not exist.
App\Entity\SEOText	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\AppVersion	No errors.
App\Entity\View	No errors.
App\Entity\Contact	No errors.
App\Entity\ContactThreadMessageBlocker	No errors.
App\Entity\InvoiceItem	No errors.
App\Entity\Notification	No errors.
App\Entity\SearchAlert	No errors.
App\Entity\ServerError	No errors.
App\Entity\StuffTypeTag	The field App\Entity\StuffTypeTag#stuffType is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\StuffType#tags does not contain the required 'mappedBy="stuffType"' attribute. If association App\Entity\StuffTypeTag#stuffType is many-to-one, then the inversed side App\Entity\StuffType#tags has to be one-to-many.
App\Entity\StuffTypeTagTranslation	No errors.
App\Entity\Invoice	No errors.
App\Entity\Testimonial	No errors.
App\Entity\DeliveryProviderOption	No errors.
App\Entity\KycDocument	No errors.
App\Entity\Locality	The field 'App\Entity\Locality#lat' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type. The field 'App\Entity\Locality#lng' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry	No errors.
Gedmo\Loggable\Entity\LogEntry	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Algolia\SearchBundle\Entity\Aggregator	No errors.

Symfony Profiler

GET https://frosty-hoover.45-155-169-10.plesk.page/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping