GET https://spectre.asb-digital.fr/fr/produit/automoteur-pulverisateur-spectre-b

Query Metrics

17 Database Queries
13 Different statements
25.45 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
4.48 ms
(17.61%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.product_id AS product_id_4 FROM product_info_avantage t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
4.29 ms
(16.84%)
1
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_size AS image_size_3, t0.image_updated_at AS image_updated_at_4, t0.image_alt AS image_alt_5, t0.url_youtube_original AS url_youtube_original_6, t0.url_youtube_embed AS url_youtube_embed_7, t0.product_id AS product_id_8 FROM product_info_media t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
4.02 ms
(15.78%)
3
SELECT t0.id AS id_1, t0.display AS display_2, t0.name AS name_3, t0.sub_title AS sub_title_4, t0.title AS title_5, t0.rotate_label AS rotate_label_6, t0.description AS description_7, t0.brochure_name AS brochure_name_8, t0.brochure_size AS brochure_size_9, t0.brochure_updated_at AS brochure_updated_at_10, t0.illustration_name AS illustration_name_11, t0.illustration_size AS illustration_size_12, t0.illustration_updated_at AS illustration_updated_at_13, t0.illustration_alt AS illustration_alt_14, t0.url_youtube_original AS url_youtube_original_15, t0.url_youtube_embed AS url_youtube_embed_16, t0.illustration_video_name AS illustration_video_name_17, t0.illustration_video_size AS illustration_video_size_18, t0.illustration_video_updated_at AS illustration_video_updated_at_19, t0.illustration_video_alt AS illustration_video_alt_20, t0.illustration_avantage_name AS illustration_avantage_name_21, t0.illustration_avantage_size AS illustration_avantage_size_22, t0.illustration_avantage_updated_at AS illustration_avantage_updated_at_23, t0.illustration_avantage_alt AS illustration_avantage_alt_24, t0.technical_data_icon_name AS technical_data_icon_name_25, t0.technical_data_icon_size AS technical_data_icon_size_26, t0.technical_data_icon_updated_at AS technical_data_icon_updated_at_27, t0.technical_data_icon_alt AS technical_data_icon_alt_28, t0.options_icon_name AS options_icon_name_29, t0.options_icon_size AS options_icon_size_30, t0.options_icon_updated_at AS options_icon_updated_at_31, t0.options_icon_alt AS options_icon_alt_32, t0.last_section_sub_title AS last_section_sub_title_33, t0.last_section_title AS last_section_title_34, t0.last_section_text AS last_section_text_35, t0.last_section_cta_link AS last_section_cta_link_36, t0.last_section_cta_text AS last_section_cta_text_37, t0.last_section_cta_external AS last_section_cta_external_38, t0.last_section_illustration_name AS last_section_illustration_name_39, t0.last_section_illustration_size AS last_section_illustration_size_40, t0.last_section_illustration_updated_at AS last_section_illustration_updated_at_41, t0.last_section_illustration_alt AS last_section_illustration_alt_42, t0.last_section_second_illustration_name AS last_section_second_illustration_name_43, t0.last_section_second_illustration_size AS last_section_second_illustration_size_44, t0.last_section_second_illustration_updated_at AS last_section_second_illustration_updated_at_45, t0.last_section_second_illustration_alt AS last_section_second_illustration_alt_46, t0.last_section_text_rotate AS last_section_text_rotate_47, t0.meta_title AS meta_title_48, t0.meta_description AS meta_description_49, t0.locale AS locale_50, t0.slug AS slug_51, t0.original_page_id AS original_page_id_52 FROM product t0 WHERE t0.locale = ? AND t0.display = ?
Parameters:
[
  "fr"
  1
]
2.72 ms
(10.70%)
1
SELECT p0_.id AS id_0, p0_.display AS display_1, p0_.name AS name_2, p0_.sub_title AS sub_title_3, p0_.title AS title_4, p0_.rotate_label AS rotate_label_5, p0_.description AS description_6, p0_.brochure_name AS brochure_name_7, p0_.brochure_size AS brochure_size_8, p0_.brochure_updated_at AS brochure_updated_at_9, p0_.illustration_name AS illustration_name_10, p0_.illustration_size AS illustration_size_11, p0_.illustration_updated_at AS illustration_updated_at_12, p0_.illustration_alt AS illustration_alt_13, p0_.url_youtube_original AS url_youtube_original_14, p0_.url_youtube_embed AS url_youtube_embed_15, p0_.illustration_video_name AS illustration_video_name_16, p0_.illustration_video_size AS illustration_video_size_17, p0_.illustration_video_updated_at AS illustration_video_updated_at_18, p0_.illustration_video_alt AS illustration_video_alt_19, p0_.illustration_avantage_name AS illustration_avantage_name_20, p0_.illustration_avantage_size AS illustration_avantage_size_21, p0_.illustration_avantage_updated_at AS illustration_avantage_updated_at_22, p0_.illustration_avantage_alt AS illustration_avantage_alt_23, p0_.technical_data_icon_name AS technical_data_icon_name_24, p0_.technical_data_icon_size AS technical_data_icon_size_25, p0_.technical_data_icon_updated_at AS technical_data_icon_updated_at_26, p0_.technical_data_icon_alt AS technical_data_icon_alt_27, p0_.options_icon_name AS options_icon_name_28, p0_.options_icon_size AS options_icon_size_29, p0_.options_icon_updated_at AS options_icon_updated_at_30, p0_.options_icon_alt AS options_icon_alt_31, p0_.last_section_sub_title AS last_section_sub_title_32, p0_.last_section_title AS last_section_title_33, p0_.last_section_text AS last_section_text_34, p0_.last_section_cta_link AS last_section_cta_link_35, p0_.last_section_cta_text AS last_section_cta_text_36, p0_.last_section_cta_external AS last_section_cta_external_37, p0_.last_section_illustration_name AS last_section_illustration_name_38, p0_.last_section_illustration_size AS last_section_illustration_size_39, p0_.last_section_illustration_updated_at AS last_section_illustration_updated_at_40, p0_.last_section_illustration_alt AS last_section_illustration_alt_41, p0_.last_section_second_illustration_name AS last_section_second_illustration_name_42, p0_.last_section_second_illustration_size AS last_section_second_illustration_size_43, p0_.last_section_second_illustration_updated_at AS last_section_second_illustration_updated_at_44, p0_.last_section_second_illustration_alt AS last_section_second_illustration_alt_45, p0_.last_section_text_rotate AS last_section_text_rotate_46, p0_.meta_title AS meta_title_47, p0_.meta_description AS meta_description_48, p0_.locale AS locale_49, p0_.slug AS slug_50, p0_.original_page_id AS original_page_id_51 FROM product p0_ WHERE p0_.locale = ? AND p0_.id <> ? AND p0_.display = 1
Parameters:
[
  "fr"
  2
]
2.67 ms
(10.51%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.product_id AS product_id_4 FROM product_data_table t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
2.08 ms
(8.16%)
3
SELECT t0.id AS id_1, t0.display AS display_2, t0.name AS name_3, t0.description_other_page AS description_other_page_4, t0.title AS title_5, t0.description AS description_6, t0.illustration_panoramic_name AS illustration_panoramic_name_7, t0.illustration_panoramic_size AS illustration_panoramic_size_8, t0.illustration_panoramic_updated_at AS illustration_panoramic_updated_at_9, t0.illustration_panoramic_alt AS illustration_panoramic_alt_10, t0.illustration_panoramic_logo_name AS illustration_panoramic_logo_name_11, t0.illustration_panoramic_logo_size AS illustration_panoramic_logo_size_12, t0.illustration_panoramic_logo_updated_at AS illustration_panoramic_logo_updated_at_13, t0.illustration_panoramic_logo_alt AS illustration_panoramic_logo_alt_14, t0.url_youtube_original AS url_youtube_original_15, t0.url_youtube_embed AS url_youtube_embed_16, t0.paragraph_sub_title AS paragraph_sub_title_17, t0.paragraph_title AS paragraph_title_18, t0.paragraph_text AS paragraph_text_19, t0.paragraph_name AS paragraph_name_20, t0.paragraph_size AS paragraph_size_21, t0.paragraph_updated_at AS paragraph_updated_at_22, t0.paragraph_extension AS paragraph_extension_23, t0.paragraph_illustration1_name AS paragraph_illustration1_name_24, t0.paragraph_illustration1_size AS paragraph_illustration1_size_25, t0.paragraph_illustration1_updated_at AS paragraph_illustration1_updated_at_26, t0.paragraph_illustration1_alt AS paragraph_illustration1_alt_27, t0.paragraph_illustration2_name AS paragraph_illustration2_name_28, t0.paragraph_illustration2_size AS paragraph_illustration2_size_29, t0.paragraph_illustration2_updated_at AS paragraph_illustration2_updated_at_30, t0.paragraph_illustration2_alt AS paragraph_illustration2_alt_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.locale AS locale_34, t0.slug AS slug_35, t0.original_page_id AS original_page_id_36 FROM technology t0 WHERE t0.locale = ? AND t0.display = ?
Parameters:
[
  "fr"
  1
]
1.40 ms
(5.50%)
1
SELECT t0.id AS id_1, t0.display AS display_2, t0.name AS name_3, t0.sub_title AS sub_title_4, t0.title AS title_5, t0.rotate_label AS rotate_label_6, t0.description AS description_7, t0.brochure_name AS brochure_name_8, t0.brochure_size AS brochure_size_9, t0.brochure_updated_at AS brochure_updated_at_10, t0.illustration_name AS illustration_name_11, t0.illustration_size AS illustration_size_12, t0.illustration_updated_at AS illustration_updated_at_13, t0.illustration_alt AS illustration_alt_14, t0.url_youtube_original AS url_youtube_original_15, t0.url_youtube_embed AS url_youtube_embed_16, t0.illustration_video_name AS illustration_video_name_17, t0.illustration_video_size AS illustration_video_size_18, t0.illustration_video_updated_at AS illustration_video_updated_at_19, t0.illustration_video_alt AS illustration_video_alt_20, t0.illustration_avantage_name AS illustration_avantage_name_21, t0.illustration_avantage_size AS illustration_avantage_size_22, t0.illustration_avantage_updated_at AS illustration_avantage_updated_at_23, t0.illustration_avantage_alt AS illustration_avantage_alt_24, t0.technical_data_icon_name AS technical_data_icon_name_25, t0.technical_data_icon_size AS technical_data_icon_size_26, t0.technical_data_icon_updated_at AS technical_data_icon_updated_at_27, t0.technical_data_icon_alt AS technical_data_icon_alt_28, t0.options_icon_name AS options_icon_name_29, t0.options_icon_size AS options_icon_size_30, t0.options_icon_updated_at AS options_icon_updated_at_31, t0.options_icon_alt AS options_icon_alt_32, t0.last_section_sub_title AS last_section_sub_title_33, t0.last_section_title AS last_section_title_34, t0.last_section_text AS last_section_text_35, t0.last_section_cta_link AS last_section_cta_link_36, t0.last_section_cta_text AS last_section_cta_text_37, t0.last_section_cta_external AS last_section_cta_external_38, t0.last_section_illustration_name AS last_section_illustration_name_39, t0.last_section_illustration_size AS last_section_illustration_size_40, t0.last_section_illustration_updated_at AS last_section_illustration_updated_at_41, t0.last_section_illustration_alt AS last_section_illustration_alt_42, t0.last_section_second_illustration_name AS last_section_second_illustration_name_43, t0.last_section_second_illustration_size AS last_section_second_illustration_size_44, t0.last_section_second_illustration_updated_at AS last_section_second_illustration_updated_at_45, t0.last_section_second_illustration_alt AS last_section_second_illustration_alt_46, t0.last_section_text_rotate AS last_section_text_rotate_47, t0.meta_title AS meta_title_48, t0.meta_description AS meta_description_49, t0.locale AS locale_50, t0.slug AS slug_51, t0.original_page_id AS original_page_id_52 FROM product t0 WHERE t0.slug = ? AND t0.locale = ? LIMIT 1
Parameters:
[
  "automoteur-pulverisateur-spectre-b"
  "fr"
]
0.79 ms
(3.10%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.product_id AS product_id_3 FROM product_option_avantage t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.72 ms
(2.84%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.paragraph AS paragraph_3, t0.illustration_paragraph_name AS illustration_paragraph_name_4, t0.illustration_paragraph_size AS illustration_paragraph_size_5, t0.illustration_paragraph_updated_at AS illustration_paragraph_updated_at_6, t0.illustration_paragraph_alt AS illustration_paragraph_alt_7, t0.icon_name AS icon_name_8, t0.icon_size AS icon_size_9, t0.icon_updated_at AS icon_updated_at_10, t0.icon_alt AS icon_alt_11, t0.product_id AS product_id_12 FROM product_info t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.71 ms
(2.77%)
1
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.route AS route_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.h1_enabled AS h1_enabled_6, t0.h1 AS h1_7 FROM seopage t0 WHERE t0.route = ? LIMIT 1
Parameters:
[
  "app_product_show"
]
0.68 ms
(2.68%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.illustration_name AS illustration_name_4, t0.illustration_size AS illustration_size_5, t0.illustration_updated_at AS illustration_updated_at_6, t0.illustration_alt AS illustration_alt_7, t0.product_id AS product_id_8 FROM product_option_paragraph t0 WHERE t0.product_id = ?
Parameters:
[
  2
]
0.45 ms
(1.77%)
1
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.address_street AS address_street_4, t0.zipcode AS zipcode_5, t0.city AS city_6, t0.legal_site_name AS legal_site_name_7, t0.legal_siret AS legal_siret_8, t0.legal_siren AS legal_siren_9, t0.legal_rcs AS legal_rcs_10, t0.legal_address AS legal_address_11, t0.legal_zipcode AS legal_zipcode_12, t0.legal_city AS legal_city_13, t0.legal_phone AS legal_phone_14, t0.legal_email AS legal_email_15, t0.legal_publication_owner AS legal_publication_owner_16, t0.legal_site_url AS legal_site_url_17, t0.default_title AS default_title_18, t0.default_meta_desc AS default_meta_desc_19 FROM site_settings t0
Parameters:
[]
0.44 ms
(1.72%)
1
SELECT t0.id AS id_1, t0.text AS text_2, t0.product_id AS product_id_3 FROM product_plus t0 WHERE t0.product_id = ?
Parameters:
[
  2
]

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.