Query Metrics

14 Database Queries
10 Different statements
7.70 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.32 ms
(30.16%)
3
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.date AS date_7, t0.nb_vues AS nb_vues_8, t0.resume_fr AS resume_fr_9, t0.resume_en AS resume_en_10, t0.intro_fr AS intro_fr_11, t0.intro_en AS intro_en_12, t0.afficher AS afficher_13, t0.categories_actualites_id AS categories_actualites_id_14 FROM actualites t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "27"
]
1.61 ms
(20.89%)
1
"COMMIT"
Parameters:
[]
0.68 ms
(8.85%)
1
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.date AS date_7, t0.nb_vues AS nb_vues_8, t0.resume_fr AS resume_fr_9, t0.resume_en AS resume_en_10, t0.intro_fr AS intro_fr_11, t0.intro_en AS intro_en_12, t0.afficher AS afficher_13, t0.categories_actualites_id AS categories_actualites_id_14 FROM actualites t0 ORDER BY t0.nb_vues DESC LIMIT 5
Parameters:
[]
0.57 ms
(7.43%)
1
UPDATE actualites SET nb_vues = ? WHERE id = ?
Parameters:
[
  758
  27
]
0.55 ms
(7.16%)
2
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.video AS video_7, t0.document AS document_8, t0.background AS background_9, t0.couleur1 AS couleur1_10, t0.couleur2 AS couleur2_11, t0.position AS position_12, t0.lien AS lien_13, t0.modal AS modal_14, t0.blocs_id AS blocs_id_15, t0.types_contenus_id AS types_contenus_id_16 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  732
]
0.46 ms
(6.01%)
2
SELECT t0.id AS id_1, t0.type AS type_2, t0.color1 AS color1_3, t0.color2 AS color2_4, t0.lignes_id AS lignes_id_5 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  182
]
0.45 ms
(5.78%)
1
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3 FROM categories_actualites t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.41 ms
(5.37%)
1
SELECT t0.id AS id_1, t0.image AS image_2, t0.color AS color_3, t0.ordre AS ordre_4, t0.rond AS rond_5, t0.pages_id AS pages_id_6, t0.actualites_id AS actualites_id_7, t0.jobs_id AS jobs_id_8, t0.formations_id AS formations_id_9 FROM sections t0 WHERE t0.actualites_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  27
]
0.37 ms
(4.82%)
1
"START TRANSACTION"
Parameters:
[]
0.27 ms
(3.52%)
1
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  960
]

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\Actualites No errors.
App\Entity\Sections No errors.
App\Entity\CategoriesActualites No errors.
App\Entity\Pages No errors.
App\Entity\Jobs No errors.
App\Entity\Formations No errors.
App\Entity\Lignes No errors.
App\Entity\Blocs No errors.
App\Entity\Contenus No errors.
App\Entity\TypesContenus No errors.
App\Entity\Accordeons No errors.
App\Entity\Carousels No errors.