12.21 ms (33.70%)
|
1 |
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM figurine f0_ INNER JOIN figurine_categories f1_ ON f0_.id = f1_.figurine_id INNER JOIN figurine_fabriquant f2_ ON f0_.figurine_fabriquant_id = f2_.id INNER JOIN figurine_serie f3_ ON f0_.serie_id = f3_.id WHERE (f0_.id <> ? AND f1_.categories_id IN (?, ?) AND f2_.id = ?) OR f3_.id = ?
Parameters: [
2336
2
3
4
5
]
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM figurine f0_ INNER JOIN figurine_categories f1_ ON f0_.id = f1_.figurine_id INNER JOIN figurine_fabriquant f2_ ON f0_.figurine_fabriquant_id = f2_.id INNER JOIN figurine_serie f3_ ON f0_.serie_id = f3_.id WHERE (f0_.id <> 2336 AND f1_.categories_id IN (2, 3) AND f2_.id = 4) OR f3_.id = 5;
|
3.77 ms (10.41%)
|
2 |
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.slug = ? LIMIT 1
Parameters: [
"figurine-azur-lane-amagicv-ver-throne-of-fallen-petals-good-smile-company"
]
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.slug = 'figurine-azur-lane-amagicv-ver-throne-of-fallen-petals-good-smile-company' LIMIT 1;
|
3.35 ms (9.25%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.old_id AS old_id_4 FROM post_tag t0 INNER JOIN figurine_post_tag ON t0.id = figurine_post_tag.post_tag_id WHERE figurine_post_tag.figurine_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.old_id AS old_id_4 FROM post_tag t0 INNER JOIN figurine_post_tag ON t0.id = figurine_post_tag.post_tag_id WHERE figurine_post_tag.figurine_id = 2336;
|
2.68 ms (7.40%)
|
1 |
SELECT DISTINCT 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_ INNER JOIN figurine_categories f1_ ON f0_.id = f1_.figurine_id INNER JOIN figurine_fabriquant f2_ ON f0_.figurine_fabriquant_id = f2_.id INNER JOIN figurine_serie f3_ ON f0_.serie_id = f3_.id WHERE (f0_.id <> ? AND f1_.categories_id IN (?, ?) AND f2_.id = ?) OR f3_.id = ? LIMIT 4 OFFSET 61
Parameters: [
2336
2
3
4
5
]
SELECT DISTINCT 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_ INNER JOIN figurine_categories f1_ ON f0_.id = f1_.figurine_id INNER JOIN figurine_fabriquant f2_ ON f0_.figurine_fabriquant_id = f2_.id INNER JOIN figurine_serie f3_ ON f0_.serie_id = f3_.id WHERE (f0_.id <> 2336 AND f1_.categories_id IN (2, 3) AND f2_.id = 4) OR f3_.id = 5 LIMIT 4 OFFSET 61;
|
2.32 ms (6.39%)
|
1 |
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\Figurine"
2336
]
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 = 'App\\Entity\\Figurine' AND t0.object_id = 2336 LIMIT 1;
|
2.20 ms (6.06%)
|
13 |
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"
]
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 = 'id_page_pc' LIMIT 1;
|
1.82 ms (5.02%)
|
7 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.localisation AS localisation_3, t0.url AS url_4, t0.photo AS photo_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.old_id AS old_id_9, t0.pays AS pays_10, t0.photo_alt AS photo_alt_11, t0.description AS description_12 FROM figurine_boutique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.localisation AS localisation_3, t0.url AS url_4, t0.photo AS photo_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.old_id AS old_id_9, t0.pays AS pays_10, t0.photo_alt AS photo_alt_11, t0.description AS description_12 FROM figurine_boutique t0 WHERE t0.id = 2;
|
1.51 ms (4.17%)
|
1 |
SELECT t0.id AS id_1, t0.link AS link_2, t0.old_data AS old_data_3, t0.figurine_id AS figurine_id_4, t0.boutique_id AS boutique_id_5 FROM figurine_boutique_figurine t0 WHERE t0.figurine_id = ?
SELECT t0.id AS id_1, t0.link AS link_2, t0.old_data AS old_data_3, t0.figurine_id AS figurine_id_4, t0.boutique_id AS boutique_id_5 FROM figurine_boutique_figurine t0 WHERE t0.figurine_id = 2336;
|
1.48 ms (4.09%)
|
1 |
SELECT t0.id AS id_1, t0.old_data AS old_data_2, t0.figurine_id AS figurine_id_3, t0.categories_id AS categories_id_4 FROM figurine_categories t0 WHERE t0.figurine_id = ?
SELECT t0.id AS id_1, t0.old_data AS old_data_2, t0.figurine_id AS figurine_id_3, t0.categories_id AS categories_id_4 FROM figurine_categories t0 WHERE t0.figurine_id = 2336;
|
1.38 ms (3.80%)
|
4 |
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.id = ?
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.id = 4;
|
1.28 ms (3.54%)
|
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 INNER JOIN figurine_posts ON t0.id = figurine_posts.posts_id WHERE figurine_posts.figurine_id = ?
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 figurine_posts ON t0.id = figurine_posts.posts_id WHERE figurine_posts.figurine_id = 2336;
|
0.37 ms (1.03%)
|
2 |
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 = ?
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 = 1;
|
0.31 ms (0.86%)
|
1 |
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.photo AS photo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.old_data AS old_data_7, t0.figurine_id AS figurine_id_8 FROM figurine_photos t0 WHERE t0.figurine_id = ?
SELECT t0.id AS id_1, t0.alt AS alt_2, t0.photo AS photo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.position AS position_6, t0.old_data AS old_data_7, t0.figurine_id AS figurine_id_8 FROM figurine_photos t0 WHERE t0.figurine_id = 2336;
|
0.27 ms (0.75%)
|
1 |
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 = ?
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 = 930;
|
0.26 ms (0.70%)
|
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 WHERE t0.id = ?
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 = 5;
|
0.22 ms (0.61%)
|
1 |
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 = ?
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 = 1;
|
0.22 ms (0.61%)
|
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 WHERE t0.id = ?
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 WHERE t0.id = 27;
|
0.22 ms (0.60%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_sculpteur t0 INNER JOIN figurine_figurine_sculpteur ON t0.id = figurine_figurine_sculpteur.figurine_sculpteur_id WHERE figurine_figurine_sculpteur.figurine_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_sculpteur t0 INNER JOIN figurine_figurine_sculpteur ON t0.id = figurine_figurine_sculpteur.figurine_sculpteur_id WHERE figurine_figurine_sculpteur.figurine_id = 2336;
|
0.19 ms (0.52%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM figurine_materiaux t0 INNER JOIN figurine_materiaux_figurine ON t0.id = figurine_materiaux_figurine.figurine_materiaux_id WHERE figurine_materiaux_figurine.figurine_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM figurine_materiaux t0 INNER JOIN figurine_materiaux_figurine ON t0.id = figurine_materiaux_figurine.figurine_materiaux_id WHERE figurine_materiaux_figurine.figurine_id = 2336;
|
0.18 ms (0.49%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_peintre t0 INNER JOIN figurine_figurine_peintre ON t0.id = figurine_figurine_peintre.figurine_peintre_id WHERE figurine_figurine_peintre.figurine_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM figurine_peintre t0 INNER JOIN figurine_figurine_peintre ON t0.id = figurine_figurine_peintre.figurine_peintre_id WHERE figurine_figurine_peintre.figurine_id = 2336;
|