Query Metrics

76 Database Queries
22 Different statements
11.48 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.48 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[]
2 0.46 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_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = ?
Parameters:
[
  "21289"
]
3 0.38 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_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = ?
Parameters:
[
  21289
]
4 0.81 ms
SELECT r0_.id AS id_0, r0_.redirect_url AS redirect_url_1, r0_.target_path AS target_path_2, r0_.target_url AS target_url_3, r0_.redirect_product_id AS redirect_product_id_4, r0_.redirect_category_id AS redirect_category_id_5, r0_.target_product_id AS target_product_id_6, r0_.target_category_id AS target_category_id_7 FROM redirections r0_ WHERE r0_.redirect_product_id = ? OR r0_.redirect_url LIKE ? LIMIT 1
Parameters:
[
  21289
  "%product_info.php?products_id=21289&%"
]
5 0.15 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.id = ?
Parameters:
[
  56
]
6 0.27 ms
SELECT p0_.id AS id_0, p0_.products_id AS products_id_1, p0_.categories_id AS categories_id_2 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.products_id = ?
Parameters:
[
  21289
]
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.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = ?
Parameters:
[
  2581
]
8 0.24 ms
SELECT p0_.id AS id_0, p0_.products_id AS products_id_1, p0_.categories_id AS categories_id_2 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.categories_id = ? AND p1_.products_status = 1 AND (p1_.products_model_id IS NULL OR p1_.is_default_variant = 1) LIMIT 10
Parameters:
[
  2581
]
9 0.19 ms
SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.label AS label_4, t0.heading_title AS heading_title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_video AS products_video_13, t0.products_conseil1 AS products_conseil1_14, t0.products_notice AS products_notice_15, t0.products_tags AS products_tags_16, t0.products_models_id AS products_models_id_17, t0.language_id AS language_id_18 FROM products_models_description t0 WHERE t0.products_models_id = ?
Parameters:
[
  56
]
10 0.17 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
]
11 0.16 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
]
12 0.20 ms
SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = ?
Parameters:
[
  2581
]
13 0.15 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.parent_id = ?
Parameters:
[
  56
]
14 0.28 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_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_model_id = ?
Parameters:
[
  56
]
15 0.16 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.axis1 AS axis1_4, t0.axis2 AS axis2_5 FROM products_models_variants t0 WHERE t0.id = ?
Parameters:
[
  22
]
16 0.20 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_code = ? LIMIT 1
Parameters:
[
  "precise_color"
]
17 0.38 ms
SELECT t0.products_attributes_id AS products_attributes_id_1, t0.attributes_value AS attributes_value_2, t0.products_id AS products_id_3, t0.attributes_id AS attributes_id_4 FROM products_attributes t0 WHERE t0.products_id = ?
Parameters:
[
  21288
]
18 0.18 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4830
]
19 0.12 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4848
]
20 0.09 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4849
]
21 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4842
]
22 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4770
]
23 0.14 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4806
]
24 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4635
]
25 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4682
]
26 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4683
]
27 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4703
]
28 0.11 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4831
]
29 0.10 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4832
]
30 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4594
]
31 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4774
]
32 0.10 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4773
]
33 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4771
]
34 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4772
]
35 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4810
]
36 0.14 ms
SELECT t0.colors_id AS colors_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.manufacturers_code = ? LIMIT 1
Parameters:
[
  "white"
]
37 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4621
]
38 0.09 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4834
]
39 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4818
]
40 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4808
]
41 0.15 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4852
]
42 0.16 ms
SELECT t0.colors_id AS colors_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.manufacturers_code = ? LIMIT 1
Parameters:
[
  "offwhite"
]
43 0.09 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4685
]
44 0.17 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4783
]
45 0.13 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4835
]
46 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4766
]
47 0.08 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4767
]
48 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4768
]
49 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4629
]
50 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4803
]
51 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4813
]
52 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4610
]
53 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4611
]
54 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4784
]
55 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4833
]
56 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4704
]
57 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4836
]
58 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4592
]
59 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4883
]
60 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4884
]
61 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4826
]
62 0.07 ms
SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
  4827
]
63 0.28 ms
SELECT t0.products_attributes_id AS products_attributes_id_1, t0.attributes_value AS attributes_value_2, t0.products_id AS products_id_3, t0.attributes_id AS attributes_id_4 FROM products_attributes t0 WHERE t0.products_id = ?
Parameters:
[
  21289
]
64 0.09 ms
SELECT t0.colors_id AS colors_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.manufacturers_code = ? LIMIT 1
Parameters:
[
  "brown"
]
65 0.09 ms
SELECT t0.colors_id AS colors_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.manufacturers_code = ? LIMIT 1
Parameters:
[
  "darkbrown"
]
66 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, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, 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:
[
  21288
]
67 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, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, 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:
[
  21289
]
68 0.16 ms
SELECT p0_.id AS id_0, p0_.sort_order AS sort_order_1, p0_.products_id AS products_id_2, p0_.xsell_id AS xsell_id_3 FROM products_xsell p0_ INNER JOIN products p1_ ON p0_.xsell_id = p1_.products_id WHERE p0_.products_id = ? AND p1_.products_status = 1 ORDER BY p0_.sort_order ASC
Parameters:
[
  21289
]
69 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"
]
70 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"
]
71 0.26 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24927
]
72 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24928
]
73 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24929
]
74 0.13 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24930
]
75 0.15 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24931
]
76 0.18 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = ?
Parameters:
[
  24932
]

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.