https://cimef-international.org/nos-thematiques/mine-petrole/inspections-audits-et-controles-sur-produits-petroliers

Query Metrics

6 Database Queries
6 Different statements
18.63 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
15.47 ms
(83.05%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4, t0.thematique_id AS thematique_id_5 FROM themes t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "inspections-audits-et-controles-sur-produits-petroliers"
]
0.97 ms
(5.20%)
1
SELECT f0_.id AS id_0, f0_.dates_session AS dates_session_1, f0_.prix AS prix_2, f0_.devise AS devise_3, t1_.nom AS nom_4, t2_.nom AS nom_5, v3_.nom AS nom_6, v3_.pays AS pays_7, f0_.created_at AS created_at_8, t1_.slug AS slug_9, t1_.description AS description_10, f0_.devise AS devise_11, v3_.longitude AS longitude_12, v3_.latitude AS latitude_13 FROM formations f0_ INNER JOIN themes t1_ ON (f0_.theme_id = t1_.id) INNER JOIN villes v3_ ON (f0_.ville_id = v3_.id) INNER JOIN thematiques t2_ ON (t1_.thematique_id = t2_.id) WHERE f0_.theme_id = ? GROUP BY f0_.id ORDER BY f0_.created_at DESC LIMIT 1
Parameters:
[
  809
]
0.77 ms
(4.14%)
1
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.slug AS slug_3, t0.image AS image_4, t0.ville AS ville_5, t0.devise AS devise_6, t0.datedebut AS datedebut_7, t0.datefin AS datefin_8, t0.prix AS prix_9, t0.texte AS texte_10, t0.adminsid AS adminsid_11, t0.createdat AS createdat_12, t0.updatedat AS updatedat_13 FROM managements t0 ORDER BY t0.id DESC LIMIT 5
Parameters:
[]
0.52 ms
(2.81%)
1
SELECT v0_.nom AS nom_0, v0_.pays AS pays_1 FROM formations f1_ INNER JOIN themes t2_ ON (f1_.theme_id = t2_.id) INNER JOIN villes v0_ ON (f1_.ville_id = v0_.id) INNER JOIN thematiques t3_ ON (t2_.thematique_id = t3_.id) WHERE f1_.theme_id = ?
Parameters:
[
  809
]
0.47 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.titremen AS titremen_2, t0.slug AS slug_3, t0.detailmen AS detailmen_4, t0.statutmen AS statutmen_5, t0.adminsid AS adminsid_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM mentions t0
Parameters:
[]
0.42 ms
(2.27%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.description AS description_4 FROM thematiques t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "mine-petrole"
]

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\Managements No errors.
App\Entity\Thematiques No errors.
App\Entity\Themes No errors.
App\Entity\Formations No errors.
App\Entity\Villes No errors.
App\Entity\Mentions No errors.