Query Metrics
8
Database Queries
8
Different statements
30.31 ms
Query time
4
Invalid entities
5248
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
19.63 ms (64.76%) |
1 |
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.status = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
|
7.73 ms (25.51%) |
1 |
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.status = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
|
0.99 ms (3.28%) |
1 |
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:
[
"sitemap.xml"
]
|
||||||||||||||||||||||||
|
0.51 ms (1.69%) |
1 |
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:
[
"sitemap.xml"
]
|
||||||||||||||||||||||||
|
0.46 ms (1.51%) |
1 |
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.status = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
|
0.37 ms (1.22%) |
1 |
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
Parameters:
[]
|
||||||||||||||||||||||||
|
0.34 ms (1.14%) |
1 |
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.autre_appellation AS autre_appellation_16, t0.localisation_id AS localisation_id_17, t0.membre_id AS membre_id_18 FROM figurine_fabriquant t0 WHERE t0.status = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||
|
0.27 ms (0.90%) |
1 |
SELECT t0.id AS id_1, t0.photo AS photo_2, t0.nom AS nom_3, t0.taille_moyenne AS taille_moyenne_4, t0.gamme_prix AS gamme_prix_5, t0.site AS site_6, t0.pays AS pays_7, t0.slug AS slug_8, t0.nom_japonais AS nom_japonais_9, t0.old_id AS old_id_10, t0.description AS description_11, t0.photo_alt AS photo_alt_12, t0.date_add AS date_add_13, t0.autre_appellation AS autre_appellation_14, t0.website AS website_15, t0.style_id AS style_id_16, t0.membre_id AS membre_id_17 FROM figurine_gammes t0
Parameters:
[]
|
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\Figurine | 2273 |
| App\Entity\Posts | 1647 |
| App\Entity\Personnage | 942 |
| App\Entity\FigurineSerie | 286 |
| App\Entity\FigurineFabriquant | 62 |
| App\Entity\FigurineGammes | 28 |
| App\Entity\TypeGamme | 3 |
| App\Entity\Page | 3 |
| App\Entity\Membre | 2 |
| App\Entity\LocalisationFabricant | 1 |
| App\Entity\Faq | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| App\Entity\Posts | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\FigurineFabriquant | No errors. |
| App\Entity\LocalisationFabricant | No errors. |
| App\Entity\Membre |
|
| App\Entity\Figurine |
|
| App\Entity\Appelation | No errors. |
| App\Entity\Note | No errors. |
| App\Entity\SpecialitenFabricant | No errors. |
| App\Entity\TypeFigurineFabricant | No errors. |
| App\Entity\FigurineGammes | No errors. |
| App\Entity\FigurineSerie | No errors. |
| App\Entity\Categories | No errors. |
| App\Entity\PostTag | No errors. |
| App\Entity\TypeSerie | No errors. |
| App\Entity\Personnage | No errors. |
| App\Entity\SerieLicencePhotos | No errors. |
| App\Entity\TypeGamme | 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 |
|
| App\Entity\FigurineSculpteur |
|
| App\Entity\FigurineIllustrator | No errors. |
| App\Entity\FigurineCategories | No errors. |
| App\Entity\MembreCollection | No errors. |
| App\Entity\MembreWishlist | No errors. |