Query Metrics
4
Database Queries
4
Different statements
19.16 ms
Query time
6
Invalid entities
Grouped Statements
| 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 |
|
| App\Entity\UserBusiness |
|
| App\Entity\Valuation | No errors. |
| App\Entity\Brand |
|
| 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 |
|
| App\Entity\Sponsor |
|
| App\Entity\AnnounceOrder | No errors. |
| App\Entity\AnnounceOrderWithdrawal | No errors. |
| App\Entity\FrenchCity |
|