Query Metrics
234
Database Queries
25
Different statements
2396.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1580.17 ms (65.92%) |
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:
[ 96175 "2025-02-15 01:33:09" ] |
|
607.31 ms (25.34%) |
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:
[ 6339383 6339475 6339742 6339999 6340002 6340470 6337312 6343837 6336804 6345683 6346428 6346953 6347341 6347429 6348014 6348084 6348107 6348692 6349273 6349381 6349417 6349457 6349511 6349544 6349565 6349656 6349675 6349700 6349759 6350334 6350432 6350548 6351225 6351763 6351825 6352873 6353349 6354020 6346102 6354197 6354503 6354402 6355035 6344119 6337581 6355148 6355235 6355306 6355902 6355546 6356440 6356820 6356901 6357758 6356669 6358373 6358775 6359176 6359760 6359784 6345590 6357658 6360068 6360210 6360503 6360511 6360583 6360767 6360938 6361097 6357321 6361261 6361262 6361637 6361746 6361931 6362534 6362598 6362932 6363905 6364457 6365215 6365719 6366648 6366832 6359320 6368427 6368491 6368860 6368917 6369024 6369178 6369194 6369277 6369301 6369681 6369685 6370018 6370048 6370197 6370226 6370423 6370505 6370548 6370564 6370745 6370747 6370751 6370960 6370989 6371235 6371715 6372092 6372097 6372157 6373590 6373681 6373709 6373900 6363329 6340272 6374254 6374587 6375121 6375574 6377111 6377486 6375107 6358079 6377769 6377829 6378136 6378182 6378330 6375857 6378632 6380074 6380220 6381673 6381879 6381881 6382604 6380688 6383045 6383049 6384000 6384278 6384287 6385190 6385367 6385417 6378191 6386083 6386447 6386454 6386433 6387226 6387554 6389170 6389074 6391652 6391662 6391982 6392277 6392385 6392489 6392630 6392679 6392898 6375511 6392537 6393010 6393730 6393810 6393917 6394183 6394964 6395119 6395128 6395184 6395451 6395914 6396040 6396322 6396348 6396383 6396608 6396975 6397189 6397333 6397635 6397666 6397689 6398154 6398229 6398294 6398297 6398656 6398837 6398893 6399461 6400120 6400225 6400577 6401527 6401546 6403943 6404348 6404608 6405678 6406018 6406755 6407658 6407660 6408356 6408478 6408480 6409194 6409294 6410965 6411233 6411921 6412615 6413499 6414761 6414940 6415191 6415513 6415780 6416173 6416354 6416785 6416973 6417032 6417116 6417280 6417460 6418171 6418536 6419157 6419207 6419292 6419302 6419313 6419892 6420000 6420216 6420532 6420700 6421670 6421721 6422067 6422638 6422664 6422694 6422969 6423571 6424095 6424185 6424852 6424958 6425399 6426133 6426244 6426751 6426849 6427067 6427391 6427821 6428028 6428124 6428163 6428183 6428736 6429602 6429628 6429685 6429946 6430682 6430879 6430952 6431522 6431571 6431905 6431935 6432154 6432167 6433573 6434147 6434380 6434603 6434684 6435013 6435323 6435382 6435768 6435879 6435972 6436017 6437797 6438063 6438077 6438080 6438560 6439403 6439813 6439939 6439949 6440291 6440698 6440820 6440941 6441084 6441305 6441612 6442728 6442903 1000028721 6444960 6444965 6445375 6446143 6446611 6447260 6447279 6447310 6447646 6449544 6449927 6450181 6450442 6450592 6450594 6450637 6450760 6450791 6450977 6451083 6451104 6451106 6451167 6451172 6451188 6451305 6451381 6451393 6451398 6451461 6451581 6451634 6451657 6451770 6452064 6452216 6452348 6452423 6452434 6452451 6452536 6452544 6452614 6452830 6453518 6453659 6453732 6453913 6453994 6454176 6454284 6454554 6454557 6454608 6454722 6454777 6454786 6454860 6455053 6455234 6455334 6455543 6455549 6455561 6455636 6455686 6455696 6455762 6455867 6455932 6455995 6456078 6456208 6456682 6456704 6456752 6456789 6456791 6457205 6457349 6457431 6457453 6457530 6457720 6457758 6457862 6458246 6458359 6458489 6459503 6459564 6459752 6459930 6460372 6460524 6460966 6461276 6461641 6461668 6462367 6462364 6462859 6462968 6462973 6463551 6464307 6464604 6464748 6465347 6466390 6466695 6466976 6468020 6468671 6469136 6469165 6469236 6469264 6470259 6470268 6470277 6470526 6470558 6470790 6471436 6471527 6471781 1000000797 6394870 1000000976 1000002761 1000003830 1000004164 1000004166 1000001975 1000000889 1000005524 1000005848 1000005928 1000006801 1000006896 1000007128 1000007881 1000002561 1000008187 1000008557 1000005034 1000008877 6359372 1000009405 1000009684 1000009696 1000009762 1000009498 1000009436 1000009892 1000010326 1000008492 1000010774 1000011059 1000011826 1000009544 1000012294 1000012590 1000012739 1000012679 1000012765 1000012824 1000010278 1000003712 1000013408 6341943 1000013538 1000014418 1000014481 1000014576 1000014578 1000012822 1000012655 1000009229 1000015043 1000006152 1000014419 1000012761 1000014759 1000013469 1000016628 1000016853 1000016933 6363917 1000012374 1000007537 1000016036 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000017932 1000017933 1000017937 1000014377 1000016729 1000012578 1000019762 1000019763 1000019764 1000019765 1000019766 1000019767 1000019769 1000019770 1000019771 1000019772 1000019773 1000019774 1000019775 1000019776 1000019777 1000019778 1000019780 1000019781 1000019782 1000019783 1000019784 1000019785 1000019786 1000019787 1000019788 1000019789 1000019790 1000019791 1000019792 1000019793 1000019794 1000019795 1000019796 1000019797 1000019805 1000019844 1000019847 1000019849 1000019858 1000019903 1000019964 1000019965 1000019969 1000019971 1000017973 1000014659 1000016854 1000020808 1000020812 1000020843 1000014859 1000021401 1000021549 1000021994 1000021995 1000021996 1000021997 1000022008 1000022009 1000022010 1000022011 1000022382 1000022459 1000022478 1000009690 1000014211 1000025586 1000025589 1000025590 1000025591 1000025592 1000025627 1000025630 1000025668 1000025669 1000025670 1000025671 1000025672 1000025673 1000025674 1000025676 1000025678 1000025682 1000025760 1000025762 1000025764 1000025836 1000025841 1000025843 1000025846 1000025856 1000012484 1000026471 1000019972 1000023363 1000016699 1000027345 1000027348 1000013384 1000018257 1000028381 1000020015 1000028540 1000028643 1000028644 1000028478 1000028665 1000028666 6375487 1000030397 1000030801 1000030803 1000030836 1000030848 1000030850 1000030852 1000030865 1000007033 1000028651 1000031559 1000028382 1000017748 1000032252 1000032281 1000032308 1000032309 1000032310 1000032322 1000032323 1000032336 1000032370 1000032375 1000032378 1000032399 1000032403 1000032410 1000032413 1000032420 1000032432 1000032437 1000032443 1000032445 1000032501 1000032521 1000032603 1000032604 1000032710 1000032824 1000032826 1000012555 1000025885 1000021554 1000034792 1000002741 1000028674 1000036255 1000005828 1000036428 1000036432 1000037306 1000037575 1000037594 1000037595 1000037596 1000037597 1000037598 1000037599 1000037600 1000037601 1000017191 1000040045 1000040047 1000040048 1000040052 1000040897 1000040899 1000040901 1000040929 1000040945 1000041012 1000041580 1000041581 1000041583 1000042282 1000043031 1000043040 1000043244 1000043247 1000043249 1000043250 1000043251 1000043253 1000034845 1000043279 1000043443 1000044425 1000044443 1000040173 1000022845 1000045177 1000045182 1000045183 1000045184 1000045186 1000045188 1000045195 1000028791 1000045206 1000045310 1000045464 1000045685 1000045686 1000045687 1000045688 1000045689 1000045694 1000045695 1000045697 1000045782 1000021815 1000045834 1000046047 1000046176 1000046180 1000046186 1000046358 1000046502 1000041412 1000046764 1000047064 1000045172 1000017072 1000040096 1000043272 1000047717 1000047744 1000047805 1000030568 1000048012 1000048166 1000048364 1000048527 1000048530 1000048550 1000048684 1000048393 1000048278 1000048895 1000048357 1000049015 1000049032 1000001548 1000049408 1000049423 1000049425 1000049550 1000049780 1000049953 1000049954 1000049635 1000049835 1000049622 1000050274 1000012445 1000050161 1000050344 1000037091 1000047971 1000050935 1000048190 1000050987 1000050988 1000050989 1000050991 1000039012 1000044426 1000051358 1000051372 1000050746 1000049613 1000051496 1000051505 1000051517 1000051708 1000049870 1000051875 1000036959 1000051913 1000052110 1000051506 1000052407 1000052431 1000051960 1000052440 1000052465 1000045839 1000040058 1000040050 1000052677 1000052789 1000052837 1000052786 1000053024 1000053025 1000053027 1000053063 1000053078 1000053426 1000053468 1000053486 1000052812 1000053610 1000053616 1000052507 1000053699 1000053272 1000053771 1000053487 1000054028 1000054051 1000054087 1000054106 1000054150 1000054195 1000054221 1000054395 1000054467 1000053871 1000054555 1000054530 1000054634 1000054626 96175 ] |
|
149.35 ms (6.23%) |
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:
[
"75762-dateurs-noir-trodat-4810"
]
|
|
7.75 ms (0.32%) |
24 |
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" 96175 ] |
|
7.31 ms (0.30%) |
38 |
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"
]
|
|
5.15 ms (0.21%) |
24 |
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"
]
|
|
4.44 ms (0.19%) |
12 |
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:
[ 96175 0 ] |
|
4.34 ms (0.18%) |
26 |
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:
[
61
]
|
|
3.90 ms (0.16%) |
12 |
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:
[
96175
]
|
|
3.74 ms (0.16%) |
12 |
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:
[ 96175 "C" ] |
|
3.71 ms (0.15%) |
25 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
3.65 ms (0.15%) |
5 |
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:
[ 96175 7 ] |
|
3.46 ms (0.14%) |
11 |
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:
[ 96175 9963891 ] |
|
2.96 ms (0.12%) |
12 |
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-15 01:33:11" "%2%" 96175 ] |
|
2.31 ms (0.10%) |
11 |
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:
[
1603
]
|
|
1.94 ms (0.08%) |
9 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.width AS width_3, t0.height AS height_4, t0.max_nb_lines AS max_nb_lines_5, t0.date_height AS date_height_6, t0.type AS type_7, t0.sub_type AS sub_type_8, t0.product_id AS product_id_9 FROM rubber_stamp_custom t0 WHERE t0.product_id = ? LIMIT 1
Parameters:
[
1603
]
|
|
1.26 ms (0.05%) |
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:
[ 96175 1 ] |
|
1.15 ms (0.05%) |
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:
[
179254
]
|
|
0.73 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:
[ 61 295 296 297 298 299 300 301 295 96175 ] |
|
0.58 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:
[
"75762-dateurs-noir-trodat-4810"
]
|
|
0.48 ms (0.02%) |
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.37 ms (0.02%) |
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:
[
"75762-dateurs-noir-trodat-4810"
]
|
|
0.35 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:
[
2940
]
|
|
0.31 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:
[
96175
]
|
|
0.20 ms (0.01%) |
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:
[
179254
]
|
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.