Query Metrics
526
Database Queries
23
Different statements
272.08 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
77.43 ms (28.46%) |
1 |
SELECT c0_.id AS id_0, c0_.value AS value_1, c1_.id AS id_2, c1_.list_order AS list_order_3, c1_.is_display_site AS is_display_site_4, c1_.is_search_site AS is_search_site_5, c1_.label AS label_6, c0_.product_id AS product_id_7, c0_.characteristic_label_id AS characteristic_label_id_8 FROM characteristic c0_ INNER JOIN characteristic_label c1_ ON c0_.characteristic_label_id = c1_.id WHERE c0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.is_display_site = ?
Parameters:
[ 519 835 6164 29209 70691 70692 70693 72061 72062 72063 72064 72065 72066 72067 72068 72069 72070 72071 72072 72073 78763 78764 78765 78766 87502 87503 87504 87505 87506 87507 87508 94104 95665 125878 129244 129245 129247 145254 145257 157415 179783 209416 222149 222150 222151 222152 222157 222158 222159 222160 222601 239241 243646 245455 245456 245457 245458 245459 249031 249610 249613 250903 257018 257025 257026 289767 404703 404768 404769 404770 404771 404845 535 536 537 539 977 978 979 981 982 983 9317 9338 9339 9341 9510 10198 10199 10200 10201 10202 10203 29371 29372 29373 29374 29387 29388 29389 29390 29391 29392 29393 29394 29395 29426 29427 29428 31256 33389 55075 55077 55078 60187 60275 60276 60278 60280 67909 77076 77080 77085 78757 93743 94432 95844 96533 96534 96742 96743 96745 96746 96747 96752 96754 96756 99595 99596 99603 179060 179061 179062 179063 179064 179065 179066 179067 179068 179069 179070 179071 179072 179073 179074 179075 182252 182270 183057 183058 183059 183060 183061 183062 183063 183064 183065 183066 183067 183068 196510 196511 196512 196513 198443 198444 216707 241182 248478 251130 251136 251140 256044 285463 285464 287150 291076 291083 291086 291121 303565 303568 303569 303570 303571 303572 303573 303574 315564 319146 319151 319153 319463 329078 330388 335327 349001 349002 349027 404267 404369 404401 404426 404547 404576 404577 404578 404579 404580 404581 404582 404583 404584 404585 404586 404593 404760 404956 404966 404975 413345 413382 417690 417694 417713 468607 519619 526 954 955 956 957 963 972 973 974 975 976 1109 5163 5280 5895 5896 5897 5898 5899 5906 5907 5908 5909 5910 5911 5912 5914 5915 5942 5943 5944 5945 5946 5947 5948 5950 5951 6220 6226 6583 7363 7364 7365 8818 8951 8952 8953 9049 9126 9127 9128 9129 9626 9682 9684 9685 9686 9748 10448 11035 11036 11037 11038 11039 11040 26178 26180 26181 26182 26183 26534 26535 27556 28627 28628 28629 29123 29289 29503 31220 33403 53430 54894 54895 59401 63537 63538 64456 67907 70581 70582 70584 70585 70586 70587 70589 70853 70854 70855 70856 70857 70858 70859 70860 71050 71055 72152 72154 72155 72157 72158 72160 72161 72162 72163 72164 72166 72167 72168 72169 72170 72172 72173 72174 72175 72184 72186 72187 72188 72189 72191 72192 72193 72194 72195 73067 73068 73069 73070 73071 73073 73074 73075 73077 78755 79553 79554 79555 79556 79557 79681 80575 80747 84522 84682 85274 85278 85280 85282 85283 85340 92281 92282 92283 92284 93617 93618 93619 93620 93622 93623 93626 93658 93668 93673 93674 93675 93677 93679 93680 93681 93682 93683 93684 93696 93704 93705 93706 93707 93708 93709 93710 93711 93712 93713 93714 94102 94103 94428 94431 96738 96741 96750 97014 101433 101434 101435 101438 101439 101440 101441 101465 101467 123506 123966 123967 131616 136007 143465 145562 146071 163220 163221 164075 164076 164077 164511 168051 170330 170332 170333 170530 170531 170532 170533 172607 177512 183139 184871 185183 185185 185186 196496 196497 196498 196499 196500 198572 203678 205751 205752 205753 205754 205755 215157 215158 215159 215160 215161 215162 215163 215164 215165 215166 215167 215168 215169 215170 215171 215174 215175 215177 215179 216697 216698 216699 216700 216705 216706 219102 219103 219104 219105 219106 219107 219108 239279 240668 240669 240757 240764 240766 240767 240768 240769 240770 240772 240773 240774 240837 240838 242889 242890 242891 242892 243616 243617 246871 248439 248497 259691 259692 259696 259697 259699 259720 260039 260085 260086 261301 282869 285244 285465 285466 285686 296390 303535 314072 315547 315549 315550 315551 315554 315558 330387 338104 339579 339622 339623 339624 339625 339626 346963 403576 403577 403578 403851 404256 404276 404308 404374 404411 404569 404572 404573 404574 404591 404641 404702 404906 404927 413360 417715 417717 417718 417719 417720 417906 417907 418443 418444 420086 469450 469477 469484 513883 519617 519621 519622 519633 519634 664 667 668 1868 1869 1871 1872 1877 1878 1879 1880 1881 1904 1905 1906 1907 1909 1910 4592 30810 53469 63544 63751 70911 76058 76280 76281 76282 94714 113550 157290 194822 194823 194845 247263 340932 403749 403754 403785 403786 403787 403864 404362 404383 990 991 1003 1032 1036 1037 1038 1039 1040 1041 1042 1052 1053 1058 1059 1073 1074 1075 1076 1172 1173 1174 1179 1187 1189 1190 1746 1747 1748 1818 1819 1820 1821 1823 1824 1825 1826 1827 1828 1833 1834 1838 1839 1995 3223 3977 4418 4906 4907 5482 5483 5997 5998 6199 6200 6208 6564 7459 8958 8959 8983 8984 9450 9501 9502 9857 9858 9859 9860 9861 9862 9863 9864 9865 28307 28308 28309 29008 29009 29010 29011 29189 30739 31240 31255 33387 33388 53401 53428 56596 56597 56598 56599 56997 56998 58840 59365 63398 63552 63553 63554 63555 63664 63665 63666 63667 63668 63669 63670 63671 63672 63673 63674 63675 63676 63677 63678 63679 63680 63681 63682 63683 63684 63685 63686 63687 63688 63689 63690 63691 63692 63693 63694 63695 63696 64139 64599 65480 65484 70317 70578 70579 70849 70850 70874 70875 70876 70877 70878 73107 73111 78370 78371 78738 78744 78745 78746 78747 78927 79560 79565 79567 79568 80744 80745 81113 81114 81115 81116 81117 85306 85307 85346 88521 93703 93733 93734 93735 93736 93737 93738 93739 93740 93741 93742 96775 96776 96779 96780 96781 96782 96783 101064 101444 101453 101454 101472 101473 101474 101482 101483 110251 110252 122480 123505 123991 123992 123993 123994 124012 129233 129234 129235 129236 129237 130863 136833 136834 136835 145563 147954 147958 147959 147974 162603 162604 162605 162606 162607 162608 162609 162610 162611 162612 162699 162700 163219 163600 163602 163603 164095 164096 164097 164098 164099 170328 170329 170347 170348 170349 170534 170535 170536 170537 170538 170539 170540 170541 170542 170543 170544 170545 171834 175034 182676 185663 185664 187459 191782 196508 196509 196540 196541 204734 204735 205549 215181 215182 215183 216703 216704 221583 224144 224570 240610 240615 240833 241258 241259 241260 241261 241262 241263 241264 243643 248483 248498 256825 256847 256959 257386 259683 259689 259690 259700 259701 260072 260073 268440 268906 285467 285468 291443 291444 291445 291446 291449 293850 303551 303582 305412 305413 305414 314070 314071 315502 315548 315553 330389 330396 334525 334598 338103 339612 339613 339614 339615 339616 339617 339618 339619 339620 339621 341031 341032 348524 348526 403774 403788 403961 403962 404396 404410 404467 404535 404542 404716 404717 404757 404758 404759 404815 404880 404882 404897 404947 410979 410980 416697 416698 416700 416702 417916 425381 425382 425383 425384 425561 425562 425563 425564 432150 432160 432161 435185 469220 469486 476858 476859 519609 519610 519611 519618 519635 519636 523739 523740 523741 555281 558459 558461 558466 2860 2861 2862 2863 2864 2865 2866 4216 5535 5539 5540 5541 5542 5543 5544 5545 5546 5547 5548 5549 5550 9610 9611 9612 29300 31628 53429 65422 65424 66003 69897 69898 72118 72119 72120 72121 72122 72123 72128 72131 72132 72133 72134 72135 78302 91271 96151 96154 96157 96158 125314 125315 125316 125317 125318 142526 142527 240771 248427 248430 248506 256885 289073 289074 403727 403940 404381 404974 417693 519648 2786 2788 3023 3032 3033 3037 3038 3042 3043 3047 3048 3050 3053 3744 3745 3746 3747 3748 3749 3750 3751 3752 3753 3754 3755 3756 3757 4376 5707 5712 5713 5714 5715 5821 5829 5831 5832 5834 5992 6482 6483 6827 6828 6829 8235 8237 8240 8242 9030 9032 9033 9034 9035 9201 9203 9239 9651 9835 10401 10404 25637 25851 25852 25854 25855 25856 25857 25860 25861 25863 25968 25969 25971 25972 25973 25975 25976 25977 28622 28624 28689 28691 28692 28693 28694 28695 28696 28697 28698 28699 28700 28701 28702 29215 29278 29279 29280 29434 29435 29436 29437 29438 29439 29930 29931 30789 30790 30791 30792 30793 30794 30799 31669 33390 33404 53364 54544 55013 55023 55238 56040 59346 59347 59348 59349 59351 59352 59353 60002 61651 61652 63545 64157 64159 64160 64161 69391 69392 69393 69394 69395 69396 69679 69680 69681 70012 70015 70018 70019 70020 70021 70022 70706 70707 70879 70881 70887 70888 70889 70891 70893 70894 70895 70899 70900 70901 72393 72562 78749 78751 78753 79401 80391 80392 80393 80394 80395 80396 80399 80400 80406 80407 80408 80409 80410 80424 85316 85317 85318 85319 85320 85321 85322 85323 85324 85325 85342 85343 85344 87514 87515 93631 93643 93726 96760 96761 96762 96763 96764 96765 96766 96771 97221 101460 101463 106148 106364 106365 122421 122422 122960 128553 130905 132033 133882 143988 143990 148554 148556 148557 149250 163610 163611 163615 163617 163930 163931 163932 163933 163934 163961 165467 165468 165469 165470 165471 165472 182994 183762 193377 195406 195815 198618 199217 199218 199219 199322 199323 201528 203437 216709 216710 221517 221518 221519 221520 221521 221522 221523 221524 221525 221526 239639 239640 240309 240312 241238 241239 241240 241241 241242 241243 241244 241245 241246 241247 241248 241249 241250 241251 241252 241253 241254 241255 241256 241257 241774 241775 242397 242398 243585 243586 243588 244244 244245 244246 244247 244248 244249 249032 256772 256838 256839 256886 256917 256988 256989 257003 257004 257005 257006 257007 257008 257009 257014 257015 257016 257017 257019 257020 257021 257022 257023 257024 257032 257033 257034 257037 257069 257071 259681 260103 260104 260105 261751 261774 267739 267740 267741 267743 267744 267752 267753 267754 267755 267756 267757 267758 267759 285245 285246 285458 285459 285460 289049 289050 289051 289052 302401 308990 312052 314069 317662 317663 325314 325315 328132 335297 335298 336077 339571 339583 339597 339598 339599 339600 339601 339602 339603 339604 339605 339606 339607 339608 339609 339610 339611 341490 341494 345099 346297 353988 403605 403606 403608 403609 403610 403611 403652 403653 403654 403655 403656 403657 403658 403665 403675 403702 403710 403745 403765 403770 403772 403807 403808 403812 403866 404304 404305 404306 404417 404423 404604 404605 404606 404607 404640 404783 404785 404786 404819 404828 404829 404834 404873 404874 404881 404883 404904 404907 404911 404912 404998 404999 405000 405429 405430 405431 406560 411994 411996 411997 411998 411999 412000 413346 413354 413355 413356 413357 413358 413359 413696 465893 465894 469476 469488 469489 469491 469492 504312 508236 519637 519638 519639 2451 3619 3632 3633 28363 28367 28369 28371 28375 28672 28673 28674 54574 55184 55185 55186 55187 70006 70007 70008 70591 77382 78404 78733 78736 79533 84916 85284 85336 85338 85672 86478 92279 92280 93642 106717 106718 106719 106721 142519 200149 200150 225539 243608 243609 243612 243613 248434 248435 248496 256773 256780 256781 256782 259682 259717 259718 264341 282061 282064 285471 285472 287096 293486 314060 314061 314172 314173 330397 330399 402472 403569 403570 403758 403863 404321 404521 404648 404751 411849 417915 417917 418442 469497 469498 503727 519620 558462 558465 1 ] |
23.81 ms (8.75%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[ 4 46 222 223 224 225 47 226 227 228 229 48 230 231 232 233 234 49 235 236 237 50 238 239 240 241 51 242 243 244 52 245 246 247 248 53 249 250 251 252 ] |
21.46 ms (7.89%) |
60 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 72174 ] |
19.52 ms (7.17%) |
91 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"TarifDefautBtoB"
]
|
18.36 ms (6.75%) |
30 |
SELECT d0_.id AS id_0, d0_.quantity AS quantity_1, d0_.price_ht AS price_ht_2, d0_.price_ttc AS price_ttc_3, d0_.product_id AS product_id_4, d0_.product_price_id AS product_price_id_5, d0_.promotion_id AS promotion_id_6, d0_.market_id AS market_id_7 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.quantity <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[ 72174 0 ] |
17.36 ms (6.38%) |
30 |
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
72174
]
|
13.98 ms (5.14%) |
14 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 72174 7 ] |
13.54 ms (4.98%) |
60 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
11.77 ms (4.33%) |
1 |
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1
Parameters:
[ 4 46 222 223 224 225 47 226 227 228 229 48 230 231 232 233 234 49 235 236 237 50 238 239 240 241 51 242 243 244 52 245 246 247 248 53 249 250 251 252 ] |
9.59 ms (3.53%) |
61 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
9.42 ms (3.46%) |
30 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.price_id AS price_id_4, t0.product_id AS product_id_5 FROM product_price t0 WHERE t0.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 72174 "C" ] |
8.57 ms (3.15%) |
28 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 72174 9963039 ] |
7.77 ms (2.86%) |
49 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
222
]
|
7.71 ms (2.83%) |
30 |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-07-18 12:32:15" "%2%" 72174 ] |
5.69 ms (2.09%) |
30 |
SELECT t0.id AS id_1, t0.price_ht AS price_ht_2, t0.price_ttc AS price_ttc_3, t0.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
72174
]
|
1.76 ms (0.65%) |
1 |
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 30 OFFSET 360
Parameters:
[ 4 46 222 223 224 225 47 226 227 228 229 48 230 231 232 233 234 49 235 236 237 50 238 239 240 241 51 242 243 244 52 245 246 247 248 53 249 250 251 252 ] |
1.26 ms (0.46%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 4 46 222 223 224 225 47 226 227 228 229 48 230 231 232 233 234 49 235 236 237 50 238 239 240 241 51 242 243 244 52 245 246 247 248 53 249 250 251 252 72174 72175 72184 72186 72187 72188 72189 72191 72192 72193 72194 72195 73067 73068 73069 73070 73071 73073 73074 73075 73077 78755 79553 79554 79555 79556 79557 79681 80575 80747 ] |
0.79 ms (0.29%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25, p1_.id AS id_26, p1_.price_ht AS price_ht_27, p1_.price_ttc AS price_ttc_28, p2_.id AS id_29, c3_.id AS id_30, c3_.name AS name_31, c3_.displayed_order AS displayed_order_32, c3_.is_in_footer AS is_in_footer_33, c3_.slug AS slug_34, p4_.id AS id_35, p4_.price_ht AS price_ht_36, p4_.price_ttc AS price_ttc_37, p4_.discount AS discount_38, p5_.id AS id_39, p5_.min AS min_40, p5_.max AS max_41, p5_.codelot AS codelot_42, c6_.id AS id_43, c6_.name AS name_44, c6_.name_display AS name_display_45, c6_.is_visible_btob AS is_visible_btob_46, c6_.is_referencement AS is_referencement_47, p1_.price_id AS price_id_48, p1_.product_id AS product_id_49, c3_.category_parent_id AS category_parent_id_50, p4_.product_id AS product_id_51, p5_.customer_catalog_id AS customer_catalog_id_52, p5_.product_id AS product_id_53 FROM product p0_ LEFT JOIN product_price p1_ ON p0_.id = p1_.product_id LEFT JOIN price p2_ ON p1_.price_id = p2_.id LEFT JOIN product_category p7_ ON p0_.id = p7_.product_id LEFT JOIN category c3_ ON c3_.id = p7_.category_id LEFT JOIN promotion p4_ ON p0_.id = p4_.product_id LEFT JOIN product_catalog p5_ ON p0_.id = p5_.product_id LEFT JOIN customer_catalog c6_ ON p5_.customer_catalog_id = c6_.id WHERE p0_.slug = ? AND p0_.is_active = 1
Parameters:
[
"classement-archivage"
]
|
0.73 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
0.54 ms (0.20%) |
2 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
80575
]
|
0.37 ms (0.14%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.slug = ?
Parameters:
[
"classement-archivage"
]
|
0.36 ms (0.13%) |
2 |
SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ?
Parameters:
[
199448
]
|
0.29 ms (0.11%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.manufacturer AS manufacturer_3, t0.short_label AS short_label_4, t0.long_label AS long_label_5, t0.weight AS weight_6, t0.sold_by AS sold_by_7, t0.ppht AS ppht_8, t0.ppttc AS ppttc_9, t0.paht AS paht_10, t0.pattc AS pattc_11, t0.legal_discount_library AS legal_discount_library_12, t0.fidelity_bonus AS fidelity_bonus_13, t0.brand AS brand_14, t0.time_limit AS time_limit_15, t0.coef AS coef_16, t0.is_discountable AS is_discountable_17, t0.is_btob AS is_btob_18, t0.is_btoc AS is_btoc_19, t0.is_customizable AS is_customizable_20, t0.is_library AS is_library_21, t0.is_nathan AS is_nathan_22, t0.is_green AS is_green_23, t0.is_orapi_grand_frais AS is_orapi_grand_frais_24, t0.is_active AS is_active_25, t0.slug AS slug_26 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"classement-archivage"
]
|
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.