Query Metrics
14
Database Queries
9
Different statements
4.76 ms
Query time
1
Invalid entities
43
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.44 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_sitemap"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.39 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.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.89 ms |
SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.meta_title AS meta_title_2, r0_.meta_description AS meta_description_3, r0_.position AS position_4, r0_.slug AS slug_5 FROM reference_category r0_ INNER JOIN reference_category_link r2_ ON r0_.id = r2_.reference_category_id INNER JOIN reference r1_ ON r1_.id = r2_.reference_id AND (r1_.is_published = 1)
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.23 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:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 6 | 0.22 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:
[
2
]
|
||||||||||||||||||||||||||||||||||
| 7 | 0.21 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:
[
3
]
|
||||||||||||||||||||||||||||||||||
| 8 | 0.21 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:
[
4
]
|
||||||||||||||||||||||||||||||||||
| 9 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 10 | 0.43 ms |
SELECT j0_.id AS id_0, j0_.title AS title_1, j0_.export AS export_2, j0_.summary AS summary_3, j0_.published_at AS published_at_4, j0_.city AS city_5, j0_.meta_title AS meta_title_6, j0_.meta_description AS meta_description_7, j0_.slug AS slug_8, j0_.is_published AS is_published_9, j0_.category_id AS category_id_10 FROM job_offer j0_ WHERE j0_.is_published = 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 11 | 0.57 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.summary AS summary_2, a0_.published AS published_3, a0_.picture_name AS picture_name_4, a0_.picture_size AS picture_size_5, a0_.picture_updated_at AS picture_updated_at_6, a0_.picture_alt AS picture_alt_7, a0_.export AS export_8, a0_.gallery_over_title AS gallery_over_title_9, a0_.gallery_title AS gallery_title_10, a0_.gallery_content AS gallery_content_11, a0_.published_at AS published_at_12, a0_.meta_title AS meta_title_13, a0_.meta_description AS meta_description_14, a0_.slug AS slug_15, a0_.updated_at AS updated_at_16, a0_.created_at AS created_at_17, a0_.updated_by_id AS updated_by_id_18, a0_.created_by_id AS created_by_id_19 FROM article a0_ WHERE a0_.published = 1
Parameters:
[]
|
||||||||||||||||||||||||||||||||||
| 12 | 0.24 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0 ORDER BY t0.position ASC
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 13 | 0.23 ms |
SELECT t0.position AS position_1, t0.id AS id_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.card_section_title AS card_section_title_10, t0.regulations_title AS regulations_title_11, t0.refs_title AS refs_title_12, t0.last_block_title AS last_block_title_13, t0.last_block_summary AS last_block_summary_14, t0.last_block_link_title AS last_block_link_title_15, t0.last_block_link_target AS last_block_link_target_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.slug AS slug_19, t0.category_id AS category_id_20 FROM activity t0
Parameters:
[] |
||||||||||||||||||||||||||||||||||
| 14 | 0.21 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.over_title AS over_title_3, t0.title AS title_4, t0.summary AS summary_5, t0.picture_name AS picture_name_6, t0.picture_size AS picture_size_7, t0.picture_updated_at AS picture_updated_at_8, t0.picture_alt AS picture_alt_9, t0.icon_name AS icon_name_10, t0.icon_size AS icon_size_11, t0.icon_updated_at AS icon_updated_at_12, t0.icon_alt AS icon_alt_13, t0.card_section_title AS card_section_title_14, t0.last_block_title AS last_block_title_15, t0.last_block_summary AS last_block_summary_16, t0.last_block_picture_name AS last_block_picture_name_17, t0.last_block_picture_size AS last_block_picture_size_18, t0.last_block_picture_updated_at AS last_block_picture_updated_at_19, t0.last_block_picture_alt AS last_block_picture_alt_20, t0.last_block_link_title AS last_block_link_title_21, t0.last_block_link_target AS last_block_link_target_22, t0.meta_title AS meta_title_23, t0.meta_description AS meta_description_24, t0.slug AS slug_25 FROM building_type t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Reference | 12 |
| App\Entity\Activity | 8 |
| App\Entity\ActivityCategory | 7 |
| App\Entity\ReferenceCategory | 4 |
| App\Entity\Blog\Article | 3 |
| App\Entity\ReferenceSubCategory | 2 |
| Cofondateur\SocleTechniqueBundle\Entity\User | 2 |
| App\Entity\SEOPage | 1 |
| App\Entity\SiteSettings | 1 |
| App\Entity\Homepage | 1 |
| App\Entity\JobOffer | 1 |
| App\Entity\JobOfferType | 1 |