Query Metrics

18 Database Queries
11 Different statements
15.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.36 ms
(72.01%)
1
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.actif AS actif_4, t0.pages_id AS pages_id_5 FROM pages_content t0 WHERE t0.pages_id = ? AND t0.actif = ? LIMIT 1
Parameters:
[
  7
  1
]
1.55 ms
(9.80%)
7
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.text AS text_3, t0.legendeimg1 AS legendeimg1_4, t0.img1 AS img1_5, t0.legendeimg2 AS legendeimg2_6, t0.img2 AS img2_7, t0.lien AS lien_8, t0.ordre AS ordre_9, t0.sections_accueil_items_id AS sections_accueil_items_id_10 FROM sections_accueil_items t0 WHERE t0.sections_accueil_items_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  2
]
0.68 ms
(4.34%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "dgscreation_Symfony_Saas"
]
0.49 ms
(3.08%)
1
SELECT t0.id AS id_1, t0.ipmaintenance AS ipmaintenance_2, t0.modemaintenance AS modemaintenance_3, t0.fa_google_active AS fa_google_active_4 FROM admin_maintenance t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.33 ms
(2.12%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sstitre AS sstitre_3, t0.lien AS lien_4, t0.ordre AS ordre_5, t0.legendeimg1 AS legendeimg1_6, t0.img1 AS img1_7 FROM sections_accueil t0 ORDER BY t0.ordre ASC
Parameters:
[]
0.28 ms
(1.80%)
2
SELECT DATABASE()
Parameters:
[]
0.25 ms
(1.59%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sstitre AS sstitre_3, t0.lien AS lien_4, t0.ordre AS ordre_5, t0.legendeimg1 AS legendeimg1_6, t0.img1 AS img1_7 FROM sections_accueil t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  2
]
0.22 ms
(1.38%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.menuparent AS menuparent_3, t0.parent AS parent_4, t0.niveau AS niveau_5, t0.datecreation AS datecreation_6, t0.urlname AS urlname_7, t0.page_id AS page_id_8 FROM menu_footer t0
Parameters:
[]
0.22 ms
(1.36%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seotitre AS seotitre_3, t0.seometa AS seometa_4, t0.cover AS cover_5, t0.url AS url_6, t0.excerpt AS excerpt_7, t0.datecreation AS datecreation_8, t0.actif AS actif_9, t0.couleur AS couleur_10, t0.user_id AS user_id_11 FROM pages t0 WHERE t0.url = ? AND t0.actif = ? LIMIT 1
Parameters:
[
  "sitemap.xml"
  1
]
0.20 ms
(1.29%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.menuparent AS menuparent_3, t0.parent AS parent_4, t0.niveau AS niveau_5, t0.datecreation AS datecreation_6, t0.urlname AS urlname_7, t0.page_id AS page_id_8 FROM menu_header t0
Parameters:
[]
0.19 ms
(1.22%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.seotitre AS seotitre_3, t0.seometa AS seometa_4, t0.cover AS cover_5, t0.url AS url_6, t0.excerpt AS excerpt_7, t0.datecreation AS datecreation_8, t0.actif AS actif_9, t0.couleur AS couleur_10, t0.user_id AS user_id_11 FROM pages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  7
]

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
App\Entity\AdminMaintenance No errors.
App\Entity\Pages No errors.
App\Entity\User No errors.
App\Entity\PagesContent No errors.
App\Entity\SectionsAccueil No errors.
App\Entity\SectionsAccueilItems No errors.
App\Entity\MenuHeader No errors.
App\Entity\ACL No errors.
App\Entity\MenuFooter No errors.