Query Metrics
49
Database Queries
19
Different statements
85.01 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
21.13 ms (24.86%) |
17 |
SELECT t0.id AS id_1, t0.last_reviewed AS last_reviewed_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.is_indexable AS is_indexable_5, t0.icon AS icon_6, t0.name AS name_7, t0.description AS description_8, t0.url AS url_9, t0.main_entity_of_page AS main_entity_of_page_10, t0.headline AS headline_11, t0.alternative_headline AS alternative_headline_12, t0.push_forward AS push_forward_13, t0.text AS text_14, t0.text_resume AS text_resume_15, t0.date_published AS date_published_16, t0.expire AS expire_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.date_created AS date_created_20, t0.date_modified AS date_modified_21, t0.primary_image_id AS primary_image_id_22, t0.secondary_image_id AS secondary_image_id_23, t0.category_id AS category_id_24, t0.user_created_id AS user_created_id_25, t0.user_last_modified_id AS user_last_modified_id_26 FROM webpage t0 INNER JOIN webpages_components ON t0.id = webpages_components.web_page_id WHERE webpages_components.component_id = ?
Parameters:
[
1
]
|
8.59 ms (10.10%) |
11 |
SELECT t0.slug AS slug_1, t0.content_size AS content_size_2, t0.encoding_format AS encoding_format_3, t0.caption AS caption_4, t0.filename AS filename_5, t0.original_filename AS original_filename_6, t0.dimensions AS dimensions_7, t0.tmp_file AS tmp_file_8, t0.link AS link_9, t0.is_active AS is_active_10, t0.alt AS alt_11, t0.svg AS svg_12, t0.id AS id_13, t0.name AS name_14, t0.description AS description_15, t0.url AS url_16, t0.main_entity_of_page AS main_entity_of_page_17, t0.date_created AS date_created_18, t0.date_modified AS date_modified_19, t0.user_created_id AS user_created_id_20, t0.user_last_modified_id AS user_last_modified_id_21 FROM media_object t0 WHERE t0.id = ?
Parameters:
[
4
]
|
7.34 ms (8.64%) |
1 |
SELECT t0.id AS id_1, t0.last_reviewed AS last_reviewed_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.is_indexable AS is_indexable_5, t0.icon AS icon_6, t0.name AS name_7, t0.description AS description_8, t0.url AS url_9, t0.main_entity_of_page AS main_entity_of_page_10, t0.headline AS headline_11, t0.alternative_headline AS alternative_headline_12, t0.push_forward AS push_forward_13, t0.text AS text_14, t0.text_resume AS text_resume_15, t0.date_published AS date_published_16, t0.expire AS expire_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.date_created AS date_created_20, t0.date_modified AS date_modified_21, t0.primary_image_id AS primary_image_id_22, t0.secondary_image_id AS secondary_image_id_23, t0.category_id AS category_id_24, t0.user_created_id AS user_created_id_25, t0.user_last_modified_id AS user_last_modified_id_26 FROM webpage t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"accueil"
]
|
6.41 ms (7.54%) |
1 |
SELECT t0.slug AS slug_1, t0.icon AS icon_2, t0.list AS list_3, t0.sort_position AS sort_position_4, t0.internal_link_web_page_label AS internal_link_web_page_label_5, t0.internal_link_article_label AS internal_link_article_label_6, t0.html_code_plugin AS html_code_plugin_7, t0.label_default AS label_default_8, t0.id AS id_9, t0.name AS name_10, t0.description AS description_11, t0.url AS url_12, t0.main_entity_of_page AS main_entity_of_page_13, t0.headline AS headline_14, t0.alternative_headline AS alternative_headline_15, t0.push_forward AS push_forward_16, t0.text AS text_17, t0.text_resume AS text_resume_18, t0.date_published AS date_published_19, t0.expire AS expire_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.date_created AS date_created_23, t0.date_modified AS date_modified_24, t0.blockquote_id AS blockquote_id_25, t0.media_id AS media_id_26, t0.slide_id AS slide_id_27, t0.category_id AS category_id_28, t0.external_link_id AS external_link_id_29, t0.internal_link_web_page_id AS internal_link_web_page_id_30, t0.internal_link_article_id AS internal_link_article_id_31, t0.user_created_id AS user_created_id_32, t0.user_last_modified_id AS user_last_modified_id_33 FROM component t0
Parameters:
[] |
6.21 ms (7.30%) |
1 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.sort_order AS sort_order_4, t0.id AS id_5, t0.description AS description_6, t0.url AS url_7, t0.main_entity_of_page AS main_entity_of_page_8, t0.headline AS headline_9, t0.alternative_headline AS alternative_headline_10, t0.push_forward AS push_forward_11, t0.text AS text_12, t0.text_resume AS text_resume_13, t0.date_published AS date_published_14, t0.expire AS expire_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.date_created AS date_created_18, t0.date_modified AS date_modified_19, t0.primary_image_id AS primary_image_id_20, t0.parent_id AS parent_id_21, t0.user_created_id AS user_created_id_22, t0.user_last_modified_id AS user_last_modified_id_23 FROM tag t0 WHERE t0.slug = ?
Parameters:
[
"blog"
]
|
4.91 ms (5.77%) |
1 |
SELECT t0.name AS name_1, t0.address AS address_2, t0.postcode AS postcode_3, t0.city AS city_4, t0.country AS country_5, t0.phone AS phone_6, t0.id AS id_7, t0.date_created AS date_created_8, t0.date_modified AS date_modified_9 FROM address t0 INNER JOIN organizations_addresses ON t0.id = organizations_addresses.address_id WHERE organizations_addresses.organisation_id = ?
Parameters:
[
4
]
|
4.20 ms (4.94%) |
1 |
SELECT t0.id AS id_1, t0.date_created AS date_created_2, t0.date_modified AS date_modified_3, t0.slug AS slug_4, t0.name AS name_5, t0.user_created_id AS user_created_id_6, t0.user_last_modified_id AS user_last_modified_id_7 FROM organization_type t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"lien-reseau-social"
]
|
3.94 ms (4.63%) |
1 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.foundingDate AS foundingDate_6, t0.number_of_employees AS number_of_employees_7, t0.number_of_projects AS number_of_projects_8, t0.mobile_phone AS mobile_phone_9, t0.id AS id_10, t0.description AS description_11, t0.url AS url_12, t0.main_entity_of_page AS main_entity_of_page_13, t0.date_created AS date_created_14, t0.date_modified AS date_modified_15, t0.organization_type_id AS organization_type_id_16, t0.primary_image_id AS primary_image_id_17, t0.secondary_image_id AS secondary_image_id_18, t0.organization_id AS organization_id_19, t0.user_created_id AS user_created_id_20, t0.user_last_modified_id AS user_last_modified_id_21 FROM organization t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"pilote-travaux-conseils"
]
|
3.56 ms (4.18%) |
1 |
SELECT COUNT(*) FROM article t0 WHERE t0.category_id IN (?)
Parameters:
[
[
24
]
]
|
3.30 ms (3.89%) |
2 |
SELECT t0.position AS position_1, t0.svg AS svg_2, t0.internal_link_web_page_label AS internal_link_web_page_label_3, t0.internal_link_article_label AS internal_link_article_label_4, t0.label_default AS label_default_5, t0.id AS id_6, t0.name AS name_7, t0.description AS description_8, t0.url AS url_9, t0.main_entity_of_page AS main_entity_of_page_10, t0.slide_id AS slide_id_11, t0.media_object_id AS media_object_id_12, t0.external_link_id AS external_link_id_13, t0.internal_link_web_page_id AS internal_link_web_page_id_14, t0.internal_link_article_id AS internal_link_article_id_15, t0.image_id AS image_id_16, t0.user_created_id AS user_created_id_17, t0.user_last_modified_id AS user_last_modified_id_18 FROM slide_media_object t0 WHERE t0.slide_id = ?
Parameters:
[
1
]
|
2.62 ms (3.09%) |
2 |
SELECT t0.name AS name_1, t0.width AS width_2, t0.height AS height_3, t0.slug AS slug_4, t0.id AS id_5, t0.description AS description_6, t0.url AS url_7, t0.main_entity_of_page AS main_entity_of_page_8, t0.date_created AS date_created_9, t0.date_modified AS date_modified_10, t0.user_created_id AS user_created_id_11, t0.user_last_modified_id AS user_last_modified_id_12 FROM slide t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2.27 ms (2.67%) |
1 |
SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.birthday AS birthday_3, t0.place_of_birth AS place_of_birth_4, t0.phone AS phone_5, t0.email AS email_6, t0.origin AS origin_7, t0.customer_traffic AS customer_traffic_8, t0.informations AS informations_9, t0.phone_country AS phone_country_10, t0.id AS id_11, t0.name AS name_12, t0.description AS description_13, t0.url AS url_14, t0.main_entity_of_page AS main_entity_of_page_15, t0.date_created AS date_created_16, t0.date_modified AS date_modified_17, t0.gender_id AS gender_id_18, t0.position_id AS position_id_19, t0.nature_id AS nature_id_20, t0.user_created_id AS user_created_id_21, t0.user_last_modified_id AS user_last_modified_id_22 FROM person t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"contact@pilote-travaux-conseil.com"
]
|
2.07 ms (2.44%) |
2 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.sort_order AS sort_order_4, t0.id AS id_5, t0.description AS description_6, t0.url AS url_7, t0.main_entity_of_page AS main_entity_of_page_8, t0.headline AS headline_9, t0.alternative_headline AS alternative_headline_10, t0.push_forward AS push_forward_11, t0.text AS text_12, t0.text_resume AS text_resume_13, t0.date_published AS date_published_14, t0.expire AS expire_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.date_created AS date_created_18, t0.date_modified AS date_modified_19, t0.primary_image_id AS primary_image_id_20, t0.parent_id AS parent_id_21, t0.user_created_id AS user_created_id_22, t0.user_last_modified_id AS user_last_modified_id_23 FROM tag t0 WHERE t0.id = ?
Parameters:
[
19
]
|
1.87 ms (2.19%) |
1 |
SELECT t0.slug AS slug_1, t0.icon AS icon_2, t0.list AS list_3, t0.sort_position AS sort_position_4, t0.internal_link_web_page_label AS internal_link_web_page_label_5, t0.internal_link_article_label AS internal_link_article_label_6, t0.html_code_plugin AS html_code_plugin_7, t0.label_default AS label_default_8, t0.id AS id_9, t0.name AS name_10, t0.description AS description_11, t0.url AS url_12, t0.main_entity_of_page AS main_entity_of_page_13, t0.headline AS headline_14, t0.alternative_headline AS alternative_headline_15, t0.push_forward AS push_forward_16, t0.text AS text_17, t0.text_resume AS text_resume_18, t0.date_published AS date_published_19, t0.expire AS expire_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.date_created AS date_created_23, t0.date_modified AS date_modified_24, t0.blockquote_id AS blockquote_id_25, t0.media_id AS media_id_26, t0.slide_id AS slide_id_27, t0.category_id AS category_id_28, t0.external_link_id AS external_link_id_29, t0.internal_link_web_page_id AS internal_link_web_page_id_30, t0.internal_link_article_id AS internal_link_article_id_31, t0.user_created_id AS user_created_id_32, t0.user_last_modified_id AS user_last_modified_id_33 FROM component t0 INNER JOIN webpages_components ON t0.id = webpages_components.component_id WHERE webpages_components.web_page_id = ? ORDER BY t0.sort_position ASC
Parameters:
[
1
]
|
1.75 ms (2.06%) |
2 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.sort_order AS sort_order_4, t0.id AS id_5, t0.description AS description_6, t0.url AS url_7, t0.main_entity_of_page AS main_entity_of_page_8, t0.headline AS headline_9, t0.alternative_headline AS alternative_headline_10, t0.push_forward AS push_forward_11, t0.text AS text_12, t0.text_resume AS text_resume_13, t0.date_published AS date_published_14, t0.expire AS expire_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.date_created AS date_created_18, t0.date_modified AS date_modified_19, t0.primary_image_id AS primary_image_id_20, t0.parent_id AS parent_id_21, t0.user_created_id AS user_created_id_22, t0.user_last_modified_id AS user_last_modified_id_23 FROM tag t0 WHERE t0.slug = ? AND t0.is_active = ?
Parameters:
[ "prestation" 1 ] |
1.60 ms (1.88%) |
1 |
SELECT t0.id AS id_1, t0.article_body AS article_body_2, t0.article_resume AS article_resume_3, t0.last_reviewed AS last_reviewed_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.is_indexable AS is_indexable_7, t0.icon AS icon_8, t0.name AS name_9, t0.description AS description_10, t0.url AS url_11, t0.main_entity_of_page AS main_entity_of_page_12, t0.headline AS headline_13, t0.alternative_headline AS alternative_headline_14, t0.push_forward AS push_forward_15, t0.text AS text_16, t0.text_resume AS text_resume_17, t0.date_published AS date_published_18, t0.expire AS expire_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.date_created AS date_created_22, t0.date_modified AS date_modified_23, t0.primary_image_id AS primary_image_id_24, t0.secondary_image_id AS secondary_image_id_25, t0.category_id AS category_id_26, t0.type_id AS type_id_27, t0.user_created_id AS user_created_id_28, t0.user_last_modified_id AS user_last_modified_id_29 FROM article t0 WHERE t0.category_id IN (?) AND t0.is_active = ?
Parameters:
[ [ 36 ] 1 ] |
1.34 ms (1.58%) |
1 |
SELECT t0.id AS id_1, t0.article_body AS article_body_2, t0.article_resume AS article_resume_3, t0.last_reviewed AS last_reviewed_4, t0.slug AS slug_5, t0.is_active AS is_active_6, t0.is_indexable AS is_indexable_7, t0.icon AS icon_8, t0.name AS name_9, t0.description AS description_10, t0.url AS url_11, t0.main_entity_of_page AS main_entity_of_page_12, t0.headline AS headline_13, t0.alternative_headline AS alternative_headline_14, t0.push_forward AS push_forward_15, t0.text AS text_16, t0.text_resume AS text_resume_17, t0.date_published AS date_published_18, t0.expire AS expire_19, t0.meta_title AS meta_title_20, t0.meta_description AS meta_description_21, t0.date_created AS date_created_22, t0.date_modified AS date_modified_23, t0.primary_image_id AS primary_image_id_24, t0.secondary_image_id AS secondary_image_id_25, t0.category_id AS category_id_26, t0.type_id AS type_id_27, t0.user_created_id AS user_created_id_28, t0.user_last_modified_id AS user_last_modified_id_29 FROM article t0 WHERE t0.category_id IN (?) AND t0.is_active = ? ORDER BY t0.id DESC LIMIT 3
Parameters:
[ [ 24 ] 1 ] |
0.96 ms (1.13%) |
1 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.foundingDate AS foundingDate_6, t0.number_of_employees AS number_of_employees_7, t0.number_of_projects AS number_of_projects_8, t0.mobile_phone AS mobile_phone_9, t0.id AS id_10, t0.description AS description_11, t0.url AS url_12, t0.main_entity_of_page AS main_entity_of_page_13, t0.date_created AS date_created_14, t0.date_modified AS date_modified_15, t0.organization_type_id AS organization_type_id_16, t0.primary_image_id AS primary_image_id_17, t0.secondary_image_id AS secondary_image_id_18, t0.organization_id AS organization_id_19, t0.user_created_id AS user_created_id_20, t0.user_last_modified_id AS user_last_modified_id_21 FROM organization t0 WHERE t0.organization_id = ?
Parameters:
[
4
]
|
0.94 ms (1.11%) |
1 |
SELECT t0.slug AS slug_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.phone AS phone_4, t0.email AS email_5, t0.foundingDate AS foundingDate_6, t0.number_of_employees AS number_of_employees_7, t0.number_of_projects AS number_of_projects_8, t0.mobile_phone AS mobile_phone_9, t0.id AS id_10, t0.description AS description_11, t0.url AS url_12, t0.main_entity_of_page AS main_entity_of_page_13, t0.date_created AS date_created_14, t0.date_modified AS date_modified_15, t0.organization_type_id AS organization_type_id_16, t0.primary_image_id AS primary_image_id_17, t0.secondary_image_id AS secondary_image_id_18, t0.organization_id AS organization_id_19, t0.user_created_id AS user_created_id_20, t0.user_last_modified_id AS user_last_modified_id_21 FROM organization t0 WHERE t0.organization_type_id = ?
Parameters:
[
2
]
|
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\WebPage | No errors. |
App\Entity\MediaObject | No errors. |
App\Entity\Tag | No errors. |
App\Entity\User | No errors. |
App\Entity\Component | No errors. |
App\Entity\SlideMediaObject | No errors. |
App\Entity\OrganizationType | No errors. |
App\Entity\Article | No errors. |
App\Entity\Person | No errors. |
App\Entity\Gender | No errors. |
App\Entity\PersonPosition | No errors. |
App\Entity\PersonNature | No errors. |
App\Entity\Address | No errors. |
App\Entity\Organization | No errors. |
App\Entity\PropertyValue | No errors. |
App\Entity\Parameter | No errors. |
App\Entity\Blockquote | No errors. |
App\Entity\Slide | No errors. |
App\Entity\Comment | No errors. |