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

Query Metrics

4 Database Queries
4 Different statements
19.16 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.90 ms
(46.44%)
1
SELECT t0.name AS name_1, t0.color AS color_2, t0.second_color AS second_color_3, t0.recovery_price AS recovery_price_4, t0.started_valuation AS started_valuation_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.label AS label_10, t0.logo_id AS logo_id_11, t0.business_id AS business_id_12 FROM pro_valuator t0 WHERE t0.label = ? LIMIT 1
Parameters:
[
  "izidore"
]
5.34 ms
(27.85%)
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.pro_valuator_id IN (?)
Parameters:
[
  3
]
3.07 ms
(16.01%)
1
SELECT s0_.parentLevel AS parentLevel_0, s0_.peopleToCarry AS peopleToCarry_1, s0_.carbon_foot_print AS carbon_foot_print_2, s0_.active AS active_3, s0_.slug AS slug_4, s0_.volume_in_m3 AS volume_in_m3_5, s0_.format AS format_6, s0_.id AS id_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s1_.id AS id_10, s1_.name AS name_11, s1_.plural_name AS plural_name_12, s1_.created_at AS created_at_13, s1_.updated_at AS updated_at_14, s1_.locale AS locale_15, s0_.parent AS parent_16, s1_.translatable_id AS translatable_id_17 FROM stuff_type s0_ LEFT JOIN stuff_type_translation s1_ ON s0_.id = s1_.translatable_id WHERE s0_.active = 1 AND s0_.parentLevel >= ?
Parameters:
[
  3
]
1.86 ms
(9.70%)
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 ORDER BY t0.name ASC
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\ProValuator 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\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\Valuation 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\ProCertificator No errors.
App\Entity\ProVoucher No errors.
App\Entity\StuffType No errors.
App\Entity\StuffTypeTranslation No errors.
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\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\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.