GET https://figurine-actus.ethiko.io/posts?e=QXBwXEVudGl0eVxQZXJzb25uYWdl&e_id=254

Query Metrics

22 Database Queries
9 Different statements
7.79 ms Query time
1 Invalid entities
83 Managed entities

Queries

Group similar statements

# Time Info
1 1.09 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.slug = ? LIMIT 1
Parameters:
[
  "posts"
]
2 0.58 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.content AS content_4, t0.slug AS slug_5, t0.created_at AS created_at_6, t0.status AS status_7, t0.tags AS tags_8, t0.photo AS photo_9, t0.type AS type_10, t0.updated_at AS updated_at_11, t0.published_date AS published_date_12, t0.view AS view_13, t0.old_id AS old_id_14, t0.photo_alt AS photo_alt_15, t0.faq_id AS faq_id_16 FROM posts t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "posts"
]
3 0.61 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"
]
4 1.00 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.old_id AS old_id_4, c0_.photo AS photo_5, c0_.photo_alt AS photo_alt_6 FROM categories c0_ INNER JOIN figurine_categories f1_ ON c0_.id = f1_.categories_id ORDER BY c0_.name ASC
Parameters:
[]
5 0.56 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.autre_appelation AS autre_appelation_3, t0.dob AS dob_4, t0.taille AS taille_5, t0.doubleur AS doubleur_6, t0.trait_physique AS trait_physique_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.nom_japonais AS nom_japonais_10, t0.annivaersaire AS annivaersaire_11, t0.slug AS slug_12, t0.photo AS photo_13, t0.old_id AS old_id_14, t0.description AS description_15, t0.photo_alt AS photo_alt_16, t0.genre AS genre_17, t0.tags AS tags_18, t0.date_naissance AS date_naissance_19, t0.license_personnage_id AS license_personnage_id_20, t0.genre_personnage_id AS genre_personnage_id_21, t0.serie_id AS serie_id_22 FROM personnage t0 WHERE t0.id = ?
Parameters:
[
  "254"
]
6 0.55 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.posts"
]
7 0.26 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"
]
8 0.25 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
]
9 0.32 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:
[
  "g_adsense_key"
]
10 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:
[
  "g_adsense_key"
]
11 0.24 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.link AS link_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM annonces t0 WHERE t0.status = ?
Parameters:
[
  1
]
12 0.29 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"
]
13 0.19 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"
]
14 0.18 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"
]
15 0.19 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"
]
16 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_x_link"
]
17 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_instagram_link"
]
18 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_pinterest_link"
]
19 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:
[
  "id_page_ml"
]
20 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:
[
  2
]
21 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_pc"
]
22 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:
[
  "g_analytic_key"
]

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\Categories 66
App\Entity\SiteConfiguration 11
App\Entity\Page 2
App\Entity\Personnage 1
App\Entity\FigurineSerie 1
App\Entity\SEO 1
App\Entity\Annonces 1

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\Posts No errors.
App\Entity\Faq No 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\Categories No errors.
App\Entity\FigurineCategories No errors.
App\Entity\FigurineSerie No errors.
App\Entity\Personnage No errors.
App\Entity\LicensePersonnage No errors.
App\Entity\GenrePersonnage No errors.
App\Entity\OriginePersonnage No errors.
App\Entity\PersonnagePhotos No errors.
App\Entity\SEO No errors.
App\Entity\SiteConfiguration No errors.
App\Entity\Annonces No errors.