Query Metrics
104
Database Queries
18
Different statements
8653.79 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7391.53 ms (85.41%) |
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:
[ 1 1 445 628 630 629 1403 632 756 636 522 757 1743 1018 634 528 935 870 1742 523 ] |
|
1108.44 ms (12.81%) |
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 25485 25478 25471 25484 25477 25470 25483 25476 25469 25482 25475 25468 25481 25474 25467 25480 25473 25466 25781 25780 25779 25777 25776 25775 24970 24969 24968 24967 24947 24946 24945 24944 24943 24942 24941 25189 27050 27049 25176 25181 25178 25177 25182 27047 25183 25175 25180 27045 27044 5320 5289 21816 21813 21815 21812 21819 21818 21807 21804 21806 21803 21801 21797 21800 21796 21795 13594 13588 13591 13593 13587 13590 13566 13570 13569 13568 13944 13942 13946 13940 13938 13936 16636 16638 16641 16497 16496 16490 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 13934 13992 13989 14053 14062 14059 14050 14056 14065 16727 16726 13933 13931 13935 16589 16588 13991 14052 14061 14049 14055 14064 13956 13954 13958 13952 13950 13948 16626 16629 16633 14034 14031 14093 14102 14099 14090 14096 14105 27002 27001 27000 26999 26998 26997 26982 26981 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 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 26947 26945 25044 25043 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 26927 26925 26923 26922 21764 26921 21759 21763 26920 21758 26919 21762 26918 21757 26917 21761 26916 21756 26915 24679 24683 24694 24688 24678 24693 24686 13424 24680 13430 24682 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 25040 25038 25037 25035 25034 25032 25031 25029 25028 25026 25025 25024 25022 25021 25020 25018 25017 21531 21530 20536 20535 20534 20533 20526 20524 20523 20516 20514 20513 20531 20530 20529 20528 20519 20518 20510 20508 24695 24687 23448 24180 23456 23447 24179 23455 23446 24178 23454 23445 24177 23453 23444 24176 23452 23443 23459 23451 23442 23458 23450 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 26895 17209 26894 26893 24701 19046 23750 17220 23753 17214 23752 17208 23748 13401 23751 17218 23749 17212 19415 13400 19427 17219 19423 17207 19407 26892 19419 19045 19411 19414 17211 19426 17205 19422 19406 19418 19410 19413 19425 19421 19405 19417 19409 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 13894 13886 13890 13882 13893 534 13885 748 347 13889 635 13881 606 1103 13892 1024 13884 13888 13880 24881 17195 17189 17183 17188 17187 17192 17186 17180 17185 16739 16734 16729 16738 16692 16733 16728 26847 16581 16693 16578 16584 26845 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 24882 24879 24880 24878 25817 24877 24883 13878 13870 13874 13866 13877 13869 13873 13865 13876 13868 13872 13864 25846 22823 22818 22813 25845 22822 22817 22812 25844 4168 22821 4097 22816 22811 1116 25843 1111 22820 22815 22810 25833 6367 22808 6437 22803 6499 22798 25832 6491 22807 22802 22797 25831 22806 22801 22796 25830 22805 22800 26814 22795 26813 25828 22793 26812 22783 26811 22773 25201 25827 25198 22792 25194 25200 22782 25197 22772 25195 25826 25193 22791 26810 22781 26809 22771 26808 25825 26807 22790 26806 22780 26805 22770 26804 25823 22788 22778 22768 25822 22787 22777 22767 15286 25821 15285 22786 15284 22776 15283 22766 15282 25820 26798 22785 15281 22775 26797 22765 26796 24675 15280 24668 24664 24703 24671 24697 24669 24690 24696 24665 24672 26793 24691 24666 26792 24676 24673 26789 26788 26787 26786 26785 26784 26783 26782 16655 26781 16639 16642 26780 16654 16670 26779 16653 16669 13914 24650 26778 24649 13913 24648 26777 16646 16645 16658 26776 16644 16657 24651 13911 13908 13912 13909 26772 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 15525 24631 15518 15511 15524 24115 15517 15510 15523 24114 15516 15509 15522 24113 15515 15508 15521 24112 15514 15507 15520 24111 15513 15506 19028 19019 19027 26743 19031 26742 19026 26741 15999 15994 15989 15984 15061 15979 15060 15974 15058 15969 15056 15964 15055 15959 15054 15998 15053 15993 15052 15988 15050 15983 15048 15978 15973 15968 15963 15958 15997 15992 15987 15982 15977 15972 15967 15962 15957 15996 15991 15986 15981 15976 15971 15966 15961 15956 24607 24604 24606 24600 24603 24601 24605 24608 24602 16525 16524 16310 16307 16304 16299 16309 16303 16298 16306 16302 16301 16297 16295 16287 16282 16294 16290 16286 16281 16293 16289 26739 16651 26738 16650 26737 16630 16634 26736 16649 26735 16648 13916 13921 13917 26733 13918 13922 13923 23494 23493 23492 23468 23486 23477 23467 23485 23476 23466 23484 23475 23465 23483 23474 23464 23482 23473 23463 23481 23472 23462 23480 23471 23461 23479 23470 23149 23148 23147 23146 23144 23135 23126 23117 23143 23134 23125 23116 23142 23133 23124 23115 23141 23132 23123 23114 23140 23131 23122 23113 23139 23130 23121 23112 23138 23129 23120 23111 23137 23128 23119 23110 23572 23571 23570 23569 23568 16285 16280 16292 16284 16279 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 13754 13752 13749 13750 13751 13748 13755 13753 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 23564 23563 23562 23561 23560 23559 23558 23557 23556 23555 23554 23553 23552 23551 23550 23549 23548 23547 23546 23545 23544 23543 23542 23541 23539 23538 23537 23536 23535 23534 23533 23532 23531 23530 23529 23528 23527 23526 23525 23524 23523 23522 23521 23520 23519 23518 23517 23169 23168 23167 23166 23164 23157 23150 22751 23163 23156 20015 22750 23162 23155 20014 22749 23161 23154 22755 22748 23160 23153 22754 22747 23159 23152 22753 20024 15727 15732 15726 26729 26728 26727 26726 26725 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 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 13689 19116 13674 13662 13656 13668 13650 13695 13683 13688 19115 13673 13661 13655 13667 13649 13694 13682 13687 13678 16903 16907 16905 16902 16896 16899 16891 16895 16898 16890 16894 26724 26723 16901 16893 16888 26721 26720 26719 26718 26717 15700 15705 15704 15703 15702 15622 15628 15631 15616 15619 15625 15613 15621 15627 15630 15615 15618 15624 15612 15667 15685 15694 15649 15658 15676 15640 15666 15684 15693 15648 15657 15675 15639 15665 15683 15692 15647 15656 15674 15638 15664 15682 15691 15646 15655 15673 15637 15663 15681 15690 15645 15654 15672 15636 15662 15680 15689 15644 15653 15671 15635 15661 15679 15688 15643 15652 15670 15634 15660 15678 15687 15642 15651 15669 15633 15601 15607 15610 15595 15598 15604 15592 15600 15606 15609 15594 13672 13660 13654 13666 13648 13693 13681 13686 13677 13671 13659 13653 13665 13647 13692 13680 13685 13676 13670 13658 13652 13664 13646 13691 13679 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 25080 23824 26072 25074 25079 23823 26071 25073 25078 23822 26070 25072 25077 23821 26069 25071 25076 24589 24581 24585 24588 24580 24584 15597 15603 15591 15562 15580 15589 15544 15553 15571 15535 15561 15579 15588 15543 15552 15570 15534 15560 15578 15587 15542 15551 15569 15533 15559 15577 15586 15541 15550 15568 15532 15558 15576 15585 15540 15549 15567 15531 15557 15575 15584 15539 15548 15566 15530 15556 15574 15583 15538 15547 15565 15529 15555 15573 15582 15537 15546 15564 15528 13539 13544 13538 13543 13537 13542 13536 13541 23820 26068 25070 26108 25132 25135 23804 26107 25131 25134 23803 26105 25151 26066 25129 25159 23785 26104 25155 25158 23784 26103 25154 25156 23783 26102 25152 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 26082 25145 26088 25150 26087 25149 25142 24040 26086 25138 25141 24039 26085 25137 23786 26073 25992 13807 13805 13804 13800 13802 13803 13801 13808 13806 13816 13814 13813 13811 13810 13812 13809 13817 13815 13857 13847 23793 15888 15889 23792 15883 15887 23791 15882 15886 23790 15881 15885 23647 23646 23645 23644 23643 23642 23640 23639 23638 24888 22937 15952 15948 24887 22936 15951 15947 24886 22935 15950 15946 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 13799 13797 13796 13794 13793 13795 13792 13791 13798 25092 23830 26665 25086 25091 23829 26664 25085 25090 23828 26663 25084 25089 23827 26662 25083 25088 23826 26661 25082 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 25068 23787 25067 8448 14968 14966 14962 20566 20565 20564 14961 20563 14960 20562 14959 14958 17130 17127 17124 17098 17078 17129 17126 17123 17077 16985 16976 17032 17008 17056 16984 17012 17060 16989 17000 17048 16975 16970 16960 17154 17031 17007 17055 16983 17035 17011 17059 16988 17023 16999 17047 16974 16969 16959 16946 17030 17006 17054 16982 16947 17010 17058 16987 16945 17049 16953 16944 16998 17046 16973 16968 17137 17136 17133 17162 17158 16963 17149 17155 26616 17132 16954 17144 17152 26614 17110 17101 17081 17072 17100 17080 17071 17163 17148 17147 17146 16962 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 9787 9830 9505 9829 9912 9521 9518 9536 9535 9720 9738 9532 9722 9737 9761 9810 9527 9526 9718 9735 9523 8978 8975 9015 8687 8568 9014 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 24175 24159 15478 24174 15473 24158 15477 24173 15472 24157 15476 24172 15471 24156 15475 24171 15470 24155 15452 15449 15446 17920 17908 17919 17907 17918 17906 17917 17905 17916 17904 17901 17895 17900 17894 17899 17893 17898 17892 17897 17891 24806 24802 24805 24801 1036 1094 1058 1022 1004 26438 26437 26436 26435 26434 16182 16178 16174 16170 16181 16177 16173 16169 16180 16176 16172 16168 16166 16161 16156 16151 16165 16160 16155 16150 16164 16159 16154 16149 16163 16158 16153 16148 16146 16141 16136 16131 16145 16140 16135 16130 16144 16139 16134 16129 16143 16138 16133 16128 26424 26423 26405 26404 26403 26402 26401 25207 25204 25213 25210 25206 25203 25212 25209 26380 26378 26377 26376 26375 26374 26373 26372 26371 26370 26369 26368 26367 26366 26365 26359 26358 26357 26355 26354 26353 26352 26351 26350 26346 26343 26342 836 850 26337 26336 26325 26324 26323 25187 25191 25186 25185 "precise_color" "product_size" ] |
|
114.43 ms (1.32%) |
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:
[ 445 628 630 629 1403 632 756 636 522 757 1743 1018 634 528 935 870 1742 523 ] |
|
8.38 ms (0.10%) |
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:
[
25905
]
|
|
7.48 ms (0.09%) |
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:03:39" "2026-10-27 15:03:39" "percent-soleil" ] |
|
6.41 ms (0.07%) |
2 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 709 708 1544 179 1453 1543 178 177 1542 1541 1616 1540 1539 1538 1537 1536 1535 1824 1823 1822 704 703 369 368 367 2062 2061 2060 2040 2037 2035 2034 2067 458 2068 2071 1478 2111 2066 2039 1474 2044 1090 1952 1951 301 1728 1727 1454 1857 1856 298 537 543 341 1534 265 1552 340 1533 264 1585 1584 2058 2108 469 541 389 468 467 354 379 519 1888 378 1886 2015 324 1933 1932 1931 1930 1929 1928 1927 1851 1850 1848 1943 1855 1973 210 1984 2057 1926 170 1854 44 2024 2151 1942 1853 534 2159 209 1983 2022 1967 168 1852 461 1711 1620 2313 1532 2036 1471 2032 1720 1462 1897 449 1677 1662 1661 1847 1846 1845 1844 2005 2004 2003 2002 2001 2000 1999 447 540 1650 1578 1577 2302 1621 1531 1649 165 164 2224 446 1660 1861 1530 1529 1821 161 159 1843 1842 1841 419 454 418 208 2129 1941 1940 1924 1923 1922 1921 1840 1839 1837 1623 1579 1668 2052 1576 2050 1622 2049 1666 2048 1575 2011 466 1945 2010 1944 1966 2009 1965 1964 1755 1834 1833 1832 1831 1830 1829 1828 1827 1826 1825 1482 1820 1819 1818 416 415 414 1963 1962 1961 1719 1718 289 1587 1586 1573 1572 2109 2107 2106 2027 2026 2028 1947 1817 1816 1815 1814 1813 1812 1811 1574 1810 1809 1808 1878 1872 1526 1870 2105 1525 1869 1867 1524 1460 2104 1998 1459 2102 1807 1866 1806 1865 1864 1960 1805 309 1804 271 347 1939 1938 2144 1937 1936 2033 280 1959 1958 1957 1956 2128 1571 1570 1955 1569 256 1919 2134 2175 1918 1917 2174 1916 2173 1914 1913 2172 1912 1523 1522 1521 1520 1803 2101 1802 2025 2099 2038 1477 552 1801 2085 1800 1625 1490 1707 1624 1706 253 505 538 1754 1731 1753 1752 1741 1730 1974 1729 460 2164 1726 1740 2163 1725 1732 1678 1152 2324 1693 1692 1659 1658 1657 1231 1735 1220 1734 1209 1198 1187 1176 1165 1733 1157 1588 530 528 527 526 525 524 1799 2098 1798 1797 2097 1796 374 2077 101 504 1910 1909 1908 2152 2155 551 1907 1568 2013 2007 1567 2006 1566 1565 1549 1906 1738 2083 1905 2082 2076 1903 1989 1902 1988 1901 251 1982 1900 1981 1691 1899 1690 2133 2132 2131 1898 2130 2084 1877 45 2141 1876 1452 1875 1750 1749 1863 1996 1656 2140 440 1689 1688 1687 2135 2138 1862 2150 2096 1795 1794 1793 496 1792 1791 1979 1859 1997 2093 135 1950 1790 523 495 1789 1788 1978 1976 1106 1105 1107 545 1583 1705 1704 1561 180 2166 2165 2168 2161 411 2162 2145 1986 2012 1949 1948 1985 536 531 2075 2167 2137 2023 1787 1891 1472 1560 1559 1896 1786 1895 1894 1892 1473 1890 1785 1784 1783 475 1558 1557 1655 1654 1889 1887 1737 1457 1699 1724 132 1665 1519 494 1743 1683 1682 361 1465 1639 1638 1637 1636 1635 1634 1633 327 1487 1615 1614 1613 1612 1611 1610 1609 53 1885 1884 2074 1883 227 226 224 409 408 1518 1517 1516 121 120 1515 1514 237 223 376 1646 189 391 1710 1675 463 1645 1548 1644 1547 375 386 188 187 380 462 507 385 2291 2281 2270 2260 2249 2238 325 1608 1607 1606 1605 1604 1603 1686 1653 1513 1667 1512 1511 1546 1782 1781 1780 212 1880 203 197 1779 1879 2073 1484 1778 1461 1873 2160 1483 1777 1776 1775 215 1685 1456 1954 1858 1953 1874 1881 1545 1975 1455 222 221 220 1652 1684 1651 1746 1745 1744 1510 1509 1508 1507 1506 1497 1491 1486 1485 1480 1469 1458 1774 1773 287 1442 219 1564 2308 2307 2305 2304 1417 1408 1397 1386 1378 1375 1364 1357 321 1468 2056 2055 2054 370 320 1582 1581 1580 1768 1767 1766 1765 1764 1346 1562 1291 1280 1563 1269 1751 106 1335 707 706 103 1324 1313 1302 404 405 351 516 1708 1709 293 1934 1920 1911 506 502 1698 383 515 403 89 1648 1703 49 1463 1987 433 2047 2046 1489 1674 2170 2053 1488 1641 345 339 304 2171 2127 1640 2169 2086 2126 1670 1643 1669 1642 308 318 305 431 484 503 550 429 371 372 1702 1632 549 1701 548 1700 547 1631 299 317 1366 1358 1356 1365 1355 1354 2146 2148 286 483 539 498 2021 2020 2230 2064 2090 218 2091 2089 2088 1556 1555 2063 1980 2065 1470 1554 1553 1739 214 1673 1589 2157 509 2156 1479 1630 1602 1601 1626 2154 2153 1467 2041 2031 2029 544 1664 1663 1629 1628 1627 1723 478 477 1672 1671 1722 1647 1600 1599 1598 1597 38 36 35 1596 1595 1681 1594 1593 1370 711 1592 1591 1590 1697 312 1384 1383 1382 1381 1380 1390 1389 1388 1387 1385 2268 2267 1680 1736 1679 1747 1696 546 350 1264 1253 1242 1763 1762 1761 1760 1759 1758 1757 1756 425 424 423 186 1091 401 42 41 497 1695 1694 2149 1481 2087 1464 2018 2014 2100 2095 2094 306 2115 2112 2116 2113 2043 485 2042 1476 2045 393 476 482 2110 481 2072 2069 1369 1368 ] |
|
5.50 ms (0.06%) |
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:
[ 25905 "2026-10-27 15:03:39" "2026-10-27 15:03:39" ] |
|
3.60 ms (0.04%) |
2 |
SELECT id, parent_id FROM products_models WHERE id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 39 39 43 43 46 48 48 48 51 52 52 52 52 52 52 54 54 54 54 55 55 55 55 56 56 56 56 57 57 57 57 58 58 59 59 59 59 59 60 60 60 60 60 62 62 63 63 63 63 64 64 64 64 65 65 65 98 98 98 98 98 99 99 99 99 100 100 100 100 100 102 102 102 104 104 107 107 107 107 107 107 107 107 111 111 111 111 111 112 112 113 113 113 113 113 113 113 113 114 114 115 115 115 115 115 117 117 118 118 119 119 119 122 122 122 131 131 131 131 133 133 133 133 133 134 134 134 136 136 136 137 137 139 139 139 140 140 140 140 141 141 141 141 142 142 142 143 143 143 143 144 144 144 144 145 145 145 145 147 147 147 148 148 148 148 148 148 148 150 150 151 151 152 152 153 153 153 153 153 154 154 154 155 155 155 155 155 157 157 157 158 158 158 162 162 162 162 162 162 162 163 163 167 167 169 169 169 172 172 172 173 173 175 175 175 175 175 175 176 176 176 176 176 181 181 181 183 183 184 184 184 185 185 185 185 185 190 190 190 191 191 191 191 192 192 192 194 194 194 195 195 195 195 196 196 198 198 198 198 198 199 199 199 199 200 200 200 202 202 202 202 206 206 207 207 207 213 213 213 213 216 216 216 217 217 228 228 228 228 229 229 229 229 229 230 230 230 230 231 231 231 231 231 232 232 232 233 233 234 234 234 235 235 247 247 247 247 248 248 248 248 249 249 249 249 250 250 250 250 252 252 252 254 254 254 254 255 255 255 255 258 258 258 259 259 259 259 260 260 260 260 262 262 262 262 263 263 263 263 263 263 263 269 269 269 270 270 272 272 272 273 273 273 274 274 274 275 275 275 275 276 276 276 276 277 277 277 278 278 281 281 281 282 282 282 282 283 283 283 284 284 284 285 285 288 288 292 292 294 294 294 295 295 295 296 296 296 302 303 303 310 310 313 313 313 313 313 313 313 313 313 314 314 314 314 314 315 316 319 319 323 323 323 323 323 323 323 326 326 326 326 326 326 326 326 330 330 336 337 337 337 337 337 337 337 338 338 346 346 346 348 348 348 349 349 353 353 353 353 353 355 355 355 357 358 359 359 359 359 360 362 362 362 362 362 364 364 364 364 364 364 364 364 365 365 365 365 365 366 366 377 377 381 381 382 382 382 387 387 387 388 388 388 390 390 390 390 392 392 392 392 394 394 394 394 396 396 396 396 396 396 396 402 402 407 407 412 412 412 412 413 413 413 413 413 417 417 417 417 420 420 420 420 421 421 421 421 422 422 427 427 427 428 428 430 430 432 434 434 434 434 434 435 435 435 436 436 436 436 436 438 438 441 441 441 441 441 441 442 442 443 443 444 444 444 450 452 452 452 452 453 453 453 453 453 455 455 456 456 457 457 464 464 465 465 471 471 471 472 472 473 473 473 474 474 479 479 479 486 486 487 487 493 493 493 499 499 501 508 508 510 510 514 514 514 517 517 520 520 529 529 533 533 535 535 535 554 554 555 555 556 556 699 699 701 839 839 839 839 990 990 990 990 990 1017 1017 1018 1018 1018 1018 1018 1029 1029 1030 1030 1079 1079 ] |
|
2.74 ms (0.03%) |
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:
[ 709 708 176 179 99 178 177 175 153 704 703 369 368 367 396 435 458 434 394 412 1090 278 301 554 181 298 537 543 341 173 265 340 172 264 422 474 469 541 389 468 467 354 379 519 229 378 358 324 263 162 56 169 262 210 170 44 381 296 57 167 534 288 209 168 461 338 295 55 163 457 235 449 456 337 447 540 420 275 165 164 43 446 450 194 152 151 161 159 158 419 454 418 208 272 260 157 349 274 472 417 348 466 273 285 58 155 154 199 150 416 415 414 284 533 289 259 473 388 148 145 147 200 198 283 336 144 309 271 347 269 270 281 280 282 258 256 255 556 254 555 143 142 141 387 552 353 253 505 538 460 54 444 443 62 60 59 530 528 527 526 525 524 140 139 374 101 504 250 508 551 249 346 196 248 452 442 330 247 251 303 441 453 195 45 207 48 440 137 136 496 192 135 134 523 495 292 1106 1105 1107 545 234 180 529 520 411 277 276 536 531 382 133 231 233 232 475 230 191 132 131 494 361 364 327 326 53 228 227 226 224 409 408 122 121 120 119 237 223 376 390 189 391 190 463 375 386 188 187 380 462 507 385 52 325 323 438 118 117 115 212 213 203 197 202 111 215 184 185 206 222 221 220 436 114 113 112 287 104 219 1030 1029 107 321 421 370 320 294 98 100 51 106 707 706 103 102 404 405 351 516 517 293 252 506 502 383 515 403 89 402 49 319 433 413 365 535 493 345 339 304 366 308 318 305 431 484 503 550 429 371 372 362 549 548 547 299 317 839 1079 499 286 483 539 498 377 46 465 218 427 217 302 428 216 214 310 514 509 360 316 315 357 510 392 544 464 359 478 477 479 314 38 36 35 313 701 711 312 1018 990 1017 183 432 430 546 350 65 64 63 425 424 423 186 1091 401 42 41 497 39 501 455 355 471 306 486 487 407 485 393 476 482 481 699 ] |
|
2.52 ms (0.03%) |
18 |
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:
[
445
]
|
|
0.47 ms (0.01%) |
2 |
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:
[
445
]
|
|
0.45 ms (0.01%) |
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:
[ 25905 25908 25911 25910 25909 25915 25914 25913 25912 25902 25900 25898 25896 25894 25892 25890 25996 25995 25994 25500 25499 ] |
|
0.41 ms (0.00%) |
2 |
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:
[
"445"
]
|
|
0.39 ms (0.00%) |
2 |
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.36 ms (0.00%) |
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.26 ms (0.00%) |
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:
[
445
]
|
|
0.25 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0
Parameters:
[] |
|
0.16 ms (0.00%) |
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
]
|
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.