Query Metrics

102 Database Queries
11 Different statements
22.93 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.29 ms
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_name AS manufacturers_name_2, t0.manufacturers_image AS manufacturers_image_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.manufacturers_statuts AS manufacturers_statuts_6, t0.manufacturers_order AS manufacturers_order_7, t0.manufacturers_locked_price AS manufacturers_locked_price_8, t0.manufacturers_welcome AS manufacturers_welcome_9, t0.manufacturers_export AS manufacturers_export_10 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters:
[
  "104"
]
2 0.17 ms
SELECT t0.id AS id_1, t0.manufacturers_title AS manufacturers_title_2, t0.manufacturers_url AS manufacturers_url_3, t0.manufacturers_description1 AS manufacturers_description1_4, t0.manufacturers_description2 AS manufacturers_description2_5, t0.url_clicked AS url_clicked_6, t0.date_last_click AS date_last_click_7, t0.manufacturers_id AS manufacturers_id_8, t0.languages_id AS languages_id_9 FROM manufacturers_info t0 WHERE t0.manufacturers_id = ?
Parameters:
[
  104
]
3 0.12 ms
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = ?
Parameters:
[
  1
]
4 0.10 ms
SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = ?
Parameters:
[
  4
]
5 2.60 ms
SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.products_parent_id AS products_parent_id_65, p0_.manufacturers_id AS manufacturers_id_66, p0_.products_tax_class_id AS products_tax_class_id_67 FROM products p0_ WHERE p0_.products_parent_id IS NULL AND p0_.manufacturers_id = ? AND p0_.products_status = ? ORDER BY p0_.products_id DESC LIMIT 20
Parameters:
[
  104
  1
]
6 0.20 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  668
]
7 0.18 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  1392
]
8 0.18 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  437
]
9 0.17 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  670
]
10 0.15 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  1485
]
11 0.17 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  705
]
12 1.92 ms
SELECT count(p0_.products_id) AS sclr_0 FROM products p0_ WHERE p0_.products_parent_id IS NULL AND p0_.manufacturers_id = ? AND p0_.products_status = ?
Parameters:
[
  104
  1
]
13 0.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
14 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
15 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
16 0.26 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  23078
]
17 0.22 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64823
]
18 0.26 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  23078
]
19 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
20 0.23 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  23060
]
21 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64815
]
22 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  23060
]
23 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
24 0.19 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  23054
]
25 0.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  57768
]
26 0.22 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  23054
]
27 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
28 0.17 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  23053
]
29 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  57767
]
30 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  23053
]
31 0.15 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
32 0.22 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  22570
]
33 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64662
]
34 0.27 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  22570
]
35 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
36 0.21 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  22563
]
37 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  57247
]
38 0.21 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  22563
]
39 0.09 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
40 0.14 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  22562
]
41 0.10 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  57245
]
42 0.20 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  22562
]
43 0.14 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
44 0.20 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  22521
]
45 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64649
]
46 0.21 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  22521
]
47 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
48 0.19 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  22510
]
49 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64645
]
50 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  22510
]
51 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
52 0.20 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21616
]
53 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64428
]
54 0.21 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21616
]
55 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
56 0.20 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21613
]
57 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  66139
]
58 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21613
]
59 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
60 0.19 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21610
]
61 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  66140
]
62 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21610
]
63 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
64 0.22 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21501
]
65 0.16 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64388
]
66 0.19 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21501
]
67 0.12 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
68 0.16 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21495
]
69 0.17 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  56084
]
70 0.20 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21495
]
71 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
72 0.22 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21454
]
73 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  56049
]
74 0.22 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21454
]
75 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
76 0.22 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21453
]
77 0.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  56048
]
78 0.24 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21453
]
79 0.17 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
80 0.23 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21207
]
81 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64320
]
82 0.23 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21207
]
83 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
84 0.23 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21206
]
85 0.19 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  55764
]
86 0.20 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21206
]
87 0.13 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
88 0.20 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21205
]
89 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  55762
]
90 0.18 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21205
]
91 0.14 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
92 0.22 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  21204
]
93 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  55761
]
94 0.21 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21204
]
95 0.30 ms
SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_parent_id AS products_parent_id_66, t0.manufacturers_id AS manufacturers_id_67, t0.products_tax_class_id AS products_tax_class_id_68 FROM products t0 WHERE t0.products_id = ?
Parameters:
[
  "20266"
]
96 0.15 ms
SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  613
]
97 0.15 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "VV"
]
98 0.20 ms
SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t0.products_id AS products_id_6, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = ? ORDER BY t1.`rank` ASC, t1.id ASC
Parameters:
[
  20266
]
99 0.14 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.pictures_id AS pictures_id_4, t0.language_id AS language_id_5 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  64085
]
100 0.23 ms
SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  20266
]
101 0.15 ms
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_name AS manufacturers_name_2, t0.manufacturers_image AS manufacturers_image_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.manufacturers_statuts AS manufacturers_statuts_6, t0.manufacturers_order AS manufacturers_order_7, t0.manufacturers_locked_price AS manufacturers_locked_price_8, t0.manufacturers_welcome AS manufacturers_welcome_9, t0.manufacturers_export AS manufacturers_export_10 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters:
[
  5
]
102 0.16 ms
SELECT t0.id AS id_1, t0.manufacturers_title AS manufacturers_title_2, t0.manufacturers_url AS manufacturers_url_3, t0.manufacturers_description1 AS manufacturers_description1_4, t0.manufacturers_description2 AS manufacturers_description2_5, t0.url_clicked AS url_clicked_6, t0.date_last_click AS date_last_click_7, t0.manufacturers_id AS manufacturers_id_8, t0.languages_id AS languages_id_9 FROM manufacturers_info t0 WHERE t0.manufacturers_id = ?
Parameters:
[
  5
]

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.