Query Metrics
514
Database Queries
30
Different statements
2272.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1823.44 ms (80.23%) |
1 |
select a.attributes_code, ad.attributes_title, a.attributes_order, pa.attributes_value, concat(coalesce(max(nullif(pad.value, '')), pa.attributes_value), coalesce( case pa_unit.attributes_value when 'MILLIMETER' then 'mm' when 'MILLILITER' then 'ml' when 'GRAM' then 'g' when 'MONTH' then '' else pa_unit.attributes_value end, '')) as attributes_displayed_value from attributes a inner join attributes_description ad on ad.attributes_id = a.attributes_id and ad.language_id = ? inner join products_attributes pa on pa.attributes_id = a.attributes_id inner join products_to_categories ptc on ptc.products_id = pa.products_id inner join products p on p.products_id = pa.products_id left join products_attributes_description pad on pad.products_attributes_id = pa.products_attributes_id and pad.language_id = ? left join attributes a_unit on a_unit.attributes_code = concat(a.attributes_code, '-unit') left join products_attributes pa_unit on pa_unit.attributes_id = a_unit.attributes_id and pa_unit.products_id = pa.products_id where a.attributes_filter = 1 and p.products_status = 1 and ptc.categories_id in (?) and pa.attributes_value is not null and pa.attributes_value <> '' group by a.attributes_code, pa.attributes_value, pa_unit.attributes_value order by a.attributes_order, attributes_displayed_value
Parameters:
[ 4 4 629 ] |
|
341.95 ms (15.05%) |
2 |
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:
[ 25911 25910 25909 25915 25914 25913 25912 25902 25900 25898 25896 25894 25892 25890 25996 25995 25994 25503 25502 25501 25500 25499 25498 25901 25899 25897 25494 25491 25488 25493 25490 25487 25781 25780 25779 25777 25776 25775 27050 27049 5320 5289 21819 21818 21807 21806 13594 13588 13591 13593 13587 13590 13956 13954 13958 13952 13950 13948 16626 16629 16633 14034 14031 14093 14102 14099 14090 14096 14105 26982 26981 16732 16573 16691 16690 16731 13957 13955 13959 13951 26954 16580 16574 16577 16593 16592 16587 26953 14033 14092 14101 14098 14089 14095 14104 26948 26945 25044 25043 26927 26925 26923 26922 21764 26921 21759 21763 26920 21758 26919 21762 26918 21757 26917 21761 26916 21756 26915 13424 13430 13425 13428 13431 13418 13432 13419 12982 12981 12888 12887 12976 12975 12883 24185 24184 15468 21155 21151 21147 21154 21150 21146 21153 21149 21145 21152 21148 21144 21143 21140 21137 21142 21139 21136 21141 21138 21135 15467 15466 15465 21134 21130 21126 21133 21129 21125 21132 21128 21124 21131 21127 21123 19053 17239 17233 25035 25034 25026 25021 25020 21531 21530 20536 20535 20534 20533 20531 20530 20529 20528 19472 19475 19474 19470 19473 19471 17227 21122 21119 21116 21121 21118 21115 21120 21117 21114 13410 17238 17232 19483 17226 19513 26898 19509 13411 17237 19469 17231 19505 17225 19479 19482 19512 17236 19508 19468 17224 19504 19478 19052 19481 17235 19511 17229 17223 19507 19467 26896 19047 19503 17221 19477 17215 17209 26893 19046 17220 17214 17208 13401 17218 17212 13400 17219 17207 26892 19045 17211 17205 18713 18711 13385 19035 13386 13388 13391 13394 13395 13370 13375 13380 13372 13377 13382 19006 19005 19994 19981 19993 19980 19992 19979 19991 19978 19990 19977 19989 19976 13447 19988 13445 19975 19987 13443 19974 13448 19986 13446 19973 13444 13437 19985 13439 19972 19984 13441 13435 19971 13438 19983 13440 19970 13442 13436 13906 13900 13903 13897 13905 13899 13902 13896 24432 24433 24434 24435 24873 24874 24876 24875 1103 1024 17195 17189 17183 17188 17187 17192 17186 17180 17185 16734 16692 16733 16581 16693 16578 26844 26843 15813 15811 15812 15805 15797 15789 15801 15793 15804 15808 15796 15800 15792 15803 15807 15795 15787 15799 15791 15313 15315 15317 15312 15314 15316 4168 4097 1116 1111 25833 22808 22803 22798 25832 22807 22802 22797 25831 22806 22801 22796 25830 22805 22800 26814 22795 26813 26812 26811 15286 15285 26792 26789 26788 26787 26786 15501 24116 15500 15499 25893 25891 25889 15493 24153 16627 16631 15490 15487 16635 15484 15492 24152 15489 15486 15483 15498 24117 15497 15496 15495 15494 15061 15060 15058 15056 16525 16524 16310 16307 16304 16299 16309 16303 16298 16306 16302 16301 16297 26739 16651 26738 16650 26737 16630 16634 26736 16649 26735 16648 13916 13921 13917 26733 13918 13922 13923 23494 23493 23492 23149 23148 23147 23146 23572 23571 23570 23569 23568 16560 16558 15937 15938 15939 15940 16101 16117 16097 16113 16093 16109 16089 16105 16085 16100 16116 16096 16112 16092 16108 16088 16104 16084 16099 16115 16095 16111 16091 16107 16087 16103 16083 16126 16125 16124 16123 16122 16121 16120 16119 16118 16079 16076 16061 16073 16057 16078 16069 16075 16066 16059 16063 16838 16837 16800 16842 16805 16836 16799 16841 16804 16835 16798 16840 16803 23567 23566 23565 23169 23168 23167 23166 26729 26728 16072 16055 13786 19119 13775 13767 13763 13771 13759 13790 13782 13785 13778 13774 13766 13762 13770 13758 13789 13781 13784 13777 13773 13765 13761 13769 13757 13788 13780 16070 16081 16067 16064 16080 16903 16907 16905 16902 26724 26723 16901 15622 15628 15631 15616 15619 15625 15613 15621 15627 15630 15615 15618 15624 15612 15601 15607 15610 15595 15598 15604 15592 15600 15606 15609 15594 24624 24620 24616 24622 24612 24610 24614 24626 24618 25147 23781 26081 25146 25143 25993 26083 25139 21473 21471 21469 21472 21467 21466 21468 21474 21470 21463 21461 21459 21462 21457 21456 21458 21464 21460 15597 15603 15591 26108 25132 25135 23804 26107 25131 25134 23803 26105 25151 25159 23785 26104 25155 25158 23784 26103 25154 25156 23783 26102 25152 26082 25145 26088 25150 26087 25149 25142 24040 26086 25138 25141 24039 26085 25137 13807 13805 13804 13800 13802 13803 13801 13808 13806 13816 13814 13813 13811 13810 13812 13809 13817 13815 13857 13847 23793 15888 15889 23647 23646 23645 23644 23643 23642 23640 23639 23638 13842 13832 13827 13837 13822 13862 13852 13856 13846 13841 13831 13826 13836 13821 13861 13851 13855 13845 13840 13830 13825 13835 13820 13860 13850 13854 13844 13839 13829 13824 13834 13819 13859 13849 25068 23787 25067 8448 14968 14966 14962 20566 20565 20564 14961 20563 14960 20562 14959 14958 16976 17000 17048 16975 17023 16999 17047 16974 16945 17049 16953 16944 16998 17046 16973 17158 16954 17144 17152 26614 17110 17072 17071 17163 17147 17146 16955 16957 19742 13630 13624 11661 15464 13636 11660 13629 11654 13623 26586 13628 11653 13622 11652 15463 11651 13627 26585 11649 13626 11648 13620 15462 13632 15481 24629 15480 15479 5410 5412 5417 5409 5414 5411 988 5416 1014 5405 8171 10668 10667 10666 10658 10651 9507 9505 9912 9535 9532 9761 9810 9526 9523 9063 9060 9057 9061 26565 9055 9059 9056 9069 9066 9064 9065 19034 17203 13555 13551 13559 13554 13550 13558 26562 13553 13549 9076 9074 9075 9073 8001 8000 7982 7971 7970 7969 7956 7954 7953 7896 7895 7877 15452 15449 15446 1036 1094 1058 1022 1004 16182 16178 16174 16170 16181 16177 16173 16169 16180 16176 16172 16168 26424 26423 26405 26404 26403 26402 26401 26359 26358 26357 26346 26343 26342 836 850 26337 26336 "precise_color" ] |
|
10.29 ms (0.45%) |
109 |
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, t0.attributes_suffix AS attributes_suffix_8 FROM attributes t0 WHERE t0.attributes_id = ?
Parameters:
[
250
]
|
|
8.88 ms (0.39%) |
38 |
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:
[
25911
]
|
|
8.80 ms (0.39%) |
2 |
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:
[
629
]
|
|
8.23 ms (0.36%) |
23 |
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:
[
25911
]
|
|
8.11 ms (0.36%) |
38 |
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:
[
25911
]
|
|
7.86 ms (0.35%) |
46 |
SELECT t0.colors_id AS colors_id_1, t0.colors_code AS colors_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.colors_code = ? LIMIT 1
Parameters:
[
"green"
]
|
|
6.10 ms (0.27%) |
40 |
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"
]
|
|
5.94 ms (0.26%) |
21 |
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:
[
25911
]
|
|
5.49 ms (0.24%) |
27 |
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:
[
629
]
|
|
5.35 ms (0.24%) |
27 |
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:
[
629
]
|
|
5.29 ms (0.23%) |
21 |
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 15:04:03" "2026-10-27 15:04:03" "percent-soleil" ] |
|
4.70 ms (0.21%) |
17 |
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:
[
"21612"
]
|
|
4.24 ms (0.19%) |
21 |
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:
[ 25911 "2026-10-27 15:04:03" "2026-10-27 15:04:03" ] |
|
4.09 ms (0.18%) |
23 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.products_attributes_id AS products_attributes_id_3, t0.language_id AS language_id_4 FROM products_attributes_description t0 WHERE t0.products_attributes_id = ?
Parameters:
[
433557
]
|
|
2.07 ms (0.09%) |
10 |
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:
[
176
]
|
|
1.99 ms (0.09%) |
13 |
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.listing_axis AS listing_axis_6, t0.products_cat AS products_cat_7, t0.parent_id AS parent_id_8, t0.manufacturers_id AS manufacturers_id_9, t0.variant_id AS variant_id_10, t0.default_product_id AS default_product_id_11 FROM products_models t0 WHERE t0.id = ?
Parameters:
[
1544
]
|
|
1.90 ms (0.08%) |
2 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1544 179 1453 1543 178 177 1542 1541 1616 1824 1823 1822 369 458 1474 2044 301 1728 1727 341 1534 265 1552 469 541 389 354 379 1711 1620 2313 1532 449 447 540 1650 1578 1577 2302 1621 1531 1649 165 164 2224 1660 1530 1529 161 159 1623 1579 1668 2052 1576 2050 1622 2049 1666 2048 1575 1966 1965 1964 1755 1834 1833 1832 1831 1830 1829 1828 1827 1826 1825 1482 416 1719 1718 1587 1586 1573 1572 1574 1810 1809 1808 1878 1872 1526 1870 2105 1525 1869 1867 1524 1460 2104 1459 2102 1866 1865 1864 1960 309 271 1939 1938 2144 1937 1936 280 1571 1570 1569 256 1919 2134 2175 1918 1917 2174 1916 2173 1914 1913 2172 1912 1523 1522 1521 1520 552 1625 1490 1707 1624 1706 505 1731 1741 1730 1729 1726 1740 1725 1732 1678 1152 2324 1231 1735 530 504 2152 2155 551 1568 1567 1566 1565 1549 1738 1691 1690 1656 440 1689 1688 1687 1583 1705 1704 1561 1560 1559 475 1558 1557 1655 1654 1737 1457 1699 1724 132 1665 1519 494 1743 1683 1682 361 327 53 227 409 408 1518 1517 1516 121 1515 1514 237 376 1646 189 391 1710 1675 463 1645 1548 1644 1547 325 1513 1667 1512 1511 1546 1685 1456 1545 222 220 1510 1509 1469 1458 287 1442 1564 1346 1562 1291 1280 1563 1269 106 1335 103 405 351 516 1708 1709 293 506 1698 89 1648 1703 49 1674 1641 1640 1670 1643 1669 1642 431 484 503 550 1702 1632 549 1701 548 1700 547 1631 317 1366 1358 1356 1365 1355 1354 2146 2148 286 539 498 2230 218 1556 1555 1554 1553 1739 1673 1589 2157 509 2156 1479 1630 1602 1601 1626 2154 2153 1664 1663 1629 1628 1627 1723 477 1672 1671 1722 312 1680 1736 1679 1264 1253 1242 425 423 401 42 2149 306 2043 2042 1476 2045 393 482 ] |
|
1.63 ms (0.07%) |
9 |
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.manufacturers_head_title_tag AS manufacturers_head_title_tag_6, t0.manufacturers_head_desc_tag AS manufacturers_head_desc_tag_7, t0.manufacturers_head_keywords_tag AS manufacturers_head_keywords_tag_8, t0.url_clicked AS url_clicked_9, t0.date_last_click AS date_last_click_10, t0.manufacturers_id AS manufacturers_id_11, t0.languages_id AS languages_id_12 FROM manufacturers_info t0 WHERE t0.manufacturers_id = ?
Parameters:
[
192
]
|
|
1.49 ms (0.07%) |
9 |
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
]
|
|
1.09 ms (0.05%) |
2 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 54 62 65 65 65 99 100 100 100 104 1079 1079 839 839 839 839 104 99 184 191 112 198 198 112 412 412 514 199 353 114 114 117 118 118 119 119 122 122 122 131 143 143 143 143 145 145 145 152 152 163 163 173 176 176 176 176 184 119 190 190 196 173 216 216 217 217 230 230 233 233 234 100 100 99 249 249 249 249 258 258 258 259 259 145 274 274 275 275 274 295 259 259 310 315 316 176 295 338 349 349 353 353 357 359 359 359 360 362 362 365 365 365 366 390 390 390 402 420 420 230 230 441 450 464 464 191 472 117 472 365 366 479 479 310 365 190 54 432 183 131 131 184 441 441 441 441 441 99 295 362 362 362 402 234 234 353 353 517 517 390 338 533 533 479 359 191 420 420 554 554 43 55 55 54 62 183 191 196 216 275 275 131 58 147 147 147 153 153 153 153 153 154 154 154 155 155 155 155 155 198 198 198 199 200 200 200 199 254 254 254 254 255 255 255 269 269 270 269 283 58 285 285 407 407 412 412 417 417 417 417 283 283 199 255 270 499 499 501 508 510 510 508 514 514 555 555 556 556 43 46 55 55 54 ] |
|
1.05 ms (0.05%) |
2 |
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:
[ 176 179 99 178 177 153 369 458 412 301 554 341 173 265 469 541 389 354 379 338 295 55 163 449 447 540 420 275 165 164 43 450 152 161 159 349 274 472 417 285 58 155 154 199 416 533 259 145 147 200 198 283 309 271 269 270 280 258 256 255 556 254 555 143 552 353 505 54 62 530 504 508 551 249 196 441 440 234 233 475 230 191 132 131 494 361 327 53 227 409 408 122 121 119 237 376 390 189 391 190 463 325 118 117 184 222 220 114 112 287 104 100 106 103 405 351 516 517 293 506 89 402 49 365 366 431 484 503 550 362 549 548 547 317 839 1079 499 286 539 498 46 218 217 216 310 514 509 360 316 315 357 510 464 359 477 479 312 183 432 65 425 423 401 42 501 306 407 393 482 ] |
|
0.65 ms (0.03%) |
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:
[
"629"
]
|
|
0.52 ms (0.02%) |
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:
[ 25911 25910 25909 25915 25914 25913 25912 25902 25900 25898 25896 25894 25892 25890 25996 25995 25994 25500 25499 25498 25901 ] |
|
0.37 ms (0.02%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.32 ms (0.01%) |
2 |
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:
[
"fr"
]
|
|
0.29 ms (0.01%) |
2 |
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:
[
20
]
|
|
0.29 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.redirect_url AS redirect_url_2, t0.target_path AS target_path_3, t0.target_url AS target_url_4, t0.redirect_product_id AS redirect_product_id_5, t0.redirect_category_id AS redirect_category_id_6, t0.target_product_id AS target_product_id_7, t0.target_category_id AS target_category_id_8 FROM redirections t0 WHERE t0.redirect_category_id = ? LIMIT 1
Parameters:
[
629
]
|
|
0.22 ms (0.01%) |
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:
[
1
]
|
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.