Query Metrics
29
Database Queries
22
Different statements
158.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
145.49 ms (91.52%) |
1 |
SELECT pa.products_id, a.attributes_code, pa.attributes_value FROM products_attributes pa INNER JOIN attributes a ON a.attributes_id = pa.attributes_id WHERE pa.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a.attributes_code IN (?)
Parameters:
[ 24947 24946 24945 24944 24943 24942 24941 25189 25176 25181 25178 25177 25182 27047 25183 25175 25180 13944 13942 13946 13940 13938 13936 16636 16638 16641 16497 16496 25841 22847 22839 22831 25840 22846 22838 22830 25839 22845 22837 22829 25838 22844 22836 22828 25837 22843 22835 22827 25836 22842 22834 22826 25835 22841 22833 22825 25127 23801 25931 25119 25124 23800 25930 25116 25125 23799 25929 14010 14073 14082 14079 14070 14076 14085 16737 27012 16736 13945 13943 13947 13939 13937 16582 16583 14012 14072 14081 14078 14069 14075 14084 25117 25126 23798 25928 25118 25128 23797 25927 25120 25122 23796 25926 25114 25123 23795 25925 25115 22318 22310 22302 22294 22286 22317 22309 22301 22293 22285 22316 22308 22300 22292 22284 22315 22307 22299 22291 22283 22314 22306 22298 22290 22282 22313 22305 22297 22289 22281 22312 22304 22296 22288 22280 21372 21364 21356 21348 21340 21332 21324 21316 21308 21371 21363 21355 21347 21339 21331 21323 21315 21307 21370 21362 21354 21346 21338 21330 21322 21314 21306 21369 21361 21353 21345 21337 21329 21321 21313 21305 21368 21360 21352 21344 21336 21328 21320 21312 21304 21367 21359 21351 26947 25041 21343 21335 21327 21319 21311 21303 21366 21358 21350 21342 21334 21326 21318 21310 21302 23636 23632 23628 23635 23631 23627 23634 23630 23626 19874 19871 19870 19867 22256 22255 22254 19864 19863 19862 19861 19860 19859 19858 19857 19856 19854 19853 19851 19850 19849 19848 19847 19846 24679 24683 24694 24688 24678 24693 24686 24680 24682 25040 25032 25031 25025 25024 25018 20526 20524 20523 20519 20518 24695 24687 23448 24180 23456 23447 24179 23455 23446 24178 23454 23445 24177 23453 23444 24176 23452 23443 23459 23451 23442 23458 23450 26895 26894 24701 13894 13886 13890 13882 13893 13885 13889 13881 13892 13884 13888 13880 24881 16739 16738 26847 16584 26845 24882 24879 24880 25846 22823 22818 22813 25845 22822 22817 22812 25844 22821 22816 22811 25843 22820 22815 22810 6367 6437 6499 6491 25201 25198 25194 25200 25197 25195 25193 15284 15283 15282 26798 15281 26797 26796 24675 15280 24668 24664 24703 24671 24697 24669 24690 24696 24665 24672 26793 24691 24666 24676 24673 26785 26784 26783 26782 16655 26781 16639 16642 26780 16654 16670 26779 16653 16669 13914 24650 26778 24649 13913 24648 19028 19019 19027 26743 19031 26742 19026 26741 15055 15054 15053 15052 15050 15048 16295 16287 16282 16294 16290 16286 16281 16293 16289 16285 16280 16292 16284 16279 13741 19118 13725 13713 13707 13719 13701 13747 13735 13740 19117 13724 13712 13706 13718 13700 13746 13734 13739 13729 13723 13711 13705 13717 13699 13745 13733 13738 13728 13722 13710 13704 13716 13698 13744 13732 13737 13727 13721 13709 13703 13715 13697 13743 13731 16896 16899 16891 16895 16898 16890 16894 16893 16888 13539 13544 13538 13543 13537 13542 13536 13541 23810 26094 25108 23809 26093 25107 25112 23808 26092 25106 25111 23807 26091 25105 25110 23806 26090 25104 23816 26100 25098 23815 26099 25097 25102 23814 26098 25096 25101 23813 26097 25095 25100 23812 26096 25094 16029 16053 16023 16047 16017 16041 16011 16035 16005 16028 16052 16022 16046 16016 16040 16010 16034 16004 16027 16051 16021 16045 16015 16039 16009 16033 16003 16026 16050 16020 16044 16014 16038 16008 16032 16002 16025 16049 16019 16043 16013 16037 16007 16031 16001 17130 17127 17124 17098 17078 17129 17126 17123 17077 16985 17032 17008 17056 16984 17012 17060 16989 16960 17154 17031 17007 17055 16983 17035 17011 17059 16988 16959 16946 17030 17006 17054 16982 16947 17010 17058 16987 17137 17136 17133 17162 16963 17149 17155 26616 17132 17101 17081 17100 17080 17148 16962 9521 9518 9536 9720 9738 9722 9737 9527 9718 9735 9015 8687 8568 9014 16166 16161 16156 16151 16165 16160 16155 16150 16164 16159 16154 16149 16163 16158 16153 16148 25207 25204 25213 25210 25206 25203 25212 25209 26380 26378 26377 26376 26375 26374 26373 26372 26371 26370 26369 26368 26367 26366 26365 26355 26354 26353 26352 26351 26350 26325 26324 26323 25187 25191 25186 25185 "precise_color" ] |
|
3.63 ms (2.28%) |
1 |
SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id IN (?) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC
Parameters:
[
630
]
|
|
2.13 ms (1.34%) |
1 |
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:
[ 14973 "%product_info.php?products_id=14973&%" ] |
|
0.73 ms (0.46%) |
4 |
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"
]
|
|
0.73 ms (0.46%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 368 2062 2061 2060 2040 2037 2035 2034 2067 2068 2071 1478 2111 2066 2058 2108 468 467 519 1888 378 1886 1933 1932 1931 1930 1929 1928 1927 1851 1850 1848 1943 1855 1973 210 1984 2057 1926 170 1854 44 1847 1846 1845 1844 2005 2004 2003 2002 2001 2000 1999 1861 1821 1843 1842 1841 419 454 418 208 2129 1941 1940 1924 1923 1922 1921 1840 1839 1837 2011 466 1945 2010 1944 2009 1820 415 1963 1962 1961 2109 2107 2106 1947 1817 1816 1815 1814 1813 1812 1811 1998 347 2033 1959 1958 1957 1956 2128 1955 1803 2101 1802 2099 1801 2085 1800 538 1754 1752 2164 2163 1910 1909 1908 1907 2013 2007 2006 2083 2082 2076 2133 2132 2131 2130 2084 1877 2141 1876 1875 1863 1996 2140 2135 2138 1862 2150 2096 1795 1794 1793 496 1792 1791 536 2075 2167 2137 2023 1896 1895 1894 1889 1887 226 375 386 188 187 380 462 507 385 1782 1781 1780 1779 1778 1954 1858 1953 1975 1455 221 219 1468 2056 2055 2054 1768 1767 1766 1765 1764 383 403 433 2047 2046 1489 2053 1488 2127 2086 2126 429 483 2064 2090 2091 2089 2088 2063 2065 1470 478 1763 1762 1761 1760 424 1091 1695 1694 1481 2087 2100 2095 2094 2115 2112 2116 2113 485 476 2110 481 2072 2069 ] |
|
0.64 ms (0.40%) |
3 |
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:
[
630
]
|
|
0.58 ms (0.37%) |
1 |
SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = ?
Parameters:
[
14973
]
|
|
0.57 ms (0.36%) |
1 |
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:
[
14973
]
|
|
0.56 ms (0.35%) |
3 |
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:
[
630
]
|
|
0.46 ms (0.29%) |
1 |
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_.is_default_variant AS is_default_variant_65, p0_.products_parent_id AS products_parent_id_66, p0_.products_model_id AS products_model_id_67, p0_.manufacturers_id AS manufacturers_id_68, p0_.products_tax_class_id AS products_tax_class_id_69 FROM products p0_ WHERE p0_.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 24964 24947 25189 27058 25176 25181 27047 13944 13942 13946 ] |
|
0.44 ms (0.27%) |
1 |
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.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_id = ?
Parameters:
[
"14973"
]
|
|
0.43 ms (0.27%) |
1 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 185 421 428 434 455 493 413 39 39 56 56 64 64 64 64 98 98 98 98 98 115 115 115 115 115 136 136 136 137 137 141 142 142 142 148 148 148 148 148 148 148 151 151 157 157 157 158 158 158 162 162 162 162 162 162 162 169 169 185 194 194 195 195 207 195 229 229 229 229 232 232 232 250 250 250 250 260 260 260 260 262 263 263 263 263 263 263 263 272 272 56 273 273 273 185 185 281 282 281 282 282 284 284 284 262 185 56 207 336 337 337 337 337 337 337 337 346 346 348 348 348 346 382 281 396 396 396 396 413 413 413 421 421 421 422 422 396 396 396 427 169 428 434 435 434 435 434 435 382 442 442 452 453 141 413 455 427 427 465 465 471 471 194 141 471 141 473 473 474 473 229 434 486 487 486 487 493 493 282 272 453 453 453 453 452 452 452 195 207 474 262 262 382 ] |
|
0.34 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.34 ms (0.21%) |
1 |
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.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_parent_id = ?
Parameters:
[
14973
]
|
|
0.33 ms (0.21%) |
1 |
SELECT m.id, m.listing_axis, v.axis1, v.axis2 FROM products_models m INNER JOIN products_models_variants v ON v.id = m.variant_id WHERE m.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND m.listing_axis IS NOT NULL
Parameters:
[ 368 396 435 434 422 474 468 467 519 229 378 263 162 56 169 262 210 170 44 337 194 151 158 419 454 418 208 272 260 157 348 466 273 415 284 473 148 336 347 281 282 142 141 538 250 346 452 442 453 195 207 137 136 496 536 382 232 226 375 386 188 187 380 462 507 385 115 185 221 219 421 98 383 403 433 413 493 429 483 465 427 428 478 64 424 1091 39 455 471 486 487 485 476 481 ] |
|
0.27 ms (0.17%) |
1 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ WHERE m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.type = ? AND m0_.active = 1
Parameters:
[ "2026-10-27 17:38:05" "2026-10-27 17:38:05" "percent-soleil" ] |
|
0.27 ms (0.17%) |
1 |
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:
[
14973
]
|
|
0.27 ms (0.17%) |
1 |
SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = ? AND m0_.date_from <= ? AND m0_.date_to >= ? AND m0_.active = 1
Parameters:
[ 14973 "2026-10-27 17:38:05" "2026-10-27 17:38:05" ] |
|
0.22 ms (0.14%) |
1 |
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.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
630
]
|
|
0.19 ms (0.12%) |
1 |
SELECT t0.manufacturers_id AS manufacturers_id_1, t0.manufacturers_code AS manufacturers_code_2, t0.manufacturers_name AS manufacturers_name_3, t0.manufacturers_image AS manufacturers_image_4, t0.date_added AS date_added_5, t0.last_modified AS last_modified_6, t0.manufacturers_statuts AS manufacturers_statuts_7, t0.manufacturers_order AS manufacturers_order_8, t0.manufacturers_locked_price AS manufacturers_locked_price_9, t0.manufacturers_welcome AS manufacturers_welcome_10, t0.manufacturers_export AS manufacturers_export_11, t0.manufacturers_no_soleil AS manufacturers_no_soleil_12 FROM manufacturers t0 WHERE t0.manufacturers_id = ?
Parameters:
[
192
]
|
|
0.17 ms (0.11%) |
1 |
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.code = ? LIMIT 1
Parameters:
[
"en"
]
|
|
0.16 ms (0.10%) |
1 |
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
]
|
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.