Query Metrics
5
Database Queries
5
Different statements
1.63 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.59 ms |
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
"app_reference_list_category_sub"
]
|
||||||||||||||||||||||||||||||
| 2 | 0.26 ms |
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19, t0.global_activity_description AS global_activity_description_20 FROM site_settings t0
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.position AS position_5, t0.slug AS slug_6 FROM reference_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"batiments-logistique"
]
|
||||||||||||||||||||||||||||||
| 4 | 0.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.position AS position_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6 FROM reference_sub_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"obfsm:Y29udGFjdEBrYXBlY2ktYWNpZXIuZnI="
]
|
||||||||||||||||||||||||||||||
| 5 | 0.27 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.export AS export_4, t0.gallery_over_title AS gallery_over_title_5, t0.gallery_title AS gallery_title_6, t0.gallery_content AS gallery_content_7, t0.picture_name AS picture_name_8, t0.picture_size AS picture_size_9, t0.picture_updated_at AS picture_updated_at_10, t0.picture_alt AS picture_alt_11, t0.published_at AS published_at_12, t0.created_at AS created_at_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.slug AS slug_16, t0.is_published AS is_published_17, t0.sub_category_id AS sub_category_id_18, t0.homepage_id AS homepage_id_19 FROM reference t0 INNER JOIN reference_category_link ON t0.id = reference_category_link.reference_id WHERE reference_category_link.reference_category_id = ?
Parameters:
[
6
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Reference | 4 |
| App\Entity\SiteSettings | 1 |
| App\Entity\ReferenceCategory | 1 |
| App\Entity\ReferenceSubCategory | 1 |
| App\Entity\Homepage | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Cofondateur\SocleTechniqueBundle\Entity\SEOPage | No errors. |
| App\Entity\SEOPage | No errors. |
| Cofondateur\SocleTechniqueBundle\Entity\SiteSettings | No errors. |
| App\Entity\SiteSettings | No errors. |
| App\Entity\ReferenceCategory | No errors. |
| App\Entity\Reference | No errors. |
| App\Entity\ReferenceSubCategory | No errors. |
| App\Entity\Homepage | No errors. |
| App\Entity\ReferenceMedia | No errors. |
| App\Entity\ReferenceParagraph | No errors. |