Query Metrics
5
Database Queries
5
Different statements
2.16 ms
Query time
9
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.72 ms |
SELECT a0_.id AS id_0, a0_.fichier AS fichier_1, a0_.nom_original AS nom_original_2, a0_.date_arrete AS date_arrete_3, a0_.date_inserion AS date_inserion_4, a0_.libelle AS libelle_5, a0_.numero_ordre AS numero_ordre_6, a0_.numero AS numero_7, a0_.id_dw AS id_dw_8, a0_.is_publish AS is_publish_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.deleted_at AS deleted_at_12, a0_.sous_categorie_arrete_id AS sous_categorie_arrete_id_13, a0_.type_arrete_id AS type_arrete_id_14, a0_.user_id AS user_id_15 FROM arrete a0_ WHERE a0_.is_publish = 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.52 ms |
SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.nom AS nom_14, t0.date_creation AS date_creation_15, t0.id_dw AS id_dw_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.operateur_id AS operateur_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM dot t0 WHERE t0.arrete_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 3 | 0.30 ms |
SELECT t0.id AS id_1, t0.membre_communaute_local1 AS membre_communaute_local1_2, t0.membre_communaute_local2 AS membre_communaute_local2_3, t0.membre_organisation_communautaire1 AS membre_organisation_communautaire1_4, t0.membre_organisation_communautaire2 AS membre_organisation_communautaire2_5, t0.membre_operateur1 AS membre_operateur1_6, t0.membre_operateur2 AS membre_operateur2_7, t0.membre_autorite1 AS membre_autorite1_8, t0.membre_autorite2 AS membre_autorite2_9, t0.membre_fonds_national1 AS membre_fonds_national1_10, t0.membre_fonds_national2 AS membre_fonds_national2_11, t0.membre_direction1 AS membre_direction1_12, t0.membre_direction2 AS membre_direction2_13, t0.date_nomination AS date_nomination_14, t0.id_dw AS id_dw_15, t0.is_publish AS is_publish_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.deleted_at AS deleted_at_19, t0.dot_id AS dot_id_20, t0.arrete_id AS arrete_id_21, t0.user_id AS user_id_22 FROM comite_pilotage_dot t0 WHERE t0.arrete_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 4 | 0.30 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM type_arrete t0
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.id_dw AS id_dw_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.categorie_id AS categorie_id_7, t0.user_id AS user_id_8 FROM sous_categorie_arrete t0 WHERE t0.id = ?
Parameters:
[
8
]
|
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\Transparence\Arrete |
|
| App\Entity\Transparence\SousCategorieArrete |
|
| App\Entity\Transparence\TypeArrete |
|
| App\Entity\User |
|
| App\Entity\Operateur\Dot |
|
| App\Entity\Operateur\Operateur |
|
| App\Entity\Operateur\ProjetDot |
|
| App\Entity\Operateur\ComitePilotageDot |
|
| App\Entity\Transparence\CategorieArrete |
|