GET https://www.frosty-hoover.45-155-169-10.plesk.page/catalogue/table-exterieur/ensemble

Query Metrics

6 Database Queries
5 Different statements
37.96 ms Query time
12 Invalid entities

Queries

Group similar statements

# Time Info
1 1.37 ms
SELECT t0.parentLevel AS parentLevel_1, t0.peopleToCarry AS peopleToCarry_2, t0.carbon_foot_print AS carbon_foot_print_3, t0.active AS active_4, t0.slug AS slug_5, t0.volume_in_m3 AS volume_in_m3_6, t0.format AS format_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.parent AS parent_11 FROM stuff_type t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "table-exterieur/ensemble"
]
2 14.99 ms
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.is_main AS is_main_3, t0.menu_rank AS menu_rank_4, t0.default_partner_link AS default_partner_link_5, t0.quality AS quality_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.business_id AS business_id_10, t0.pro_valuator_id AS pro_valuator_id_11, t12.id AS id_13, t12.created_at AS created_at_14, t12.updated_at AS updated_at_15, t12.logo_id AS logo_id_16, t12.user_business_id AS user_business_id_17, t12.brand_id AS brand_id_18, t0.pro_voucher_id AS pro_voucher_id_19 FROM brand t0 LEFT JOIN pro_certificator t12 ON t12.brand_id = t0.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "table-exterieur/ensemble"
]
3 19.14 ms
SELECT f0_.name AS name_0, f0_.name_simple AS name_simple_1, f0_.lat AS lat_2, f0_.lng AS lng_3, f0_.zip_code AS zip_code_4, f0_.department AS department_5, f0_.id AS id_6 FROM french_city f0_ WHERE f0_.name_simple LIKE ? LIMIT 1
Parameters:
[
  "TABLE-EXTERIEUR/ENSEMBLE"
]
4 0.32 ms
SELECT DATABASE()
Parameters:
[]
5 2.01 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "test_izidore_2"
]
6 0.14 ms
SELECT DATABASE()
Parameters:
[]

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\StuffType 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\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\ProValuator No errors.
App\Entity\ProCertificator 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\ProVoucher No errors.
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\Sponsor
  • The association App\Entity\Sponsor#utmCampaigns refers to the owning side field App\Entity\Sponsor#sponsor which does not exist.
App\Entity\AnnounceOrder No errors.
App\Entity\AnnounceOrderWithdrawal No errors.
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\Negotiation
  • The mappings App\Entity\Negotiation#announceOrderStuff and App\Entity\AnnounceOrderStuff#negotiation are inconsistent with each other.
App\Entity\ContactThreadMessageDocument No errors.
App\Entity\DeliveryProviderStuffTypePolicy No errors.
App\Entity\Search
  • The mappings App\Entity\Search#brand and App\Entity\Brand#searches are inconsistent with each other.
App\Entity\StuffTypeTranslation No errors.
App\Entity\BusinessAccess No errors.
App\Entity\BusinessInformations No errors.
App\Entity\ConfigCatalogAlgolia No errors.
App\Entity\Valuation 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\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\DeliveryProvider No errors.
App\Entity\BusinessDocument No errors.
App\Entity\PaymentCard No errors.
App\Entity\DeliveryOption 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.