Query Metrics
275
Database Queries
24
Different statements
187.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
71.51 ms (38.19%) |
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:
[ 540 1281 1377 1378 1379 1380 1381 1382 1383 1384 1396 1715 1716 1991 2847 2848 2849 2850 2851 2922 3544 3545 3546 3547 3550 3763 3764 4633 4634 4635 4706 5037 5470 5866 8774 9082 11300 11301 21896 26356 26401 26794 26795 26796 28735 28736 28737 28738 29220 29221 29222 32157 55731 55732 56059 56078 56079 56080 56389 56419 56420 57479 59395 59892 60903 64611 64612 72225 72497 72499 72503 78778 79691 80052 87426 87903 96013 96034 96035 99072 105673 106187 106645 106646 109176 109667 109683 110273 110321 110322 131276 160195 165529 165535 166730 169404 175459 182187 182189 182196 183044 183045 183542 183753 195261 198573 198595 217667 217670 218539 224175 224176 224177 224178 224179 224180 224181 224182 224183 240779 240780 245380 246075 246269 248998 249007 256764 256766 257065 259234 259235 260975 261775 262767 264293 265362 289018 289019 289020 289021 290148 290149 301577 301644 312646 315533 317023 321201 335332 336066 336067 336068 337470 340278 341477 346939 348718 348719 400654 403690 403711 403728 403839 403843 404287 404288 404290 404294 404326 404350 404386 404400 404592 404827 409198 409199 410981 435142 498787 508242 511187 512644 524322 524383 525010 526982 548497 548498 575217 3278 3279 5270 7309 10209 29117 59738 64973 69738 80046 80125 85009 88529 109115 109192 109195 121423 145681 164052 164053 164054 175427 175431 175432 175439 175442 175443 184103 187174 187175 193882 196156 199335 200162 200165 201126 201127 201128 201129 201130 201131 201132 201133 201134 201135 201136 201138 201139 201149 201411 201525 201638 202455 216093 216531 216536 217352 217353 217359 220114 220115 220163 222189 223057 239707 239725 239726 242447 242451 242452 242453 242992 243316 243600 243602 243603 243604 243605 243663 252608 252610 252611 255379 259186 259187 259191 259195 259196 259198 259199 259200 259201 262749 262750 264080 285999 286000 286001 286002 286003 286006 286007 286014 286015 286745 287151 289736 289765 290839 291148 291206 291208 291830 291832 291836 291853 291854 291855 293223 311709 312645 312670 312671 312672 312674 312676 312677 312678 312759 312760 313534 316289 316323 316324 316345 316361 316370 316371 316372 316829 316830 316831 316832 316833 316834 316838 316839 316840 316841 316842 316846 316848 316850 317611 318651 318669 318671 318675 318680 318687 318691 318708 319447 319452 319455 319458 319459 319464 319470 319475 319477 319478 319479 319480 319488 319494 319514 320278 321422 324264 324269 324270 324271 324272 324274 324275 324276 324277 324278 324279 324281 324282 324283 324288 324292 324295 324298 324299 324300 324301 324302 324303 324307 324308 324309 324310 324311 324312 324313 324314 324315 324317 324318 324319 324321 324322 324324 324325 324326 324327 324328 324333 324338 324346 324347 324349 324351 324353 324354 324355 324356 324357 324359 324361 324363 324364 324365 324366 324369 324370 324371 324372 324373 324378 324379 324380 324381 324386 324387 324388 324390 324391 324392 324393 324394 324396 324397 324398 324399 324401 324403 324404 324405 324406 324407 324408 324409 324410 324411 324412 324413 324414 324415 324416 324417 324418 324419 324420 324421 324422 324423 324425 339631 340111 340115 340121 340132 340201 340202 342616 342617 342618 342619 342620 342629 342938 342941 343832 361739 361743 361752 361755 361771 361779 396340 404454 404565 404662 404695 404853 409195 409197 410561 413437 413438 413442 413443 413445 413446 413447 413449 413450 413451 413452 413453 413454 413455 413456 413457 413458 413459 413460 413461 413462 413464 413465 413466 413469 413470 414368 418389 425296 425298 425299 425300 425301 425302 425303 425304 425398 425402 425432 425464 425465 426948 426949 426953 426955 426956 426957 426958 426959 426960 426961 426962 427000 427002 427006 427009 427012 427015 427017 427019 427021 427025 427034 427063 454106 470889 470891 470892 470894 470899 470902 470903 470904 470907 470908 470925 471910 471912 472070 472071 472072 472085 472086 472732 472733 472734 472741 472754 472862 472865 472867 472869 472870 472873 472874 472877 472882 472889 472890 472891 472892 472893 472895 474180 474181 474182 474183 474184 474188 474189 474190 474191 474192 474193 474194 474195 474197 474198 474199 474200 474201 474202 474204 474243 474312 474340 475651 475662 475671 478235 478236 478644 478645 478647 479872 479873 479875 479880 479885 479890 479902 479907 523208 523209 523229 523299 525013 528027 528538 528539 528551 528557 528566 528567 528568 528569 528572 528573 528574 528583 528590 528591 528599 528606 528611 528643 528644 540840 540845 546032 549360 549363 549376 549378 549382 549383 549387 549389 549390 549391 549397 567437 567438 569263 569264 569265 569266 569267 569269 569270 569271 569272 569273 569648 569649 569668 569672 569682 569683 569685 569688 569691 569692 569693 569694 569696 569697 569698 569700 569701 572175 572176 572177 572178 572179 572180 572183 572509 572510 572785 572804 572805 580845 580846 580848 580850 580852 580853 580854 580855 580856 580857 580859 580884 580885 581277 581278 581279 581280 581281 1120 1122 3101 3464 3466 3967 3969 4714 6904 7873 8849 10397 25808 26718 28782 28783 29192 29398 29942 29946 31414 31417 31723 54494 54643 54646 54647 64776 64805 64809 65800 65801 65802 67470 67472 69889 69890 69891 69893 70182 70183 70217 70218 76228 76806 76807 77692 78320 78321 78322 78323 78324 78922 80222 86544 87729 87730 87731 87732 87797 87798 87799 94286 94474 94487 94489 95469 95688 95689 95692 95709 99587 106063 106387 106388 109565 109566 109567 109569 109570 109571 109572 109574 109579 109588 109589 109591 124306 125303 125304 125305 125306 126145 126146 142462 142474 142475 142476 142477 142501 142829 143194 143195 143588 143589 145256 145679 159731 159732 163194 163195 164498 164499 164508 164510 172272 177143 178134 178135 178136 178137 178138 178139 178140 178141 178142 178143 178192 178197 178198 178199 178201 178202 178204 179080 179083 179084 179085 179086 179087 179088 179089 179090 179092 179093 179095 179096 182135 182137 182251 182254 182255 182256 182257 182260 182261 182262 184666 185174 188099 188875 198434 198450 199250 199251 199252 199253 199254 199255 199260 199261 199262 199263 200085 200114 200121 200122 200141 200142 200694 200701 200797 200798 200801 206010 219573 219574 219693 219694 219695 219696 220108 220657 220658 221597 221598 221599 221600 221603 221604 221606 222120 238535 238536 238537 238538 238539 238540 238541 238542 238547 238548 239243 240753 241055 241056 241059 241061 241062 241063 241064 241065 241067 241068 241069 241073 241074 241077 241085 251133 251134 251139 251159 256768 256974 256975 256976 256977 256978 256980 256982 256983 260401 262615 262616 262617 264222 264223 264224 264226 264231 269663 284083 284084 284085 284086 284087 284089 284090 284091 284092 284095 284097 284398 284399 284412 284800 286742 286743 286757 288426 288427 290108 290197 291074 291078 300618 300632 300635 300637 300638 300640 300641 300644 300645 300647 300649 300650 300655 300656 300657 300658 300659 300660 300661 300662 300663 305374 312072 312073 312075 312076 312649 312650 312651 312652 313517 313519 315487 316319 317610 319145 319147 319148 319149 319450 320427 336076 337136 337137 337138 337139 337140 337141 339716 339722 340900 340901 340902 341234 345100 345101 345102 345103 345104 345105 345137 345138 348371 348372 348373 348374 348378 348380 348381 348383 349018 349024 361745 361769 403751 403854 403867 403960 404011 404045 404190 404191 404192 404193 404371 404415 404439 404513 404530 404546 404679 404680 404803 404849 405923 409207 409241 409242 409243 409244 409245 409246 409247 409256 409259 409276 410397 410398 410399 410400 410401 416137 417688 417709 437950 437951 437952 459525 472095 472097 472111 472112 472113 472114 472115 472116 472117 472989 472990 472991 472992 472993 473004 473014 473015 473016 473024 473025 473027 473029 475653 511680 522435 522436 522437 523737 572525 572526 572527 572909 572911 572956 572958 1619 5770 6332 6334 6338 53445 55385 57063 65681 70840 70967 70969 70970 80485 81403 81404 81405 81406 81441 81442 81443 87499 88957 101642 101643 101936 101937 109263 109269 130045 130046 130050 130053 130054 143596 143599 143600 143601 143602 143604 143605 143606 143607 148861 148918 179733 179736 179737 179738 179742 179743 184122 184124 199577 200123 200124 201150 201155 201156 201157 201159 201386 204136 217635 217678 217679 217680 217681 217682 217683 217684 217685 223074 239709 239710 239711 242357 242368 244229 248627 256840 256841 256842 256843 256973 259189 259194 261322 261326 261365 261376 261443 263497 263498 263499 263501 263536 263537 264232 264336 286004 287152 287958 287959 287960 287961 287962 287963 287964 287965 288409 290112 290115 292666 303054 311850 312731 328528 336064 336065 339736 339737 339738 339739 345055 345059 345164 345165 345166 345167 345168 345169 345170 345171 345172 345173 345176 348036 348843 348844 352147 361748 403639 405421 405423 405424 405425 409173 409196 420855 425392 425393 425394 425396 431186 431187 436642 476823 476824 476825 523300 524807 529428 529430 529431 529432 529433 529434 529435 529436 529437 529438 529440 529441 529442 529443 529445 529446 529447 529448 529449 529450 529451 529452 529453 529455 529456 529457 529458 529459 529460 529461 529462 529463 529464 529465 529466 529467 529468 529469 529470 529472 529473 529475 529476 531233 531252 531253 531254 531255 531256 531257 531258 531259 531260 531261 531262 531263 531275 531282 531283 531284 531285 531286 531287 531288 531289 531290 531291 531292 531293 531294 531295 531297 531298 531299 531300 531301 531302 531304 531305 531306 531307 531308 531309 533210 7381 59403 59404 80064 80079 80080 80083 80346 86790 86803 86805 92867 92869 106227 106307 106308 106310 106395 122486 127338 145573 163189 163193 164061 179112 179115 179120 179122 179125 179126 179127 193550 198598 198604 198605 213642 216502 216504 217663 217665 242358 242359 242361 242364 242366 242829 245318 245327 257055 259241 259243 259244 259247 259248 259249 261330 261332 261400 270024 271390 284113 287125 287127 288424 289045 289046 290102 290103 290207 290216 298765 307430 312085 312087 312088 312096 312097 312658 314110 314113 314145 315526 320234 320235 320236 323723 323726 334517 335299 335302 335305 335306 335307 335311 335313 335315 335316 335317 336113 336114 339569 339705 341489 341769 341778 341779 341783 341784 341787 349937 352881 403967 404960 404973 405368 405416 405417 405418 411001 411002 411003 413367 413368 413369 413370 413371 413372 413373 413374 413378 413379 413380 413381 415944 415946 415947 415949 415950 415951 415957 415958 415961 415962 415963 415964 415965 415967 415968 415977 418441 425095 464256 469449 488645 488758 494176 501153 501154 501155 501156 501157 501160 501161 501162 503730 503731 503732 504319 523197 523198 523199 523200 523201 523202 523203 523204 523205 523206 523223 523224 523225 523226 523227 523228 524962 524973 524974 524975 524976 524977 524978 525622 526333 526969 527906 527907 527908 527909 529318 529319 529320 535148 67900 93840 99939 99964 163574 178349 199498 199554 223059 223062 223064 223067 249068 249079 249081 249181 249184 249289 250657 261319 261321 261323 261324 261361 261409 261426 261465 261517 261519 261530 261531 312773 316351 328633 336063 346307 346314 386576 386578 386581 470331 524790 524791 524792 524800 524802 529255 529256 529257 529258 529259 529260 529272 72049 72050 72051 97412 99772 99773 100967 100971 100972 100973 100974 100984 121028 121043 122406 162133 162136 162258 162261 162262 162266 162273 162274 162276 162282 162283 162284 162293 162336 208723 245977 267091 267099 267100 282748 282749 319386 321209 321452 346389 431182 431183 431184 529352 531265 531266 531267 531268 531269 531270 531271 531272 531273 531274 558665 558666 558667 558668 558669 558670 558671 558672 558673 558674 558675 558676 558677 558678 558679 88112 88114 121488 143953 162240 177070 177075 177076 177082 177083 177088 177117 177118 177119 181548 196153 201546 215372 216470 216471 216472 216473 218186 218189 218190 241094 241097 241099 241100 245342 246594 247251 247252 247254 247586 248051 248418 263505 264920 264921 264923 305791 314898 314899 314900 321975 321978 339741 339742 352933 352938 352939 352940 352943 352948 352949 352951 352954 431192 436614 436615 476119 476120 476121 476123 476124 476125 476126 531264 535139 1 ] |
|
34.32 ms (18.33%) |
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:
[ 7 70 331 332 333 334 335 336 71 337 338 339 340 341 72 342 343 344 345 346 73 347 348 349 350 351 74 352 353 354 355 75 356 76 357 358 359 360 361 77 362 363 364 365 366 ] |
|
10.01 ms (5.35%) |
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 INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id INNER JOIN characteristic_label c4_ ON c3_.characteristic_label_id = c4_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND c4_.id = ? AND c3_.value = 'Oui'
Parameters:
[ 7 70 331 332 333 334 335 336 71 337 338 339 340 341 72 342 343 344 345 346 73 347 348 349 350 351 74 352 353 354 355 75 356 76 357 358 359 360 361 77 362 363 364 365 366 7 ] |
|
9.40 ms (5.02%) |
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 INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id INNER JOIN characteristic_label c4_ ON c3_.characteristic_label_id = c4_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND c4_.id = ? AND c3_.value = 'Oui' LIMIT 30
Parameters:
[ 7 70 331 332 333 334 335 336 71 337 338 339 340 341 72 342 343 344 345 346 73 347 348 349 350 351 74 352 353 354 355 75 356 76 357 358 359 360 361 77 362 363 364 365 366 7 ] |
|
9.21 ms (4.92%) |
54 |
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:
[
331
]
|
|
7.42 ms (3.96%) |
40 |
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"
]
|
|
7.23 ms (3.86%) |
12 |
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:
[ 126145 7 ] |
|
6.97 ms (3.72%) |
26 |
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" 126145 ] |
|
5.33 ms (2.85%) |
26 |
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"
]
|
|
3.83 ms (2.04%) |
27 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
3.26 ms (1.74%) |
13 |
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:
[ 126145 0 ] |
|
2.92 ms (1.56%) |
13 |
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:
[ 126145 "C" ] |
|
2.85 ms (1.52%) |
13 |
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-12 06:10:11" "%2%" 126145 ] |
|
2.79 ms (1.49%) |
13 |
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:
[
126145
]
|
|
2.33 ms (1.24%) |
13 |
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:
[
126145
]
|
|
2.21 ms (1.18%) |
9 |
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:
[
178204
]
|
|
2.03 ms (1.08%) |
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 INNER JOIN characteristic c3_ ON p0_.id = c3_.product_id INNER JOIN characteristic_label c4_ ON c3_.characteristic_label_id = c4_.id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 AND c4_.id = ? AND c3_.value = 'Oui' AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 7 70 331 332 333 334 335 336 71 337 338 339 340 341 72 342 343 344 345 346 73 347 348 349 350 351 74 352 353 354 355 75 356 76 357 358 359 360 361 77 362 363 364 365 366 7 535139 531295 529473 529259 476126 413460 413445 413442 404853 343832 264293 263537 201135 201126 182137 178204 175431 148918 126145 3279 1382 ] |
|
1.07 ms (0.57%) |
4 |
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:
[ 126145 9964444 ] |
|
0.73 ms (0.39%) |
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:
[
"amenagement-d-espace"
]
|
|
0.49 ms (0.26%) |
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.43 ms (0.23%) |
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:
[
"amenagement-d-espace"
]
|
|
0.40 ms (0.22%) |
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:
[
179089
]
|
|
0.29 ms (0.15%) |
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:
[
"amenagement-d-espace"
]
|
|
0.18 ms (0.10%) |
1 |
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_.promotion_id = ? ORDER BY d0_.quantity DESC
Parameters:
[
179089
]
|
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.