Query Metrics

180 Database Queries
7 Different statements
53.03 ms Query time
3 Invalid entities
94 Managed entities

Grouped Statements

Show all queries

Time Count Info
43.88 ms
(82.74%)
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
]
5.63 ms
(10.62%)
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.15 ms
(2.18%)
1
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.slug = ? LIMIT 1
Parameters:
[
  "faq"
]
0.72 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.64 ms
(1.21%)
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.50 ms
(0.95%)
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.50 ms
(0.94%)
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
]

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\Pages 1
App\Entity\Categoriepages 1
App\Entity\Menus 1

Entities Mapping

Class Mapping 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\Faqcategorys No errors.
App\Entity\Settingsite No errors.
App\Entity\Menus No errors.
App\Entity\Menuitems No errors.