Query Metrics
181
Database Queries
8
Different statements
60.99 ms
Query time
0
Invalid entities
93
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
50.12 ms (82.18%) |
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.41 ms (10.50%) |
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.06 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.ispublic AS ispublic_6, t0.catorder AS catorder_7 FROM faqcategorys t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"questions-frequentes-concernant-notre-societe-de-nettoyage-eco2net-sa"
]
|
|
0.97 ms (1.59%) |
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.75 ms (1.22%) |
1 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.title AS title_2, f0_.content AS content_3, f0_.slug AS slug_4, f0_.ispublic AS ispublic_5, f0_.catorder AS catorder_6 FROM faqcategorys f0_ WHERE f0_.ispublic = ? ORDER BY f0_.catorder ASC
Parameters:
[
1
]
|
|
0.69 ms (1.12%) |
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.57 ms (0.94%) |
1 |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.ispublic AS ispublic_3, f0_.questionorder AS questionorder_4 FROM faqs f0_ INNER JOIN faqcategorys f1_ ON f0_.faqcategorys_id = f1_.id WHERE f0_.ispublic = ? AND f1_.ispublic = ? AND f1_.id = ?
Parameters:
[ 1 1 8 ] |
|
0.43 ms (0.71%) |
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"
]
|
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\Faqcategorys | 1 |
| App\Entity\Menus | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Faqcategorys | No errors. |
| App\Entity\Faqs | No errors. |
| App\Entity\Settingsite | No errors. |
| App\Entity\Menus | No errors. |
| App\Entity\Menuitems | No errors. |