Query Metrics
188
Database Queries
15
Different statements
69.67 ms
Query time
0
Invalid entities
93
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
54.84 ms (78.71%) |
166 |
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:
[
6
]
|
|
6.10 ms (8.75%) |
9 |
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:
[ 5 226 1 ] |
|
1.05 ms (1.50%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.descriptions AS descriptions_4, t0.excerpt AS excerpt_5, t0.imagealaune AS imagealaune_6, t0.thumb AS thumb_7, t0.alune AS alune_8, t0.created AS created_9, t0.updated AS updated_10, t0.ispublic AS ispublic_11, t0.isfuture AS isfuture_12, t0.dateactu AS dateactu_13, t0.orderact AS orderact_14, t0.nbrvisite AS nbrvisite_15, t0.ceotitle AS ceotitle_16, t0.ceodescription AS ceodescription_17, t0.seokeywords AS seokeywords_18, t0.canonical AS canonical_19, t0.author AS author_20 FROM actualites t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"les-nouvelles-de-notre-ecorucher-n-3-mai-2020"
]
|
|
0.94 ms (1.35%) |
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.92 ms (1.32%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.descriptions AS descriptions_3, a0_.excerpt AS excerpt_4, a0_.imagealaune AS imagealaune_5, a0_.thumb AS thumb_6, a0_.alune AS alune_7, a0_.created AS created_8, a0_.updated AS updated_9, a0_.ispublic AS ispublic_10, a0_.isfuture AS isfuture_11, a0_.dateactu AS dateactu_12, a0_.orderact AS orderact_13, a0_.nbrvisite AS nbrvisite_14, a0_.ceotitle AS ceotitle_15, a0_.ceodescription AS ceodescription_16, a0_.seokeywords AS seokeywords_17, a0_.canonical AS canonical_18, a0_.author AS author_19 FROM actualites a0_ WHERE a0_.ispublic = ? ORDER BY a0_.dateactu DESC LIMIT 10
Parameters:
[
1
]
|
|
0.91 ms (1.31%) |
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:
[ 111 112 110 109 107 108 106 103 105 104 "ACTUALITE" ] |
|
0.82 ms (1.18%) |
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.75 ms (1.07%) |
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.70 ms (1.00%) |
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:
[ 60 "ACTUALITE" ] |
|
0.65 ms (0.94%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.56 ms (0.81%) |
1 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.descriptions AS descriptions_3, a0_.excerpt AS excerpt_4, a0_.imagealaune AS imagealaune_5, a0_.thumb AS thumb_6, a0_.alune AS alune_7, a0_.created AS created_8, a0_.updated AS updated_9, a0_.ispublic AS ispublic_10, a0_.isfuture AS isfuture_11, a0_.dateactu AS dateactu_12, a0_.orderact AS orderact_13, a0_.nbrvisite AS nbrvisite_14, a0_.ceotitle AS ceotitle_15, a0_.ceodescription AS ceodescription_16, a0_.seokeywords AS seokeywords_17, a0_.canonical AS canonical_18, a0_.author AS author_19 FROM actualites a0_ WHERE a0_.slug = ?
Parameters:
[
"les-nouvelles-de-notre-ecorucher-n-3-mai-2020"
]
|
|
0.45 ms (0.65%) |
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.41 ms (0.59%) |
1 |
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"
]
|
|
0.38 ms (0.55%) |
1 |
UPDATE actualites SET nbrvisite = ? WHERE id = ?
Parameters:
[ 5607 60 ] |
|
0.19 ms (0.27%) |
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 | 91 |
| App\Entity\Actualites | 1 |
| App\Entity\Menus | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Actualites | No errors. |
| App\Entity\Mediapages | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Settingsite | No errors. |
| App\Entity\Menus | No errors. |
| App\Entity\Menuitems | No errors. |
| App\Entity\Article | No errors. |