GET https://www.frosty-hoover.45-155-169-10.plesk.page/catalogue/boutiques?ville=ajaccio

Query Metrics

3 Database Queries
3 Different statements
34.30 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
32.08 ms
(93.55%)
1
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:
[
  "AJACCIO"
]
1.74 ms
(5.08%)
1
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:
[
  "boutiques"
]
0.47 ms
(1.37%)
1
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:
[
  "boutiques"
]

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.