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

Query Metrics

22 Database Queries
8 Different statements
16.18 ms Query time
2 Invalid entities
308 Managed entities

Queries

Group similar statements

# Time Info
1 1.50 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:
[
  "personnages"
]
2 5.73 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:
[
  "personnages"
]
3 2.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM origine_personnage t0
Parameters:
[]
4 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.about AS about_19, t0.autre_appellation AS autre_appellation_20, t0.membre_id AS membre_id_21 FROM figurine_serie t0 ORDER BY t0.nom ASC
Parameters:
[]
5 2.77 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.personnages"
]
6 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:
[
  "id_page_pc"
]
7 0.16 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
]
8 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:
[
  "g_adsense_key"
]
9 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:
[
  "g_adsense_key"
]
10 0.14 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
]
11 0.55 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:
[
  "personnage_text_description"
]
12 0.38 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.27 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.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"
]
16 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"
]
17 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"
]
18 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"
]
19 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"
]
20 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
]
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:
[
  "id_page_pc"
]
22 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:
[
  "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\FigurineSerie 286
App\Entity\SiteConfiguration 12
App\Entity\OriginePersonnage 4
App\Entity\Membre 2
App\Entity\Page 2
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\OriginePersonnage No errors.
App\Entity\Personnage 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\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\PostTag No errors.
App\Entity\TypeSerie No errors.
App\Entity\SerieLicencePhotos No errors.
App\Entity\SEO No errors.
App\Entity\SiteConfiguration No errors.
App\Entity\Annonces No errors.