Query Metrics
13
Database Queries
10
Different statements
31.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.51 ms |
SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.host IN (?) AND t0.enabled = ? ORDER BY t0.is_default DESC
Parameters: [
0 => [
0 => www.vb.dev2.intercode.ca,
1 => localhost
],
1 => 1
]
|
| 2 | 7.57 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.url = ? LIMIT 1
Parameters: [0 => 2026-04-03 13:31:02, 1 => 2026-04-03 13:31:02, 2 => 1, 3 => /liens-utiles]
|
| 3 | 1.58 ms |
SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = ?
Parameters: [0 => 179]
|
| 4 | 1.36 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = ? AND p0_.enabled = 1
Parameters: [0 => 171]
|
| 5 | 7.89 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.name AS name_6, p0_.url AS url_7, p0_.parent_id AS parent_id_8, p0_.target_id AS target_id_9, p0_.content AS content_10, p0_.publication_date_start AS publication_date_start_11, p0_.publication_date_end AS publication_date_end_12, p0_.created_at AS created_at_13, p0_.updated_at AS updated_at_14, p0_.id AS id_15, p0_.site_id AS site_id_16, p0_.page_id AS page_id_17 FROM page__snapshot p0_ WHERE (p0_.publication_date_start <= ? AND (p0_.publication_date_end IS NULL OR p0_.publication_date_end >= ?)) AND p0_.enabled = 1 AND p0_.site_id = ? AND p0_.route_name = ? LIMIT 1
Parameters: [0 => 2026-04-03 13:31:02, 1 => 2026-04-03 13:31:02, 2 => 1, 3 => _page_internal_global]
|
| 6 | 1.22 ms |
SELECT p0_.id AS id_0, p0_.translateId AS translateId_1, p0_.pageId AS pageId_2, p0_.siteId AS siteId_3 FROM page_translate p0_ WHERE p0_.pageId = ?
Parameters: [0 => 79]
|
| 7 | 1.12 ms |
SELECT p0_.route_name AS route_name_0, p0_.page_alias AS page_alias_1, p0_.type AS type_2, p0_.position AS position_3, p0_.enabled AS enabled_4, p0_.decorate AS decorate_5, p0_.edited AS edited_6, p0_.name AS name_7, p0_.slug AS slug_8, p0_.url AS url_9, p0_.custom_url AS custom_url_10, p0_.request_method AS request_method_11, p0_.title AS title_12, p0_.meta_keyword AS meta_keyword_13, p0_.meta_description AS meta_description_14, p0_.javascript AS javascript_15, p0_.stylesheet AS stylesheet_16, p0_.raw_headers AS raw_headers_17, p0_.template AS template_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.id AS id_21, p0_.site_id AS site_id_22, p0_.parent_id AS parent_id_23, p0_.target_id AS target_id_24 FROM page__page p0_ WHERE p0_.id = ? AND p0_.enabled = 1
Parameters: [0 => 84]
|
| 8 | 1.33 ms |
SELECT a0_.id AS id_0, a0_.locale AS locale_1, a0_.message AS message_2, a0_.enabled AS enabled_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.createdDate AS createdDate_6, a0_.modifiedDate AS modifiedDate_7 FROM alert_banner a0_ WHERE a0_.locale = ? AND a0_.enabled = 1 AND a0_.start_date <= ? AND a0_.end_date >= ?
Parameters: [0 => fr, 1 => 2026-04-03 13:31:02, 2 => 2026-04-03 13:31:02]
|
| 9 | 1.21 ms |
SELECT t0.enabled AS enabled_1, t0.name AS name_2, t0.relative_path AS relative_path_3, t0.host AS host_4, t0.enabled_from AS enabled_from_5, t0.enabled_to AS enabled_to_6, t0.is_default AS is_default_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.title AS title_11, t0.meta_keywords AS meta_keywords_12, t0.meta_description AS meta_description_13, t0.id AS id_14 FROM page__site t0 WHERE t0.enabled = ?
Parameters: [0 => 1]
|
| 10 | 1.50 ms |
SELECT COUNT(w0_.id) AS sclr_0 FROM wicrew_cruise w0_ WHERE w0_.locale = ? AND w0_.active = ? AND w0_.departure_date >= ? AND (w0_.published_from IS NULL OR w0_.published_from <= ?) AND (w0_.published_to IS NULL OR w0_.published_to >= ?)
Parameters: [0 => fr, 1 => 1, 2 => 2026-04-03, 3 => 2026-04-03, 4 => 2026-04-03]
|
| 11 | 1.22 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.settings AS settings_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.parent_id AS parent_id_9, t0.page_id AS page_id_10 FROM page__block t0 WHERE t0.id = ? LIMIT 1
Parameters: [0 => 232]
|
| 12 | 0.83 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.settings AS settings_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.parent_id AS parent_id_9, t0.page_id AS page_id_10 FROM page__block t0 WHERE t0.id = ? LIMIT 1
Parameters: [0 => 232]
|
| 13 | 2.09 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.settings AS settings_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.parent_id AS parent_id_9, t0.page_id AS page_id_10 FROM page__block t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters: [0 => 232]
|
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 |
|---|---|
| FOS\UserBundle\Entity\User | No errors. |
| Sonata\UserBundle\Entity\BaseUser | No errors. |
| Application\Sonata\UserBundle\Entity\User | No errors. |
| Sonata\PageBundle\Entity\BaseSite | No errors. |
| Application\Sonata\PageBundle\Entity\Site | No errors. |
| Sonata\PageBundle\Entity\BaseSnapshot | No errors. |
| Application\Sonata\PageBundle\Entity\Snapshot | No errors. |
| Sonata\PageBundle\Entity\BasePage | No errors. |
| Application\Sonata\PageBundle\Entity\Page | No errors. |
| Application\Sonata\PageTranslationBundle\Entity\PageTranslate | No errors. |
| Sonata\PageBundle\Entity\BaseBlock | No errors. |
| Application\Sonata\PageBundle\Entity\Block | No errors. |
| BergeronBundle\Entity\AlertBanner | No errors. |
| Wicrew\CruiseBundle\Entity\Cruise | No errors. |