Query Metrics

189 Database Queries
4 Different statements
23.81 ms Query time
0 Invalid entities
4690 Managed entities

Grouped Statements

Show all queries

Time Count Info
15.67 ms
(65.80%)
135
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_postal AS code_postal_3, t0.lon AS lon_4, t0.lat AS lat_5, t0.departement_id AS departement_id_6 FROM commune t0 WHERE t0.id = ?
Parameters:
[
  33318
]
6.23 ms
(26.18%)
52
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  0
]
1.41 ms
(5.90%)
1
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.reset_token AS reset_token_4, s1_.nom AS nom_5, s1_.telephone AS telephone_6, s1_.logo AS logo_7, s1_.updated_logo_at AS updated_logo_at_8, s1_.site_internet AS site_internet_9, s1_.detail AS detail_10, s1_.lien_jot_form AS lien_jot_form_11, s1_.slug AS slug_12, s1_.crij AS crij_13, s1_.created_by AS created_by_14, s1_.updated_by AS updated_by_15, s1_.created_date AS created_date_16, s1_.update_date AS update_date_17, s1_.publie AS publie_18, s1_.adresse AS adresse_19, s1_.longitude AS longitude_20, s1_.latitude AS latitude_21, u0_.type AS type_22, s1_.commune_id AS commune_id_23 FROM structure s1_ INNER JOIN user u0_ ON s1_.id = u0_.id WHERE s1_.publie = ? ORDER BY s1_.nom ASC
Parameters:
[
  1
]
0.50 ms
(2.12%)
1
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.code_postal AS code_postal_2, c0_.lon AS lon_3, c0_.lat AS lat_4, c0_.departement_id AS departement_id_5 FROM commune c0_
Parameters:
[]

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\Commune 4314
App\Entity\MenuJeune 205
App\Entity\User 159
App\Entity\ContenuQualification\Departement 12

Entities Mapping