Query Metrics
28
Database Queries
12
Different statements
43.00 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
25.22 ms (58.65%) |
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
]
|
2.83 ms (6.59%) |
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:
[
"contact"
]
|
2.72 ms (6.32%) |
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"
]
|
2.06 ms (4.79%) |
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
]
|
1.89 ms (4.40%) |
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:
[
6
]
|
1.62 ms (3.77%) |
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:
[] |
1.59 ms (3.71%) |
1 |
SELECT COUNT(*) FROM article t0 WHERE t0.category_id IN (?)
Parameters:
[
[
24
]
]
|
1.32 ms (3.07%) |
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
]
|
1.30 ms (3.01%) |
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"
]
|
0.86 ms (2.01%) |
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
]
|
0.80 ms (1.87%) |
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"
]
|
0.78 ms (1.81%) |
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"
]
|
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. |