GET https://somobilite.altern-active.com/sitemap.xml

Query Metrics

3 Database Queries
3 Different statements
165.53 ms Query time
0 Invalid entities
184 Managed entities

Queries

Group similar statements

# Time Info
1 91.67 ms
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
]
2 11.71 ms
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
]
3 62.15 ms
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
]

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