Query Metrics
3
Database Queries
3
Different statements
165.53 ms
Query time
0
Invalid entities
184
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
91.67 ms (55.38%) |
1 |
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.statut AS statut_2, s0_.contact AS contact_3, s0_.adresse AS adresse_4, s0_.code_postal AS code_postal_5, s0_.ville AS ville_6, s0_.latitude AS latitude_7, s0_.longitude AS longitude_8, s0_.is_visible_carte_jeune AS is_visible_carte_jeune_9, s0_.role_information AS role_information_10, s0_.role_accompagnement AS role_accompagnement_11, s0_.organise_mobilite AS organise_mobilite_12, s0_.is_visible_carte_professionnel AS is_visible_carte_professionnel_13, s0_.image AS image_14, s0_.updated_image_at AS updated_image_at_15, s0_.so_mobilite AS so_mobilite_16, s0_.slug AS slug_17, s0_.created_date AS created_date_18, s0_.update_date AS update_date_19, s0_.created_by AS created_by_20, s0_.updated_by AS updated_by_21 FROM structure s0_ WHERE s0_.is_visible_carte_jeune = ? AND s0_.statut = ? ORDER BY s0_.nom ASC
Parameters:
[ 1 1 ] |
|
62.15 ms (37.54%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.image AS image_2, a0_.updated_image_at AS updated_image_at_3, a0_.contenu AS contenu_4, a0_.date_debut_publication AS date_debut_publication_5, a0_.date_fin_publication AS date_fin_publication_6, a0_.visible_page_accueil AS visible_page_accueil_7, a0_.slug AS slug_8, a0_.created_date AS created_date_9, a0_.update_date AS update_date_10, a0_.created_by AS created_by_11, a0_.updated_by AS updated_by_12, a0_.publication AS publication_13, a0_.cible_id AS cible_id_14 FROM article a0_ WHERE a0_.publication = ? AND a0_.cible_id IN (?, ?)
Parameters:
[ 1 4 6 ] |
|
11.71 ms (7.07%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.image AS image_2, a0_.updated_image_at AS updated_image_at_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.descriptif AS descriptif_5, a0_.date_fin_publication AS date_fin_publication_6, a0_.a_la_une AS a_la_une_7, a0_.slug AS slug_8, a0_.created_date AS created_date_9, a0_.update_date AS update_date_10, a0_.created_by AS created_by_11, a0_.updated_by AS updated_by_12, a0_.publication AS publication_13, a0_.thematique_id AS thematique_id_14, a0_.cible_id AS cible_id_15 FROM actualite a0_ WHERE a0_.publication = ? AND a0_.cible_id IN (?, ?) AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) ORDER BY a0_.date_debut_publication DESC
Parameters:
[ 1 4 6 ] |
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\Structure | 92 |
| App\Entity\Article | 38 |
| App\Entity\Actualite | 31 |
| App\Entity\Thematique | 21 |
| App\Entity\CiblePublic | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Structure | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\DomaineAction | No errors. |
| App\Entity\DomaineInformation | No errors. |
| App\Entity\DomaineMobilite | No errors. |
| App\Entity\Reseaux | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\Thematique | No errors. |
| App\Entity\CiblePublic | No errors. |
| App\Entity\MotCle | No errors. |
| App\Entity\ActualiteFichierJoint | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\ArticleFichierJoint | No errors. |