https://pp-lalune.e-systemes.fr/actus/retour-des-bruits-de-lune

Query Metrics

194 Database Queries
20 Different statements
79.43 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
34.73 ms
(43.72%)
116
SELECT t0.id AS id_1, t0.online AS online_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.language_id AS language_id_5, t0.article_id AS article_id_6, t0.category_id AS category_id_7 FROM online t0 WHERE t0.article_id = ?
Parameters:
[
  177
]
16.39 ms
(20.63%)
12
SELECT t0.article_id AS article_id_1, t0.slug AS slug_2, t0.hash AS hash_3, t0.id AS id_4, t0.title AS title_5, t0.ordre AS ordre_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.article_id AS article_id_9, t0.category_id AS category_id_10, t11.created_at AS created_at_12, t11.updated_at AS updated_at_13, t11.id AS id_14, t11.field_key AS field_key_15, t11.field_value AS field_value_16, t11.object_id AS object_id_17, t11.language_id AS language_id_18 FROM article t0 LEFT JOIN article_data t11 ON t11.object_id = t0.id WHERE t0.category_id = ?
Parameters:
[
  54
]
6.71 ms
(8.44%)
6
SELECT t0.has_theme AS has_theme_1, t0.has_seo AS has_seo_2, t0.category_id AS category_id_3, t0.hash AS hash_4, t0.internal AS internal_5, t0.slug AS slug_6, t0.id AS id_7, t0.title AS title_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t13.created_at AS created_at_14, t13.updated_at AS updated_at_15, t13.id AS id_16, t13.field_key AS field_key_17, t13.field_value AS field_value_18, t13.object_id AS object_id_19, t13.language_id AS language_id_20 FROM category t0 LEFT JOIN category_data t13 ON t13.object_id = t0.id WHERE t0.category_id = ?
Parameters:
[
  3
]
3.78 ms
(4.76%)
12
SELECT t0.has_theme AS has_theme_1, t0.has_seo AS has_seo_2, t0.category_id AS category_id_3, t0.hash AS hash_4, t0.internal AS internal_5, t0.slug AS slug_6, t0.id AS id_7, t0.title AS title_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "54"
]
3.17 ms
(3.99%)
10
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.mediaspec_id AS mediaspec_id_4, t0.article_id AS article_id_5, t0.category_id AS category_id_6, t0.media_id AS media_id_7 FROM media_link t0 WHERE t0.article_id = ?
Parameters:
[
  182
]
3.13 ms
(3.94%)
11
SELECT t0.id AS id_1, t0.media AS media_2, t0.legend AS legend_3, t0.section AS section_4, t0.star AS star_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.media_type_id AS media_type_id_8 FROM media t0 WHERE t0.id = ?
Parameters:
[
  480
]
3.00 ms
(3.78%)
9
SELECT t0.id AS id_1, t0.online AS online_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.language_id AS language_id_5, t0.article_id AS article_id_6, t0.category_id AS category_id_7 FROM online t0 WHERE t0.category_id = ?
Parameters:
[
  55
]
1.90 ms
(2.39%)
4
SELECT m0_.id AS id_0, m0_.media AS media_1, m0_.legend AS legend_2, m0_.section AS section_3, m0_.star AS star_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m0_.media_type_id AS media_type_id_7 FROM media m0_ INNER JOIN media_link m1_ ON m0_.id = m1_.media_id WHERE m0_.section = ? AND m1_.article_id = ? ORDER BY m0_.star DESC
Parameters:
[
  "gallery"
  357
]
0.91 ms
(1.15%)
1
SELECT t0.has_theme AS has_theme_1, t0.has_seo AS has_seo_2, t0.category_id AS category_id_3, t0.hash AS hash_4, t0.internal AS internal_5, t0.slug AS slug_6, t0.id AS id_7, t0.title AS title_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t13.created_at AS created_at_14, t13.updated_at AS updated_at_15, t13.id AS id_16, t13.field_key AS field_key_17, t13.field_value AS field_value_18, t13.object_id AS object_id_19, t13.language_id AS language_id_20 FROM category t0 LEFT JOIN category_data t13 ON t13.object_id = t0.id WHERE t0.id IN (?, ?, ?, ?, ?)
Parameters:
[
  3
  4
  53
  6
  39
]
0.91 ms
(1.14%)
2
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.field_key AS field_key_4, t0.field_value AS field_value_5, t0.object_id AS object_id_6, t0.language_id AS language_id_7 FROM category_data t0 WHERE t0.object_id = ?
Parameters:
[
  54
]
0.87 ms
(1.09%)
1
SELECT t0.has_theme AS has_theme_1, t0.has_seo AS has_seo_2, t0.category_id AS category_id_3, t0.hash AS hash_4, t0.internal AS internal_5, t0.slug AS slug_6, t0.id AS id_7, t0.title AS title_8, t0.ordre AS ordre_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t13.created_at AS created_at_14, t13.updated_at AS updated_at_15, t13.id AS id_16, t13.field_key AS field_key_17, t13.field_value AS field_value_18, t13.object_id AS object_id_19, t13.language_id AS language_id_20 FROM category t0 LEFT JOIN category_data t13 ON t13.object_id = t0.id WHERE t0.category_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  39
]
0.67 ms
(0.85%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM language t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.62 ms
(0.78%)
1
SELECT t0.id AS id_1, t0.email_contact AS email_contact_2, t0.email_objet AS email_objet_3, t0.cache_flush_auto AS cache_flush_auto_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_keywords AS seo_keywords_9, t0.email_billetterie AS email_billetterie_10, t0.email_comptabilite AS email_comptabilite_11, t0.email_partenariats AS email_partenariats_12, t0.email_communication AS email_communication_13, t0.email_projets AS email_projets_14, t0.email_programmation AS email_programmation_15, t0.email_technique AS email_technique_16, t0.email_billetterie_object AS email_billetterie_object_17, t0.email_comptabilite_object AS email_comptabilite_object_18, t0.email_partenariats_object AS email_partenariats_object_19, t0.email_communication_object AS email_communication_object_20, t0.email_projets_object AS email_projets_object_21, t0.email_programmation_object AS email_programmation_object_22, t0.email_technique_object AS email_technique_object_23 FROM config t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.58 ms
(0.74%)
1
SELECT t0.article_id AS article_id_1, t0.slug AS slug_2, t0.hash AS hash_3, t0.id AS id_4, t0.title AS title_5, t0.ordre AS ordre_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.article_id AS article_id_9, t0.category_id AS category_id_10 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "retour-des-bruits-de-lune"
]
0.58 ms
(0.73%)
1
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.id AS id_3, t0.field_key AS field_key_4, t0.field_value AS field_value_5, t0.object_id AS object_id_6, t0.language_id AS language_id_7 FROM article_data t0 WHERE t0.object_id = ?
Parameters:
[
  182
]
0.51 ms
(0.65%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.width AS width_3, t0.height AS height_4, t0.mandatory AS mandatory_5, t0.haslegend AS haslegend_6, t0.heritage AS heritage_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.article_id AS article_id_10, t0.category_id AS category_id_11, t0.media_type_id AS media_type_id_12 FROM mediaspec t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.27 ms
(0.34%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.mediaspec_id AS mediaspec_id_4, t0.article_id AS article_id_5, t0.category_id AS category_id_6, t0.media_id AS media_id_7 FROM media_link t0 WHERE t0.media_id = ? LIMIT 1
Parameters:
[
  481
]
0.25 ms
(0.31%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.language_id AS language_id_7, t0.article_id AS article_id_8, t0.category_id AS category_id_9 FROM seo t0 WHERE t0.article_id = ?
Parameters:
[
  182
]
0.24 ms
(0.30%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.keywords AS keywords_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.language_id AS language_id_7, t0.article_id AS article_id_8, t0.category_id AS category_id_9 FROM seo t0 WHERE t0.category_id = ?
Parameters:
[
  17
]
0.21 ms
(0.27%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.filetype AS filetype_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM media_type t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Config No errors.
App\Entity\Category No errors.
App\Entity\Article No errors.
App\Entity\Online No errors.
App\Entity\MediaLink No errors.
App\Entity\Mediaspec No errors.
App\Entity\CategoryData No errors.
App\Entity\Language No errors.
App\Entity\Seo No errors.
App\Entity\ArticleData No errors.
App\Entity\Theme No errors.
App\Entity\Media No errors.
App\Entity\MediaType No errors.