GET https://figurine-actus.ethiko.io/personnage/yuta-okkotsu

Query Metrics

26 Database Queries
10 Different statements
15.98 ms Query time
4 Invalid entities
33 Managed entities

Queries

Group similar statements

# Time Info
1 1.34 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.slug = ? LIMIT 1
Parameters:
[
  "yuta-okkotsu"
]
2 0.42 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.slug = ? LIMIT 1
Parameters:
[
  "yuta-okkotsu"
]
3 4.85 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.object = ? AND t0.object_id = ? LIMIT 1
Parameters:
[
  "App\Entity\Personnage"
  481
]
4 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:
[
  "id_page_pc"
]
5 0.23 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
]
6 0.28 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"
]
7 0.15 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"
]
8 0.17 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
]
9 0.98 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.echelle AS echelle_4, t0.date_sortie AS date_sortie_5, t0.date_reedition AS date_reedition_6, t0.dimension AS dimension_7, t0.status AS status_8, t0.price AS price_9, t0.price_yen AS price_yen_10, t0.tags AS tags_11, t0.photo_cover AS photo_cover_12, t0.photo_thumbnail AS photo_thumbnail_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.slug AS slug_16, t0.old_id AS old_id_17, t0.other_price AS other_price_18, t0.photo_alt AS photo_alt_19, t0.miniature_alt AS miniature_alt_20, t0.view AS view_21, t0.figurine_gammes_id AS figurine_gammes_id_22, t0.figurine_fabriquant_id AS figurine_fabriquant_id_23, t0.serie_id AS serie_id_24, t0.personnage_id AS personnage_id_25 FROM figurine t0 WHERE t0.personnage_id = ?
Parameters:
[
  481
]
10 4.03 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.autre_appelation AS autre_appelation_2, p0_.dob AS dob_3, p0_.taille AS taille_4, p0_.doubleur AS doubleur_5, p0_.trait_physique AS trait_physique_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.nom_japonais AS nom_japonais_9, p0_.annivaersaire AS annivaersaire_10, p0_.slug AS slug_11, p0_.photo AS photo_12, p0_.old_id AS old_id_13, p0_.description AS description_14, p0_.photo_alt AS photo_alt_15, p0_.genre AS genre_16, p0_.tags AS tags_17, p0_.date_naissance AS date_naissance_18, RAND() AS sclr_19, p0_.license_personnage_id AS license_personnage_id_20, p0_.genre_personnage_id AS genre_personnage_id_21, p0_.serie_id AS serie_id_22 FROM personnage p0_ WHERE p0_.photo IS NOT NULL AND p0_.id <> ? ORDER BY sclr_19 ASC LIMIT 8
Parameters:
[
  481
]
11 0.54 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 INNER JOIN personnage_posts ON t0.id = personnage_posts.posts_id WHERE personnage_posts.personnage_id = ?
Parameters:
[
  481
]
12 0.34 ms
SELECT p0_.id AS id_0, p0_.photo AS photo_1, p0_.alt AS alt_2, p0_.position AS position_3, p0_.personnage_id AS personnage_id_4 FROM personnage_photos p0_ WHERE p0_.personnage_id = ? ORDER BY p0_.position ASC
Parameters:
[
  481
]
13 0.22 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.about AS about_19, t0.autre_appellation AS autre_appellation_20, t0.membre_id AS membre_id_21 FROM figurine_serie t0 WHERE t0.id = ?
Parameters:
[
  98
]
14 0.23 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.about AS about_19, t0.autre_appellation AS autre_appellation_20, t0.membre_id AS membre_id_21 FROM figurine_serie t0 WHERE t0.id = ?
Parameters:
[
  25
]
15 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:
[
  "allow_guest"
]
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:
[
  "footer_text"
]
17 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_rss_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_rss_link_bdd"
]
19 0.15 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"
]
20 0.14 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"
]
21 0.14 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"
]
22 0.14 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"
]
23 0.14 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"
]
24 0.15 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
]
25 0.15 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"
]
26 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:
[
  "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\SiteConfiguration 11
App\Entity\Personnage 9
App\Entity\Figurine 3
App\Entity\FigurineGammes 3
App\Entity\Page 2
App\Entity\FigurineSerie 2
App\Entity\SEO 1
App\Entity\Annonces 1
App\Entity\FigurineFabriquant 1

Entities Mapping

Class Mapping errors
App\Entity\Personnage No errors.
App\Entity\LicensePersonnage No errors.
App\Entity\GenrePersonnage No errors.
App\Entity\FigurineSerie No errors.
App\Entity\OriginePersonnage 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\PersonnagePhotos No errors.
App\Entity\Posts No errors.
App\Entity\SEO No errors.
App\Entity\SiteConfiguration No errors.
App\Entity\Page No errors.
App\Entity\Annonces No errors.
App\Entity\FigurineGammes No errors.
App\Entity\FigurineFabriquant No errors.
App\Entity\FigurinePhotos No errors.
App\Entity\FigurineMateriaux No errors.
App\Entity\FigurineSerieLicence No errors.
App\Entity\FigurineBoutiqueFigurine No errors.
App\Entity\FigurinePeintre
  • The association App\Entity\FigurinePeintre#figurine refers to the owning side field App\Entity\Figurine#figurinePeintre which does not exist.
App\Entity\FigurineSculpteur
  • The association App\Entity\FigurineSculpteur#figurine refers to the owning side field App\Entity\Figurine#figurineSculpteur which does not exist.
App\Entity\FigurineIllustrator No errors.
App\Entity\FigurineCategories No errors.
App\Entity\PostTag No errors.
App\Entity\MembreCollection No errors.
App\Entity\MembreWishlist No errors.
App\Entity\Faq 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\TypeSerie No errors.
App\Entity\SerieLicencePhotos No errors.