Query Metrics
189
Database Queries
4
Different statements
23.81 ms
Query time
0
Invalid entities
4690
Managed entities
Grouped Statements
| 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
| Class | Mapping errors |
|---|---|
| App\Entity\Commune | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\StructureReseauSocial | No errors. |
| App\Entity\ContenuQualification\Departement | No errors. |
| App\Entity\Jeune | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\MenuJeune | No errors. |