GET https://figurine-actus.ethiko.io/agenda

Query Metrics

17 Database Queries
6 Different statements
5.05 ms Query time
2 Invalid entities
360 Managed entities

Queries

Group similar statements

# Time Info
1 1.11 ms
SELECT DISTINCT YEAR(f0_.date_sortie) AS sclr_0, YEAR(f0_.date_reedition) AS sclr_1 FROM figurine f0_ INNER JOIN figurine_posts f2_ ON f0_.id = f2_.figurine_id INNER JOIN posts p1_ ON p1_.id = f2_.posts_id WHERE YEAR(f0_.date_sortie) <= ?
Parameters:
[
  "2026"
]
2 0.52 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_japonais AS nom_japonais_3, t0.description AS description_4, t0.twitter AS twitter_5, t0.site AS site_6, t0.libellestreaming AS libellestreaming_7, t0.liensstreaming AS liensstreaming_8, t0.photo AS photo_9, t0.slug AS slug_10, t0.old_id AS old_id_11, t0.photo_alt AS photo_alt_12, t0.studio_editeur AS studio_editeur_13, t0.editeur AS editeur_14, t0.editeur_jp AS editeur_jp_15, t0.date_debut AS date_debut_16, t0.date_fin AS date_fin_17, t0.nombre_de_saison AS nombre_de_saison_18, t0.membre_id AS membre_id_19 FROM figurine_serie t0 ORDER BY t0.nom ASC
Parameters:
[]
3 0.41 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adress AS adress_3, t0.photo AS photo_4, t0.description AS description_5, t0.status AS status_6, t0.type AS type_7, t0.date_creation AS date_creation_8, t0.nom_japonais AS nom_japonais_9, t0.twitter AS twitter_10, t0.site AS site_11, t0.pays AS pays_12, t0.old_id AS old_id_13, t0.photo_alt AS photo_alt_14, t0.slug AS slug_15, t0.localisation_id AS localisation_id_16, t0.membre_id AS membre_id_17 FROM figurine_fabriquant t0 WHERE t0.status = ? ORDER BY t0.nom ASC
Parameters:
[
  1
]
4 0.34 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.object AS object_3, t0.page_title AS page_title_4, t0.page_description AS page_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.object_id AS object_id_10 FROM seo t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "front.page.agenda"
]
5 0.33 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.object AS object_3, t0.page_title AS page_title_4, t0.page_description AS page_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.object_id AS object_id_10 FROM seo t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "front.page.agenda"
]
6 0.21 ms
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.object AS object_3, t0.page_title AS page_title_4, t0.page_description AS page_description_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.keywords AS keywords_8, t0.image AS image_9, t0.object_id AS object_id_10 FROM seo t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "front.page.agenda"
]
7 0.23 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_text"
]
8 0.16 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_rss_link"
]
9 0.16 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_rss_link_bdd"
]
10 0.17 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_facebook_link"
]
11 0.13 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_x_link"
]
12 0.23 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_instagram_link"
]
13 0.31 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "footer_pinterest_link"
]
14 0.16 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "id_page_ml"
]
15 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 0.20 ms
SELECT t0.id AS id_1, t0.config_name AS config_name_2, t0.config_value AS config_value_3 FROM site_configuration t0 WHERE t0.config_name = ? LIMIT 1
Parameters:
[
  "id_page_pc"
]
17 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8 FROM page 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FigurineSerie 284
App\Entity\FigurineFabriquant 62
App\Entity\SiteConfiguration 9
App\Entity\Membre 2
App\Entity\Page 2
App\Entity\LocalisationFabricant 1

Entities Mapping

Class Mapping errors
App\Entity\Figurine
  • The association App\Entity\Figurine#peintre refers to the inverse side field App\Entity\FigurinePeintre#figurines which does not exist.
  • The association App\Entity\Figurine#sculpteur refers to the inverse side field App\Entity\FigurineSculpteur#figurines which does not exist.
App\Entity\Posts No errors.
App\Entity\FigurineSerie No errors.
App\Entity\Membre
  • The mappings App\Entity\Membre#historique and App\Entity\MembreHistorique#membre are inconsistent with each other.
App\Entity\Categories No errors.
App\Entity\PostTag No errors.
App\Entity\TypeSerie No errors.
App\Entity\FigurineFabriquant No errors.
App\Entity\LocalisationFabricant No errors.
App\Entity\Appelation No errors.
App\Entity\Note No errors.
App\Entity\SpecialitenFabricant No errors.
App\Entity\TypeFigurineFabricant No errors.
App\Entity\SEO No errors.
App\Entity\SiteConfiguration No errors.
App\Entity\Page No errors.