GET https://figurine-actus.ethiko.io/figurines/figurines-articul-ees

Query Metrics

24 Database Queries
11 Different statements
5.43 ms Query time
4 Invalid entities
398 Managed entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.old_id AS old_id_5, t0.photo AS photo_6, t0.photo_alt AS photo_alt_7 FROM categories t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "figurines-articul-ees"
]
2 0.29 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.description AS description_2, f0_.echelle AS echelle_3, f0_.date_sortie AS date_sortie_4, f0_.date_reedition AS date_reedition_5, f0_.dimension AS dimension_6, f0_.status AS status_7, f0_.price AS price_8, f0_.price_yen AS price_yen_9, f0_.tags AS tags_10, f0_.photo_cover AS photo_cover_11, f0_.photo_thumbnail AS photo_thumbnail_12, f0_.created_at AS created_at_13, f0_.updated_at AS updated_at_14, f0_.slug AS slug_15, f0_.old_id AS old_id_16, f0_.other_price AS other_price_17, f0_.photo_alt AS photo_alt_18, f0_.miniature_alt AS miniature_alt_19, f0_.view AS view_20, f0_.figurine_gammes_id AS figurine_gammes_id_21, f0_.figurine_fabriquant_id AS figurine_fabriquant_id_22, f0_.serie_id AS serie_id_23, f0_.personnage_id AS personnage_id_24 FROM figurine f0_ WHERE f0_.status = ? ORDER BY f0_.date_sortie DESC LIMIT 4
Parameters:
[
  1
]
3 0.27 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 WHERE t0.id = ?
Parameters:
[
  5
]
4 0.20 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.license_personnage_id AS license_personnage_id_18, t0.genre_personnage_id AS genre_personnage_id_19 FROM personnage t0 WHERE t0.id = ?
Parameters:
[
  930
]
5 0.18 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 WHERE t0.id = ?
Parameters:
[
  42
]
6 0.15 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.license_personnage_id AS license_personnage_id_18, t0.genre_personnage_id AS genre_personnage_id_19 FROM personnage t0 WHERE t0.id = ?
Parameters:
[
  27
]
7 0.14 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.license_personnage_id AS license_personnage_id_18, t0.genre_personnage_id AS genre_personnage_id_19 FROM personnage t0 WHERE t0.id = ?
Parameters:
[
  551
]
8 0.14 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.license_personnage_id AS license_personnage_id_18, t0.genre_personnage_id AS genre_personnage_id_19 FROM personnage t0 WHERE t0.id = ?
Parameters:
[
  919
]
9 0.46 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.adress AS adress_2, f0_.photo AS photo_3, f0_.description AS description_4, f0_.status AS status_5, f0_.type AS type_6, f0_.date_creation AS date_creation_7, f0_.nom_japonais AS nom_japonais_8, f0_.twitter AS twitter_9, f0_.site AS site_10, f0_.pays AS pays_11, f0_.old_id AS old_id_12, f0_.photo_alt AS photo_alt_13, f0_.slug AS slug_14, f0_.localisation_id AS localisation_id_15, f0_.membre_id AS membre_id_16 FROM figurine_fabriquant f0_ WHERE f0_.status = ? ORDER BY f0_.nom ASC
Parameters:
[
  1
]
10 0.23 ms
SELECT f0_.id AS id_0, f0_.photo AS photo_1, f0_.nom AS nom_2, f0_.taille_moyenne AS taille_moyenne_3, f0_.gamme_prix AS gamme_prix_4, f0_.site AS site_5, f0_.pays AS pays_6, f0_.slug AS slug_7, f0_.nom_japonais AS nom_japonais_8, f0_.old_id AS old_id_9, f0_.description AS description_10, f0_.photo_alt AS photo_alt_11, f0_.date_add AS date_add_12, f0_.style_id AS style_id_13, f0_.membre_id AS membre_id_14 FROM figurine_gammes f0_ ORDER BY f0_.nom ASC
Parameters:
[]
11 0.24 ms
SELECT DISTINCT f0_.echelle AS echelle_0 FROM figurine f0_ WHERE f0_.echelle IS NOT NULL ORDER BY f0_.echelle ASC
Parameters:
[]
12 0.25 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.nom_japonais AS nom_japonais_2, f0_.description AS description_3, f0_.twitter AS twitter_4, f0_.site AS site_5, f0_.libellestreaming AS libellestreaming_6, f0_.liensstreaming AS liensstreaming_7, f0_.photo AS photo_8, f0_.slug AS slug_9, f0_.old_id AS old_id_10, f0_.photo_alt AS photo_alt_11, f0_.studio_editeur AS studio_editeur_12, f0_.editeur AS editeur_13, f0_.editeur_jp AS editeur_jp_14, f0_.date_debut AS date_debut_15, f0_.date_fin AS date_fin_16, f0_.nombre_de_saison AS nombre_de_saison_17, f0_.membre_id AS membre_id_18 FROM figurine_serie f0_ ORDER BY f0_.nom ASC
Parameters:
[]
13 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:
[
  "fron.page.figurines"
]
14 0.21 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"
]
15 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_rss_link"
]
16 0.24 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"
]
17 0.12 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"
]
18 0.12 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"
]
19 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_instagram_link"
]
20 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_pinterest_link"
]
21 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:
[
  "id_page_ml"
]
22 0.18 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
]
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_pc"
]
24 0.13 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\FigurineGammes 27
App\Entity\SiteConfiguration 9
App\Entity\Figurine 4
App\Entity\Personnage 4
App\Entity\Membre 2
App\Entity\TypeGamme 2
App\Entity\Page 2
App\Entity\Categories 1
App\Entity\LocalisationFabricant 1

Entities Mapping

Class Mapping errors
App\Entity\Categories No errors.
App\Entity\Posts No errors.
App\Entity\FigurineSerie No errors.
App\Entity\FigurineCategories 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\FigurineGammes No errors.
App\Entity\FigurineFabriquant No errors.
App\Entity\Personnage 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\PostTag No errors.
App\Entity\MembreCollection No errors.
App\Entity\MembreWishlist No errors.
App\Entity\Membre
  • The mappings App\Entity\Membre#historique and App\Entity\MembreHistorique#membre are inconsistent with each other.
App\Entity\TypeSerie No errors.
App\Entity\LicensePersonnage No errors.
App\Entity\GenrePersonnage No errors.
App\Entity\OriginePersonnage 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\TypeGamme No errors.
App\Entity\SEO No errors.
App\Entity\SiteConfiguration No errors.
App\Entity\Page No errors.