GET http://www-test.eco2net.ch/particuliers/ecoexclusif-menage/la-collaboration-en-5-points

Query Metrics

256 Database Queries
17 Different statements
95.29 ms Query time
4 Invalid entities
103 Managed entities

Grouped Statements

Show all queries

Time Count Info
71.61 ms
(75.15%)
218
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12 FROM menuitems m0_ WHERE m0_.id = ? LIMIT 1
Parameters:
[
  193
]
7.74 ms
(8.13%)
11
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE m0_.parentid = ? AND m1_.id = ? AND m0_.ispublish = ? AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC
Parameters:
[
  111
  226
  1
]
2.17 ms
(2.28%)
4
SELECT t0.id AS id_1, t0.title AS title_2, t0.author AS author_3, t0.seotitle AS seotitle_4, t0.seodescription AS seodescription_5, t0.canonical AS canonical_6, t0.seokeywords AS seokeywords_7, t0.slug AS slug_8, t0.contenu AS contenu_9, t0.is_public AS is_public_10, t0.nbrvisite AS nbrvisite_11, t0.created AS created_12, t0.updated AS updated_13, t0.imagealaune AS imagealaune_14, t0.categoriespages_id AS categoriespages_id_15 FROM pages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  410
]
1.94 ms
(2.03%)
2
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE (m0_.parentid = ? AND m0_.is_accordiant = ?) AND m0_.ispublish = ? ORDER BY m0_.rang ASC
Parameters:
[
  106
  1
  1
]
1.93 ms
(2.03%)
5
SELECT t0.id AS id_1, t0.thumb AS thumb_2, t0.name AS name_3, t0.slug AS slug_4, t0.color AS color_5, t0.type AS type_6, t0.externallink AS externallink_7, t0.rang AS rang_8, t0.parentid AS parentid_9, t0.is_accordiant AS is_accordiant_10, t0.subjectid AS subjectid_11, t0.ispublish AS ispublish_12, t0.widgetId AS widgetId_13, t0.menus_id AS menus_id_14 FROM menuitems t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  106
]
1.69 ms
(1.77%)
3
SELECT t0.id AS id_1, t0.thumb AS thumb_2, t0.name AS name_3, t0.slug AS slug_4, t0.color AS color_5, t0.type AS type_6, t0.externallink AS externallink_7, t0.rang AS rang_8, t0.parentid AS parentid_9, t0.is_accordiant AS is_accordiant_10, t0.subjectid AS subjectid_11, t0.ispublish AS ispublish_12, t0.widgetId AS widgetId_13, t0.menus_id AS menus_id_14 FROM menuitems t0 WHERE t0.slug = ? AND t0.parentid = ? LIMIT 1
Parameters:
[
  "particuliers"
  0
]
1.66 ms
(1.74%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.ispublish AS ispublish_4, t0.rang AS rang_5 FROM menus t0 WHERE t0.position = ? LIMIT 1
Parameters:
[
  "MAIN"
]
1.13 ms
(1.18%)
2
SELECT p0_.id AS id_0, p0_.orderwidget AS orderwidget_1, p0_.position AS position_2, p1_.id AS id_3, p1_.title AS title_4, p1_.author AS author_5, p1_.seotitle AS seotitle_6, p1_.seodescription AS seodescription_7, p1_.canonical AS canonical_8, p1_.seokeywords AS seokeywords_9, p1_.slug AS slug_10, p1_.contenu AS contenu_11, p1_.is_public AS is_public_12, p1_.nbrvisite AS nbrvisite_13, p1_.created AS created_14, p1_.updated AS updated_15, p1_.imagealaune AS imagealaune_16, w2_.id AS id_17, w2_.title AS title_18, w2_.url AS url_19, w2_.menuitemid AS menuitemid_20, w2_.objectid AS objectid_21, w2_.linktype AS linktype_22, w2_.addcontactform AS addcontactform_23, w2_.showtitle AS showtitle_24, w2_.addlink AS addlink_25, w2_.linkdestination AS linkdestination_26, w2_.description AS description_27, w2_.ispublic AS ispublic_28, w2_.nbrview AS nbrview_29 FROM pagewidgets p0_ INNER JOIN pages p1_ ON p0_.pages_id = p1_.id INNER JOIN widget w2_ ON p0_.widget_id = w2_.id WHERE p1_.id = ? AND p0_.position = ? AND w2_.ispublic = ? ORDER BY p0_.orderwidget ASC
Parameters:
[
  291
  "left"
  1
]
0.95 ms
(1.00%)
1
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE (m0_.parentid IS NULL OR m0_.parentid = ?) AND m1_.id = ? AND m0_.ispublish = ? AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC
Parameters:
[
  0
  226
  1
]
0.88 ms
(0.92%)
1
SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE m0_.parentid = ? AND m0_.ispublish = ? ORDER BY m0_.rang ASC
Parameters:
[
  183
  1
]
0.72 ms
(0.75%)
1
SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid = ? AND m0_.modulename = ?
Parameters:
[
  291
  "PAGES"
]
0.69 ms
(0.72%)
1
SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid IN (?, ?, ?) AND m0_.modulename = ?
Parameters:
[
  214
  212
  210
  "BLOG"
]
0.64 ms
(0.67%)
1
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.excerpt AS excerpt_3, a0_.isblogarticle AS isblogarticle_4, a0_.content AS content_5, a0_.created AS created_6, a0_.datearticle AS datearticle_7, a0_.orderartc AS orderartc_8, a0_.nbrvisite AS nbrvisite_9, a0_.updated AS updated_10, a0_.author AS author_11, a0_.ceotitle AS ceotitle_12, a0_.ceodescription AS ceodescription_13, a0_.canonical AS canonical_14, a0_.seokeywords AS seokeywords_15, a0_.imagealaune AS imagealaune_16, a0_.imagealaunethumb AS imagealaunethumb_17, a0_.ispublic AS ispublic_18, a0_.isinhomepage AS isinhomepage_19, a0_.isfuture AS isfuture_20 FROM article a0_ WHERE a0_.ispublic = ? AND a0_.isinhomepage = ? AND (a0_.isfuture = ? OR a0_.isfuture IS NULL) ORDER BY a0_.datearticle DESC LIMIT 3
Parameters:
[
  1
  1
  0
]
0.53 ms
(0.56%)
1
"COMMIT"
Parameters:
[]
0.48 ms
(0.50%)
1
SELECT s0_.id AS id_0, s0_.groupname AS groupname_1, s0_.grouplibeller AS grouplibeller_2, s0_.libeller AS libeller_3, s0_.name AS name_4, s0_.fieldtype AS fieldtype_5, s0_.helptext AS helptext_6, s0_.settingvalue AS settingvalue_7, s0_.witheditor AS witheditor_8, s0_.ordre AS ordre_9, s0_.created AS created_10, s0_.updated AS updated_11 FROM settingsite s0_ WHERE s0_.groupname IN (?) ORDER BY s0_.ordre ASC
Parameters:
[
  "globalparams"
]
0.35 ms
(0.37%)
1
UPDATE pages SET nbrvisite = ? WHERE id = ?
Parameters:
[
  6211
  291
]
0.18 ms
(0.19%)
1
"START TRANSACTION"
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\Menuitems 98
App\Entity\Pages 3
App\Entity\Menus 1
App\Entity\Categoriepages 1

Entities Mapping

Class Mapping errors
App\Entity\Menus No errors.
App\Entity\Menuitems No errors.
App\Entity\Pages
  • The mappings App\Entity\Pages#pictures and App\Entity\Pagepictures#page are inconsistent with each other.
App\Entity\Categoriepages
  • The association App\Entity\Categoriepages#categoriepictures refers to the owning side field App\Entity\Categoriepictures#categoriespages which does not exist.
App\Entity\Pagepictures
  • The association App\Entity\Pagepictures#page refers to the inverse side field App\Entity\Pages#pagepictures which does not exist.
App\Entity\Pagewidgets No errors.
App\Entity\Mediapages No errors.
App\Entity\Media No errors.
App\Entity\Widget No errors.
App\Entity\Settingsite No errors.
App\Entity\Categoriepictures
  • The mappings App\Entity\Categoriepictures#categoriepages and App\Entity\Categoriepages#categoriepictures are inconsistent with each other.
App\Entity\WidgetCategory No errors.
App\Entity\Article No errors.