Query Metrics
108
Database Queries
22
Different statements
2712.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1872.00 ms (69.02%) |
1 |
SELECT c0_.id AS id_0, c0_.temporary_cart_number AS temporary_cart_number_1, c0_.type AS type_2, c0_.number AS number_3, c0_.slip AS slip_4, c0_.status AS status_5, c0_.order_picker AS order_picker_6, c0_.created_at AS created_at_7, c0_.delivery_date AS delivery_date_8, c0_.login AS login_9, c0_.user_reference AS user_reference_10, c0_.tracking_number AS tracking_number_11, c0_.deposit AS deposit_12, c0_.sector AS sector_13, c0_.sub_sector AS sub_sector_14, c0_.customer_name AS customer_name_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.address3 AS address3_18, c0_.zip_code AS zip_code_19, c0_.city AS city_20, c0_.country AS country_21, c0_.phone AS phone_22, c0_.fax AS fax_23, c0_.email AS email_24, c0_.customer_name_delivery AS customer_name_delivery_25, c0_.address1_delivery AS address1_delivery_26, c0_.address2_delivery AS address2_delivery_27, c0_.address3_delivery AS address3_delivery_28, c0_.zip_code_delivery AS zip_code_delivery_29, c0_.delivery_city AS delivery_city_30, c0_.country_delivery AS country_delivery_31, c0_.delivery_phone AS delivery_phone_32, c0_.fax_delivery AS fax_delivery_33, c0_.email_delivery AS email_delivery_34, c0_.reglement AS reglement_35, c0_.updated_at AS updated_at_36, c0_.price_ht AS price_ht_37, c0_.price_tva AS price_tva_38, c0_.price_ttc AS price_ttc_39, c0_.price_cost_ht AS price_cost_ht_40, c0_.display_ttc AS display_ttc_41, c0_.package_number AS package_number_42, c0_.weight AS weight_43, c0_.volume AS volume_44, c0_.discount AS discount_45, c0_.feedback AS feedback_46, c0_.global_discount AS global_discount_47, c0_.commitment_number AS commitment_number_48, c0_.promotional_code AS promotional_code_49, c0_.multiplier_coefficient AS multiplier_coefficient_50, c0_.is_out_of_budget AS is_out_of_budget_51, c0_.lead_word AS lead_word_52, c0_.facturation AS facturation_53, c0_.complete_delivery AS complete_delivery_54, c0_.urgent_delivery AS urgent_delivery_55, c0_.complete_facturation AS complete_facturation_56, c0_.paypal AS paypal_57, c0_.regroupement AS regroupement_58, c0_.transaction AS transaction_59, c0_.plate_number AS plate_number_60, c0_.is_hidden AS is_hidden_61, c0_.budget_id AS budget_id_62, c0_.customer_id AS customer_id_63, c0_.billing_customer_id AS billing_customer_id_64, c0_.user_id AS user_id_65, c0_.delivery_id AS delivery_id_66, c0_.market_id AS market_id_67, c0_.price_id AS price_id_68, c0_.society_id AS society_id_69, c0_.commercial_id AS commercial_id_70, c0_.delivery_cost_id AS delivery_cost_id_71 FROM customer_order c0_ INNER JOIN customer_order_lines c1_ ON c0_.id = c1_.customer_order_id INNER JOIN product p2_ ON c1_.product_id = p2_.id WHERE p2_.id = ? AND c0_.created_at >= ?
Parameters:
[ 76326 "2025-02-12 06:46:30" ] |
|
706.79 ms (26.06%) |
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 customer_order_lines c1_ ON (c1_.product_id = p0_.id) INNER JOIN customer_order c2_ ON c1_.customer_order_id = c2_.id WHERE c2_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 GROUP BY p0_.id, p0_.reference, p0_.manufacturer, p0_.short_label, p0_.long_label, p0_.weight, p0_.sold_by, p0_.ppht, p0_.ppttc, p0_.paht, p0_.pattc, p0_.legal_discount_library, p0_.fidelity_bonus, p0_.brand, p0_.time_limit, p0_.coef, p0_.is_discountable, p0_.is_btob, p0_.is_btoc, p0_.is_customizable, p0_.is_library, p0_.is_nathan, p0_.is_green, p0_.is_orapi_grand_frais, p0_.is_active, p0_.slug ORDER BY COUNT(p0_.id) DESC LIMIT 10
Parameters:
[ 6333873 6337753 6337769 6337801 6337852 6337870 6337877 6337881 6338002 6339884 6340346 6340876 6341068 6341839 6342170 6342999 6343061 6343233 6343357 6343824 6342086 6344087 6344112 6344126 6344311 6344594 6344925 6345090 6345232 6345242 6345441 6345462 6344262 6345921 6346066 6346441 6346591 6346782 6346821 6346823 6347348 6347981 6347988 6348002 6348038 6348039 6348041 6348042 6348044 6348072 6348151 6348160 6348191 6348192 6348200 6348212 6348231 6348236 6348239 6348241 6348243 6348247 6348250 6348253 6348254 6348257 6348262 6348263 6348272 6348275 6348278 6348291 6348297 6348298 6348300 6348301 6348308 6348309 6348311 6348312 6348313 6348337 6348403 6348405 6348410 6348451 6348452 6348515 6348579 6348705 6348743 6348745 6348749 6348769 6348770 6348773 6348813 6348814 6348831 6348868 6348896 6348928 6348930 6348961 6349013 6349014 6349025 6349026 6349028 6349032 6349044 6349067 6349082 6349083 6349084 6349085 6349190 6349191 6349216 6349220 6349257 6349265 6349307 6349316 6349688 6349689 6349787 6349822 6349823 6349994 6349995 6350036 6350040 6350074 6350076 6350099 6350199 6350207 6350208 6350212 6350221 6350243 6350245 6350268 6350320 6350347 6350398 6350407 6350442 6350443 6350444 6350445 6350473 6351657 6351841 6352442 6351588 6352946 6353230 6353328 6353913 6353965 6354486 6354702 6355220 6356517 6358817 6361195 6361369 6362707 6363092 6363153 6363874 6363728 6364398 6365499 6366371 6364616 6366771 6366788 6367145 6367272 6367647 6361770 6368334 6368240 6368344 6368252 6368335 6368608 6368221 6368234 6368309 6368311 6368425 6368460 6368478 6368506 6368551 6368686 6368877 6368209 6368404 6368595 6368694 6368740 6368956 6369237 6370258 6370305 6370986 6371322 6371374 6371382 6371444 6372249 6372812 6373059 6373129 6373272 6373486 6373681 6373772 6373818 6373826 6373831 6373883 6373887 6373892 6373913 6373922 6373958 6373959 6368247 6368302 6368338 6368463 6368544 6368563 6368829 6368900 6368903 6368915 6368386 6368851 6374130 6373886 6374154 6374158 6374183 6368208 6368866 6374173 6374215 6368391 6374231 6374258 6374286 6374291 6374305 6368976 6374356 6374412 6374445 6374471 6368872 6374189 6374366 6365122 6374611 6368565 6368654 6368699 6368883 6374188 6374237 6374276 6374290 6374334 6374350 6368383 6374702 6374745 6374878 6374882 6374911 6374917 6374922 6374936 6374939 6374949 6374977 6368248 6368285 6368512 6368570 6368892 6368989 6374282 6374426 6374718 6375012 6367668 6375180 6368472 6373944 6374973 6375068 6375278 6375288 6368556 6375326 6375349 6375357 6375368 6375387 6375421 6375423 6369017 6375135 6374665 6375460 6375506 6375529 6368191 6368920 6374706 6375388 6375361 6374482 6375790 6375829 6376007 6376035 6376123 6376142 6376172 6376185 6376256 6374433 6374687 6374754 6375074 6375518 6375696 6376392 6376397 6376410 6376436 6376447 6376505 6376545 6376561 6376576 6376626 6374335 6374546 6375513 6376828 6377128 6377263 6377309 6377312 6377332 6377345 6377349 6377352 6377358 6376798 6377455 6377480 6377546 6368933 6375251 6377660 6376511 6377733 6375501 6377913 6378027 6378210 6378495 6378520 6378651 6378709 6378720 6378815 6378892 6379821 6379880 6364587 6380791 6381046 6381596 6381646 6381879 6381881 6382054 6382201 6383203 6383536 6383916 6384947 6385363 6384050 6386049 6386517 6386700 6387119 6388249 6388625 6388635 6388802 6388872 6388911 6363577 6364216 6367817 6389321 6389657 6387491 6389826 6389941 6389965 6390381 6390692 6390688 6391344 6391373 6392273 6392207 6390654 6378941 6393144 6393362 6394004 6392861 6395036 6395090 6395466 6395519 6395871 6396139 6396173 6396629 6396632 6396634 6396657 6396747 6396819 6396834 6396863 6396869 6396870 6396872 6396875 6396879 6396881 6396882 6396885 6396896 6396898 6396905 6396910 6396916 6396925 6396931 6397018 6397019 6397025 6397133 6397333 6397371 6397373 6397404 6397405 6397408 6397409 6397464 6397482 6397516 6397657 6397677 6397678 6397682 6397683 6397684 6397709 6397712 6397713 6397715 6397716 6397731 6397735 6397736 6397821 6397824 6397825 6397946 6397961 6397962 6398014 6398015 6398066 6398067 6398072 6398089 6398168 6398690 6398778 6398822 6399072 6399084 6399106 6399107 6399125 6399148 6399157 6399209 6399238 6399300 6399306 6399320 6399321 6399323 6399362 6399396 6399415 6399442 6399444 6399446 6399464 6399473 6399510 6399512 6399518 6399542 6399543 6399819 6399847 6400018 6400069 6400093 6400201 6400236 6401526 6401528 6401671 6401963 6402073 6402255 6403120 6403259 6403683 6403693 6403716 6405715 6406524 6406881 6406907 6407117 6407492 6408008 6408245 6408441 6409492 6410095 6410439 6411470 6412612 6412803 6414435 6415685 6416252 6416377 6416380 6416971 6417376 6417384 6417392 6417738 6417852 6418104 6418169 6418258 6418272 6418440 6419484 6419526 6419958 6419965 6420099 6420441 6420459 6420519 6422100 6422156 6422402 6423820 6424722 6425789 6426033 6426391 6427230 6427270 6427289 6427316 6427369 6427390 6427411 6427441 6427449 6427658 6427661 6427699 6427755 6427820 6427837 6427906 6427939 6427953 6427979 6427980 6428022 6428286 6428424 6428711 6428793 6428909 1000019015 6429404 6429460 6429557 6429647 6429688 6429793 6429803 6429830 6429920 6429931 6429937 6430056 6430280 6430285 6430294 6430308 6430325 6430345 6430367 6430414 6430415 6430482 1000019860 6430554 6430601 6430843 6430847 6431085 6431100 6431162 6431213 6431262 6431293 6431492 6431796 6431894 6432188 6432205 6432212 6432225 6432298 6432309 6432315 6432521 6433143 6433368 6433546 6433570 6433581 6433666 6433751 6433954 6434413 6435219 6435220 6435313 6435352 6435426 6435461 6435643 6435706 6436327 6438106 6438548 6438801 6439224 6439233 6439647 6441494 6442244 6442340 6443095 6444230 6445166 6446025 6447715 6448267 6449659 6450070 6450546 6450896 6450955 6451742 6452285 6452742 6452814 6452819 6452910 6452956 6452988 6452990 6453004 6453018 6453025 6453031 6453035 6453039 6453041 6453045 6453046 6453050 6453052 6453055 6453064 6453069 6453070 6453077 6453084 6453085 6453092 6453093 6453096 6453191 6453193 6453211 6453213 6453214 6453257 6453392 6453394 6453451 6453706 6453707 6453721 6453725 6453775 6453794 6453920 6453974 6453991 6454057 6454080 6454081 6454082 6454086 6454087 6454101 6454120 6454122 6454123 6454141 6454142 6454144 6454288 6454290 6454292 6454293 6454354 6454424 6454426 6454436 6454487 6454495 6455670 6455671 6455927 6456017 6456049 6456360 6456363 6456373 6456389 6456390 6456446 6456540 6456564 6456622 6456665 6456669 6456745 6456746 6456781 6456783 6456815 6456816 6456892 6457388 6458232 6459259 6459763 6461668 6462284 6462744 6462967 6464291 6468618 6468682 6469026 6469057 1000000867 1000001425 1000001571 1000001063 6391429 1000002480 1000002482 1000002488 1000002487 1000004678 1000004695 1000004908 1000004940 1000005040 1000004892 1000005174 1000007380 1000004679 1000006761 1000010666 1000010667 1000011961 1000011958 1000013087 1000013212 1000013635 1000013643 1000013859 1000013634 1000014944 1000014985 1000015098 1000015667 1000016793 1000017268 1000017280 1000017283 1000016690 1000013364 1000017330 1000016695 1000017312 1000017362 1000017423 1000017433 1000017334 1000017316 1000016788 1000017338 1000017332 1000018450 1000018455 1000013315 1000017412 1000017253 1000018513 1000013423 1000018759 1000018461 1000018605 1000018662 1000018707 1000018915 1000019212 1000019248 1000019255 1000017364 1000018884 1000017214 1000014541 1000018312 1000019032 1000016983 1000017311 1000018376 1000017310 1000020571 1000019036 1000018837 1000020474 1000019121 1000019172 1000020713 1000020597 1000020894 1000020897 1000020629 1000020962 1000014425 1000020971 1000020698 1000020986 1000019214 1000018564 1000020982 1000018249 1000020896 1000021296 1000020574 1000021486 1000019668 1000020831 1000022194 1000018888 1000018448 1000022325 1000022344 1000022394 1000017662 1000021015 1000022485 1000021400 1000021521 1000022611 1000017337 1000017299 1000020883 1000020625 1000018557 1000017446 1000022424 1000022723 1000016763 1000022944 1000017296 1000021543 1000016870 1000017267 1000021504 1000022574 1000017644 1000026599 1000027004 1000017580 1000018449 1000027428 1000017581 1000027551 1000027586 1000028949 1000028997 1000029507 1000029509 1000029514 1000029365 1000029918 1000029919 1000029921 1000029922 1000029923 1000029934 1000029936 1000029954 1000030063 1000030064 1000029840 1000032097 1000032099 1000032102 1000032103 1000032104 1000021302 1000032315 1000033667 1000033668 1000033669 1000033670 1000033671 1000033672 1000033673 1000033674 1000033675 1000033676 1000033677 1000033678 1000033679 1000033680 1000033681 1000033682 1000033683 1000033684 1000033685 1000033686 1000033687 1000033688 1000033689 1000033690 1000033691 1000033692 1000033693 1000033694 1000033695 1000033696 1000033697 1000033699 1000033700 1000033701 1000033702 1000033703 1000033704 1000033705 1000033706 1000033707 1000033708 1000033709 1000033711 1000033712 1000033713 1000033714 1000033715 1000033716 1000033717 1000033718 1000033719 1000033720 1000033721 1000033722 1000033723 1000033724 1000033725 1000033726 1000032076 1000034457 1000017292 1000036394 1000042266 1000042588 1000042607 1000042609 1000042628 1000042782 1000046486 1000046496 1000046499 1000046726 1000046859 1000047580 1000048561 1000049103 1000049146 1000049953 1000049954 1000052873 1000049369 1000046797 1000052931 1000052935 1000052941 1000053133 1000053184 1000052929 76326 ] |
|
102.91 ms (3.79%) |
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:
[
"66287-nettoyage-informatique-couleur-n-c-st-0610"
]
|
|
3.99 ms (0.15%) |
10 |
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" 76326 ] |
|
3.55 ms (0.13%) |
17 |
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:
[
"ourClientsAlsoBoughtMonths"
]
|
|
3.33 ms (0.12%) |
4 |
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:
[ 76326 7 ] |
|
3.03 ms (0.11%) |
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.57 ms (0.09%) |
5 |
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:
[ 76326 0 ] |
|
2.32 ms (0.09%) |
10 |
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"
]
|
|
2.05 ms (0.08%) |
5 |
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:
[
76326
]
|
|
1.72 ms (0.06%) |
11 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.59 ms (0.06%) |
5 |
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:
[ 76326 "C" ] |
|
1.34 ms (0.05%) |
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:
[ 76326 9963216 ] |
|
1.33 ms (0.05%) |
5 |
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:46:33" "%2%" 76326 ] |
|
0.84 ms (0.03%) |
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:
[
187385
]
|
|
0.81 ms (0.03%) |
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_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 36 162 163 164 165 166 167 168 166 76326 ] |
|
0.56 ms (0.02%) |
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:
[
"66287-nettoyage-informatique-couleur-n-c-st-0610"
]
|
|
0.37 ms (0.01%) |
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:
[
"66287-nettoyage-informatique-couleur-n-c-st-0610"
]
|
|
0.37 ms (0.01%) |
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 = ? AND c1_.is_display_site = ?
Parameters:
[ 76326 1 ] |
|
0.32 ms (0.01%) |
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:
[
187385
]
|
|
0.28 ms (0.01%) |
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.25 ms (0.01%) |
1 |
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 = ?
Parameters:
[
76326
]
|
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.