GET https://les-creolines.fpdev.fr/actualites/actualite-33?page=9

Query Metrics

18 Database Queries
12 Different statements
10.00 ms Query time
0 Invalid entities
34 Managed entities

Queries

Group similar statements

# Time Info
1 1.13 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.resume AS resume_4, t0.texte AS texte_5, t0.the_datetime AS the_datetime_6, t0.reference_index AS reference_index_7, t0.reference AS reference_8, t9.id AS id_10, t9.url AS url_11, t9.has_uploaded_file AS has_uploaded_file_12, t9.filename AS filename_13, t9.folder AS folder_14, t9.the_property_id AS the_property_id_15, t9.the_type_id AS the_type_id_16, t9.nom AS nom_17, t9.size AS size_18, t9.reference_index AS reference_index_19, t9.reference AS reference_20, t9.the_users_user_avatar_id AS the_users_user_avatar_id_21, t9.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_22, t9.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_23, t9.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_24, t9.the_pages_page_header_id AS the_pages_page_header_id_25, t9.the_pages_page_image_image_id AS the_pages_page_image_image_id_26 FROM actualites_actualite t0 LEFT JOIN fichiers_fichier t9 ON t9.the_actualites_actualite_image_id = t0.id WHERE t0.slug = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  "actualite-33"
]
2 0.59 ms
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM actualites_actualite a0_
Parameters:
[]
3 0.43 ms
SELECT DISTINCT a0_.id AS id_0, a0_.the_datetime AS the_datetime_1 FROM actualites_actualite a0_ ORDER BY a0_.the_datetime DESC LIMIT 4 OFFSET 32
Parameters:
[]
4 0.52 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.texte AS texte_4, a0_.the_datetime AS the_datetime_5, a0_.reference_index AS reference_index_6, a0_.reference AS reference_7 FROM actualites_actualite a0_ WHERE a0_.id IN (?, ?, ?, ?) ORDER BY a0_.the_datetime DESC
Parameters:
[
  8
  7
  6
  5
]
5 0.50 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  8
]
6 0.48 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  7
]
7 0.47 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  6
]
8 0.49 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  5
]
9 0.91 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.sous_titre AS sous_titre_3, t0.slug AS slug_4, t0.has_breadcrumb AS has_breadcrumb_5, t0.the_type_id AS the_type_id_6, t0.reference_index AS reference_index_7, t0.reference AS reference_8, t9.id AS id_10, t9.url AS url_11, t9.has_uploaded_file AS has_uploaded_file_12, t9.filename AS filename_13, t9.folder AS folder_14, t9.the_property_id AS the_property_id_15, t9.the_type_id AS the_type_id_16, t9.nom AS nom_17, t9.size AS size_18, t9.reference_index AS reference_index_19, t9.reference AS reference_20, t9.the_users_user_avatar_id AS the_users_user_avatar_id_21, t9.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_22, t9.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_23, t9.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_24, t9.the_pages_page_header_id AS the_pages_page_header_id_25, t9.the_pages_page_image_image_id AS the_pages_page_image_image_id_26, t0.the_seo_id AS the_seo_id_27 FROM pages_page t0 LEFT JOIN fichiers_fichier t9 ON t9.the_pages_page_header_id = t0.id
Parameters:
[]
10 0.68 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.mot_cles AS mot_cles_4, t5.id AS id_6, t5.nom AS nom_7, t5.sous_titre AS sous_titre_8, t5.slug AS slug_9, t5.has_breadcrumb AS has_breadcrumb_10, t5.the_type_id AS the_type_id_11, t5.reference_index AS reference_index_12, t5.reference AS reference_13, t5.the_seo_id AS the_seo_id_14 FROM seos_seo t0 LEFT JOIN pages_page t5 ON t5.the_seo_id = t0.id WHERE t0.id = ?
Parameters:
[
  6
]
11 0.53 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.class_icon AS class_icon_4, t0.url AS url_5 FROM contacts_reseau_social t0
Parameters:
[]
12 0.69 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.order_index AS order_index_2, a0_.the_datetime AS the_datetime_3, a0_.the_type_id AS the_type_id_4, a0_.reference_index AS reference_index_5, a0_.reference AS reference_6, a1_.youtube_id AS youtube_id_7, a1_.facebook_script AS facebook_script_8, a1_.the_video_type_id AS the_video_type_id_9, a0_.discr AS discr_10, a0_.the_album_id AS the_album_id_11 FROM albums_album_video a1_ INNER JOIN albums_album_media a0_ ON a1_.id = a0_.id ORDER BY a0_.id DESC LIMIT 3
Parameters:
[]
13 0.49 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.reference_index AS reference_index_4, t0.reference AS reference_5, t6.id AS id_7, t6.nom AS nom_8, t6.slug AS slug_9, t6.description AS description_10, t6.reference_index AS reference_index_11, t6.reference AS reference_12, t6.the_album_id AS the_album_id_13 FROM albums_album t0 LEFT JOIN partenaires_partenaire t6 ON t6.the_album_id = t0.id WHERE t0.id = ?
Parameters:
[
  10
]
14 0.49 ms
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.slug AS slug_2, a0_.resume AS resume_3, a0_.texte AS texte_4, a0_.the_datetime AS the_datetime_5, a0_.reference_index AS reference_index_6, a0_.reference AS reference_7 FROM actualites_actualite a0_ ORDER BY a0_.the_datetime DESC LIMIT 3
Parameters:
[]
15 0.45 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  40
]
16 0.38 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  39
]
17 0.39 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.has_uploaded_file AS has_uploaded_file_3, t0.filename AS filename_4, t0.folder AS folder_5, t0.the_property_id AS the_property_id_6, t0.the_type_id AS the_type_id_7, t0.nom AS nom_8, t0.size AS size_9, t0.reference_index AS reference_index_10, t0.reference AS reference_11, t0.the_users_user_avatar_id AS the_users_user_avatar_id_12, t0.the_contacts_coordonnee_logo_id AS the_contacts_coordonnee_logo_id_13, t0.the_partenaires_partenaire_image_id AS the_partenaires_partenaire_image_id_14, t0.the_actualites_actualite_image_id AS the_actualites_actualite_image_id_15, t0.the_pages_page_header_id AS the_pages_page_header_id_16, t0.the_pages_page_image_image_id AS the_pages_page_image_image_id_17 FROM fichiers_fichier t0 WHERE t0.the_actualites_actualite_image_id = ?
Parameters:
[
  38
]
18 0.38 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.texte AS texte_4, t0.reference_index AS reference_index_5, t0.reference AS reference_6 FROM textes_texte t0
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\Actualites\Actualite 8
App\Entity\Pages\Page 8
App\Entity\Seos\Seo 8
App\Entity\Contacts\ReseauSocial 3
App\Entity\Albums\AlbumMedia 3
App\Entity\Textes\Texte 2
App\Entity\Albums\Album 1
App\Entity\Partenaires\Partenaire 1