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

Query Metrics

373 Database Queries
4 Different statements
136.15 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
127.20 ms
(93.43%)
370
SELECT t0.id AS id_1, t0.name AS name_2, t0.plural_name AS plural_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7, t8.parentLevel AS parentLevel_9, t8.peopleToCarry AS peopleToCarry_10, t8.carbon_foot_print AS carbon_foot_print_11, t8.active AS active_12, t8.slug AS slug_13, t8.volume_in_m3 AS volume_in_m3_14, t8.format AS format_15, t8.id AS id_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.parent AS parent_19 FROM stuff_type_translation t0 LEFT JOIN stuff_type t8 ON t0.translatable_id = t8.id WHERE t0.translatable_id = ?
Parameters:
[
  1
]
7.59 ms
(5.57%)
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:
[
  "LAVAL"
]
1.01 ms
(0.74%)
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
Parameters:
[]
0.35 ms
(0.26%)
1
SELECT t0.slug AS slug_1, t0.type AS type_2, t0.text AS text_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM seotext t0 WHERE t0.slug = ? AND t0.type = ? LIMIT 1
Parameters:
[
  "laval"
  "CITY"
]

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\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\SEOText 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\DeliveryProviderStuffTypePolicy No errors.
App\Entity\StuffTag 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.