Query Metrics
99
Database Queries
24
Different statements
137.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
82.74 ms (60.29%) |
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:
[ 111 114 115 116 117 135 136 137 138 147 148 149 150 151 152 153 154 155 156 157 237 238 239 240 260 261 262 263 264 265 266 267 268 269 272 273 274 275 276 279 280 285 292 293 420 421 424 1231 1232 1245 1246 1247 1248 1268 1365 1366 1367 1391 1393 1425 1426 1427 1428 1443 1502 1503 1508 1510 1511 1512 1519 1520 1525 1533 1534 2076 2077 2794 2795 2931 2934 2935 3995 3996 3997 3998 3999 4006 4007 4008 4226 4227 4674 4676 4678 4679 4680 4681 4682 4683 4821 4822 4823 5001 5154 5155 5156 5240 5241 5242 5327 5328 5329 5330 5756 5757 5758 6340 6581 6870 6871 6900 7987 7990 7991 8035 8036 9143 9144 9145 9146 9174 9175 9524 9525 9526 9527 9528 9529 9567 9568 9569 10100 10101 10103 10618 10619 11049 11050 11051 11144 11358 21052 26517 26518 26519 26520 26524 26525 27554 28717 28718 28851 29416 29589 29624 29625 29626 29627 29628 29629 29630 29631 29695 29696 29697 29698 29864 29865 29866 29867 30727 30728 30729 31208 31469 32503 33632 33633 33634 33965 33966 33967 55020 55021 55022 55123 56046 57696 60091 60092 60093 60147 60148 60149 60150 60151 60152 60153 60154 60430 64417 64418 64419 64516 64517 64682 64683 64684 64836 64837 65377 65378 65393 65394 65397 65398 65402 65604 65606 65607 65608 65612 65626 65627 65628 65629 65645 65672 65792 65793 65794 67069 67070 67071 67072 67075 67076 67756 67757 67758 67929 70382 70383 70771 70772 70773 70873 71005 71006 71007 71008 71009 71010 71011 71020 71021 71022 71030 71036 71037 71043 71342 72012 72013 72922 72923 72924 72925 72926 72927 72928 72929 72930 72931 72932 72933 73628 74267 74378 74379 74380 74381 74382 74879 75165 77520 77521 77522 77523 77524 77525 77530 80036 80037 80085 80086 80087 80091 80092 80097 80098 80099 80100 80109 80110 80111 80112 80118 80119 80120 80123 80347 80348 80357 80358 80359 81099 81101 81234 81235 82257 82258 82259 82872 82876 85578 85579 85580 87287 87288 87297 87298 87299 87304 87331 87334 87383 87384 88067 90002 90003 95954 95955 95959 95960 95961 95962 95963 95964 95965 95966 95967 95968 95969 95970 95971 95972 95975 95976 95977 95978 95979 96004 96104 96106 96107 96108 96109 96110 96111 96112 96113 96114 96115 96116 96117 96118 96119 96120 96121 96122 96123 96124 96125 96126 96127 96784 96808 97151 99087 99818 101116 102163 103176 103177 104770 106170 106171 106174 106175 106179 106180 106181 106182 106183 106184 106185 106186 106197 106198 106211 106212 108864 108865 108872 108876 108878 108889 108890 108891 108892 108905 108907 108908 108910 108919 108920 108928 109143 109158 109159 109160 109161 109162 109183 109424 109920 109935 110207 110229 110231 110232 110325 111413 111414 111415 111416 111693 111719 112121 113719 125202 125292 125293 125864 125865 125866 125867 125868 125873 127324 127325 127328 127330 127331 127332 128479 128576 130064 130065 130066 130072 131953 131956 133042 133044 135203 140618 141544 141545 141546 144820 144821 144822 144823 144836 144839 144841 144842 144843 144844 144845 144846 144847 144848 145554 145555 145556 145557 146067 146068 146069 146070 146074 146075 146076 146077 146078 147143 147144 147145 147146 147167 147560 148797 148798 148799 148800 148803 148804 148805 148806 148807 148808 148809 148810 148811 148812 155190 155191 155396 155399 155502 156956 158120 158121 158368 160994 160995 162665 162666 162667 162668 162682 162683 162697 162698 163175 163176 163196 163197 163198 163199 163200 163201 163202 163203 163204 163575 163576 163967 163968 163969 163970 163971 163972 163975 164016 164017 164018 164019 167903 172773 173603 178098 178099 178107 178151 178207 178213 178215 178216 178217 178218 178219 178225 178228 178229 178230 178231 178233 178244 178245 178246 178247 178248 179473 180098 182143 183748 183749 183750 184669 185173 185662 186000 190479 191267 192188 192269 193566 195886 197264 197268 199068 199069 199072 199080 199082 199274 199275 199278 199279 199280 201632 201635 202475 202476 202477 204144 204149 204726 204727 204728 205093 205547 210138 212217 212228 212993 213672 213673 214111 215239 218543 219113 219114 219115 219116 219118 219119 220719 220720 220721 220722 221174 221175 221514 221515 221516 221530 221531 221532 221533 221535 221563 222450 222451 222456 222602 222603 222604 224168 224944 224945 224946 235683 235723 235955 235956 235957 235959 235960 235961 235963 235964 237123 237124 237125 237129 237131 237132 237134 237135 237143 237147 237149 238246 239262 239992 239999 241815 241821 241878 241879 241880 241881 241896 242830 242836 242849 242850 242851 242852 242853 242854 242855 242856 242857 242884 242885 242886 242887 243322 243324 243427 243575 244108 244137 244138 244144 244145 244189 244190 244191 244192 244193 244194 244195 244196 244197 244198 244199 244200 244222 244901 244905 244918 244919 244920 244924 244925 244926 244945 244952 245448 245449 245503 246268 246270 246305 246306 246307 246308 246855 246856 248185 248466 248467 248477 248612 250404 255925 256266 256374 256476 256793 256794 256796 256875 256879 256889 256939 257078 257079 257080 257081 257448 259672 260970 260971 262614 262620 262621 262622 262623 262626 262627 262628 262629 262630 262631 262664 262665 262682 262683 262684 262685 262686 262687 262826 262830 263470 263472 263474 263476 263489 263490 263529 263532 263599 263601 263604 263609 263625 263630 263631 263632 263635 263636 263646 263647 263669 263670 263673 263674 263707 263708 267086 267087 268565 273472 273473 273741 273751 273760 273775 282277 282686 282688 282691 282692 282693 283316 283482 284303 286018 286747 286813 287870 287939 288400 288733 288996 288997 289003 289004 289005 289006 289007 289008 289740 289741 289759 289760 289761 289763 289764 289772 289773 289774 289781 290162 290169 290175 290176 290177 290178 290179 290180 290181 290182 290183 290184 290185 290186 290187 290199 290201 290655 291165 291171 291432 291840 300575 301609 301616 301640 301662 301664 303099 303100 303101 303511 303512 303514 303887 303917 304606 304626 305417 305418 305419 305420 305421 305422 305423 305424 305769 305770 305771 305772 305773 305774 305775 306055 306056 306057 306058 312556 312557 312559 312560 312570 312571 312572 312573 312581 312582 312726 312727 314049 315528 316233 317183 317184 317718 317741 317743 317744 318102 318103 318104 318105 318106 318107 318108 318109 318110 318111 318156 318159 318162 319428 319507 321125 321126 321972 321973 322604 323269 323270 331620 331621 331622 331628 331629 331630 331631 331633 331669 336923 336932 336934 340942 342546 342548 342612 342613 342614 342664 342665 342666 342667 342668 342669 343172 343186 343187 343191 343192 343193 344761 344762 344825 344830 344831 344856 344857 344858 345149 345150 346344 346345 346355 347012 348231 361350 361360 361361 361362 361371 361380 361401 361406 361407 361408 361409 361410 361411 361412 361418 361420 361421 361429 361431 361442 361448 361454 361459 361460 361461 361464 361471 361511 361536 361541 361542 361751 379212 389933 390552 390553 390554 390555 394740 394755 395846 395848 395850 395852 401756 403574 403575 403595 403596 403597 403600 403603 403604 403618 403619 403649 403660 403666 403679 403680 403681 403682 403683 403684 403691 403701 403725 403733 403737 403760 403763 403805 403827 403832 403833 403848 403855 403861 403870 403888 403889 403934 403942 404025 404043 404118 404119 404120 404129 404130 404131 404135 404136 404137 404138 404139 404140 404143 404144 404227 404274 404289 404357 404446 404447 404453 404495 404506 404514 404515 404516 404531 404532 404533 404545 404552 404616 404617 404618 404619 404620 404621 404622 404623 404624 404625 404626 404627 404628 404629 404632 404633 404642 404653 404654 404655 404656 404657 404661 404723 404728 404731 404735 404739 404740 404742 404743 404744 404753 404772 404773 404857 404866 404879 404955 404970 404983 409522 409526 410384 410385 410386 410387 410388 410389 410408 410682 415985 416720 416721 416722 416723 416724 416725 416726 416727 416798 416869 416870 416871 417592 418358 418359 418378 418382 418383 420361 420362 420363 420933 425339 425388 425389 425390 425391 425411 425412 425422 425423 425424 425425 425427 425463 425506 425507 425508 436625 436626 436627 436628 436646 453632 453634 453636 453637 453638 453641 453644 453645 453646 453649 453653 453654 453656 453690 457732 457733 457813 457815 457816 457817 458416 458467 458468 458476 458481 458483 458484 458509 458515 461492 461493 461494 461495 461496 461497 461498 467154 467156 467159 467160 467161 467162 467164 467165 473559 473560 473561 473564 473568 473569 473570 473571 473572 473574 473575 473576 473577 473578 473579 473580 473581 473582 473583 473584 473585 473586 474314 474319 474408 475676 476050 476513 476792 476793 476794 476795 476796 476797 476798 476803 476804 476805 478398 478399 478402 478655 478656 478657 479451 479452 479453 479454 479468 479480 483793 485265 485266 485267 485270 485275 485276 485280 485281 488612 488613 488616 488617 488618 488619 488620 488621 488622 488629 488634 488635 488637 488638 488647 488648 488759 488760 504022 504023 504025 504026 504030 504031 504034 504035 504038 504042 504043 504318 508254 511626 511628 511629 511630 511631 511632 511633 511634 511899 511900 511901 512619 512626 512629 512630 512631 512632 512635 512642 512643 519623 519624 519625 519626 519627 519650 523271 526981 529278 529279 529280 529282 529287 529288 529289 529291 529292 529293 529294 529295 529301 529323 529324 529325 529377 529396 530013 530014 530015 531138 531320 531321 531322 532781 532782 532783 532784 548485 548490 550465 550466 550467 550469 550473 550475 550476 550477 550478 550479 550482 550485 550486 550489 550490 550492 550493 550494 550495 550496 550497 550501 555308 555309 555310 555311 555312 555313 555314 555315 555316 555317 555318 555319 555320 555321 555322 558232 558233 558778 558779 558780 558781 558782 558783 558784 558786 566168 566175 566176 566177 567433 567434 567435 575325 575326 1 ] |
|
17.54 ms (12.78%) |
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:
[ 60 287 288 289 290 291 292 293 294 ] |
|
9.18 ms (6.69%) |
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:
[ 60 287 288 289 290 291 292 293 294 ] |
|
3.70 ms (2.70%) |
4 |
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:
[ 237 0 ] |
|
3.61 ms (2.63%) |
4 |
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:
[
237
]
|
|
2.91 ms (2.12%) |
13 |
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"
]
|
|
2.84 ms (2.07%) |
18 |
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:
[
1
]
|
|
2.56 ms (1.86%) |
8 |
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" 237 ] |
|
1.77 ms (1.29%) |
8 |
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"
]
|
|
1.41 ms (1.02%) |
9 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.40 ms (1.02%) |
8 |
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:
[
197925
]
|
|
1.16 ms (0.84%) |
4 |
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:
[ 237 "C" ] |
|
0.99 ms (0.72%) |
4 |
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 05:25:15" "%2%" 237 ] |
|
0.94 ms (0.69%) |
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:
[ 60 287 288 289 290 291 292 293 294 111 114 115 116 117 135 136 137 138 147 148 149 150 151 152 153 154 155 156 157 237 238 239 240 260 261 262 263 264 265 ] |
|
0.93 ms (0.68%) |
3 |
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:
[ 237 9955416 ] |
|
0.75 ms (0.55%) |
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:
[
"fournitures-stylos-crayons"
]
|
|
0.74 ms (0.54%) |
4 |
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:
[
237
]
|
|
0.46 ms (0.33%) |
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
Parameters:
[ 60 287 288 289 290 291 292 293 294 ] |
|
0.34 ms (0.25%) |
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:
[
"fournitures-stylos-crayons"
]
|
|
0.33 ms (0.24%) |
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.27 ms (0.20%) |
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:
[
"fournitures-stylos-crayons"
]
|
|
0.26 ms (0.19%) |
1 |
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:
[
260
]
|
|
0.23 ms (0.17%) |
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 = ?
Parameters:
[
5
]
|
|
0.18 ms (0.13%) |
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:
[
178489
]
|
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.