Query Metrics
112
Database Queries
23
Different statements
848.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
416.72 ms (49.11%) |
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:
[ 6334341 6334192 6338112 6338471 6338729 6339402 6337635 6342088 6346040 6346198 6346607 6347110 6348656 6350595 6353187 6354260 6354940 6354270 6355858 6356966 6358047 6358230 6358765 6360941 6360917 6361249 6361560 6361778 6362011 6364027 6358561 6365168 6366411 6366846 6369306 6369318 6369346 6369508 6369831 6370674 6371064 6371156 6373239 6373740 6374728 6383357 6383479 6383875 6383949 6385860 6385866 6386258 6384445 6386594 6388674 6388886 6367756 6392207 6392693 6393005 6395062 6395267 6396729 6396839 6396970 6400138 6400236 6402073 6402094 6402247 6403594 6407648 6409452 6410133 6410719 6411248 6411273 6411363 6411502 6412925 6415477 6415652 6416077 6416415 6417089 6417970 6418233 6419024 6419154 6420304 6423120 6423670 6423779 6425405 6426195 6426350 6428787 6429225 6430128 6430552 6431459 6435404 6435459 6439256 6443119 6448772 6449713 6449843 6450118 6450804 6451129 6451439 6451594 6452616 6452802 6452976 6453618 6454861 6455390 6455487 6455698 6456203 6459205 6465652 1000001883 6390346 1000002780 1000002786 1000003942 1000007157 1000007158 1000006864 1000009516 1000011956 1000012054 1000013158 1000010199 1000014402 1000012619 1000001135 1000015619 1000009692 1000016031 1000016083 1000016085 1000017773 1000017774 1000017775 1000017777 1000017779 1000017780 1000017781 1000017782 1000017783 1000017784 1000017785 1000017786 1000017787 1000017788 1000017789 1000017790 1000017791 1000017792 1000017793 1000017794 1000017795 1000017796 1000017797 1000017798 1000017799 1000017800 1000017801 1000017802 1000017803 1000017997 1000017998 1000017999 1000018000 1000018001 1000018002 1000018003 1000018005 1000018006 1000018007 1000018008 1000018009 1000018010 1000018011 1000018012 1000018013 1000018014 1000018015 1000018016 1000018017 1000018018 1000018019 1000018020 1000018021 1000018022 1000018023 1000018024 1000018025 1000018026 1000018225 1000018226 1000018227 1000018229 1000018230 1000018231 1000018232 1000018233 1000018234 1000016434 1000020874 1000010671 1000023106 1000023107 1000023108 1000023109 1000023110 1000023111 1000023112 1000023113 1000023114 1000023115 1000023116 1000023117 1000023118 1000023119 1000023120 1000023121 1000023122 1000023123 1000023124 1000023125 1000023126 1000023127 1000023128 1000023129 1000023130 1000023131 1000023132 1000023133 1000023134 1000023135 1000023136 1000023137 1000023138 1000023139 1000023140 1000023141 1000023142 1000023143 1000023144 1000023145 1000023146 1000023147 1000023148 1000023149 1000023150 1000023151 1000023152 1000023156 1000023521 1000023522 1000023523 1000023524 1000023525 1000023526 1000023527 1000023528 1000023529 1000023530 1000023531 1000023532 1000023533 1000023534 1000023535 1000023536 1000023537 1000023538 1000023539 1000023540 1000023541 1000023542 1000023543 1000023792 1000023793 1000026023 1000026025 1000026026 1000026027 1000026028 1000026029 1000026030 1000026031 1000026032 1000026033 1000026034 1000026035 1000026036 1000026085 1000026086 1000026087 1000026088 1000021047 1000026779 1000026780 1000026781 1000027200 1000027204 1000027218 1000027219 1000027220 1000027221 1000027233 1000027234 1000027235 1000027236 1000027237 1000027238 1000027239 1000027241 1000027243 1000027244 1000027245 1000027246 1000027247 1000027248 1000027249 1000027908 1000027910 1000027914 1000027915 1000027924 1000027928 1000027930 1000027932 1000027933 1000027934 1000027935 1000027937 1000027938 1000027939 1000027940 1000027941 1000027942 1000027943 1000027944 1000027945 1000027946 1000027947 1000027948 1000027950 1000027951 1000027952 1000027954 1000027955 1000027956 1000027957 1000027958 1000028861 1000028863 1000028867 1000028868 1000029488 1000029545 1000029548 1000029549 1000029550 1000029631 1000029666 1000029667 1000029674 1000029677 1000029678 1000029679 1000029680 1000029682 1000029704 1000029723 1000029734 1000029747 1000029751 1000029755 1000029774 1000029775 1000029776 1000029790 1000029791 1000029799 1000029812 1000029813 1000029814 1000029821 1000030435 1000030436 1000030437 1000030438 1000030439 1000030440 1000030441 1000030444 1000030446 1000030448 1000030452 1000030453 1000030454 1000030455 1000030456 1000030457 1000030458 1000030459 1000030462 1000030463 1000030469 1000030470 1000030471 1000030472 1000030473 1000030474 1000030475 1000030476 1000030477 1000030478 1000030479 1000030480 1000030483 1000030814 1000030818 1000030833 1000030843 1000030864 1000031334 1000031335 1000031336 1000031337 1000031338 1000031339 1000031340 1000031341 1000031342 1000031343 1000031344 1000031345 1000031347 1000031348 1000031349 1000031350 1000031890 1000031891 1000033217 1000033220 1000033749 1000033750 1000033751 1000033842 1000033843 1000033844 1000033845 1000033846 1000033847 1000033848 1000033849 1000033850 1000033865 1000033867 1000033895 1000033900 1000033901 1000033902 1000033903 1000033904 1000033906 1000033907 1000033908 1000033909 1000033910 1000033911 1000033912 1000033913 1000033914 1000033915 1000033916 1000033917 1000033918 1000033919 1000033920 1000033921 1000033922 1000033925 1000033926 1000033928 1000033931 1000033932 1000033933 1000033934 1000033935 1000033936 1000033937 1000033938 1000033939 1000033940 1000033941 1000033942 1000033943 1000033944 1000033945 1000033946 1000033947 1000033948 1000034460 1000034461 1000034837 1000034838 1000034839 1000034841 1000034843 1000034844 1000034892 1000034893 1000034894 1000034895 1000034896 1000034898 1000035157 1000035158 1000035159 1000035160 1000035161 1000035162 1000035163 1000035164 1000035165 1000035166 1000035167 1000035168 1000035169 1000035170 1000035171 1000035172 1000035173 1000035174 1000035175 1000035176 1000035177 1000035178 1000035179 1000035180 1000035181 1000035182 1000035183 1000035184 1000035185 1000035186 1000035187 1000035188 1000035189 1000035190 1000035191 1000035192 1000035193 1000035194 1000035195 1000035196 1000035197 1000035198 1000035199 1000035200 1000035209 1000035210 1000035211 1000035212 1000035213 1000035214 1000035215 1000035217 1000035219 1000035220 1000035221 1000035222 1000035223 1000036193 1000037130 1000037133 1000037134 1000037135 1000037136 1000037137 1000037139 1000037140 1000037141 1000037142 1000037143 1000037144 1000037145 1000037146 1000037147 1000037149 1000037150 1000037151 1000037152 1000037153 1000037154 1000037155 1000037156 1000039738 1000039740 1000040533 1000040537 1000040539 1000040541 1000040561 1000040562 1000040563 1000040564 1000040566 1000040567 1000040568 1000040569 1000040570 1000040571 1000040572 1000040573 1000040574 1000040575 1000040576 1000040577 1000040578 1000040579 1000040580 1000040581 1000040582 1000040583 1000040584 1000040585 1000040586 1000040587 1000040588 1000040590 1000040591 1000040592 1000040593 1000040594 1000040595 1000040596 1000040597 1000040598 1000040599 1000040600 1000040601 1000040602 1000040603 1000040604 1000040605 1000040606 1000040607 1000040608 1000040609 1000040610 1000040611 1000040612 1000040613 1000040614 1000040615 1000040616 1000040617 1000040618 1000040619 1000040620 1000040621 1000040622 1000040623 1000040624 1000040625 1000040626 1000040627 1000040628 1000040629 1000040630 1000040631 1000040632 1000040633 1000040634 1000040635 1000040636 1000040637 1000040638 1000040639 1000040640 1000040641 1000040642 1000040643 1000040644 1000040645 1000040646 1000040647 1000040648 1000040649 1000040650 1000040651 1000040652 1000040653 1000040654 1000040655 1000040656 1000040657 1000040658 1000040659 1000040660 1000040661 1000040662 1000040663 1000040664 1000040665 1000040666 1000040667 1000040668 1000040669 1000040671 1000040672 1000040673 1000040674 1000040675 1000040676 1000040677 1000040678 1000040679 1000040681 1000040682 1000040683 1000040684 1000040685 1000040686 1000040687 1000040688 1000040689 1000040690 1000040691 1000040692 1000040693 1000040694 1000040695 1000040696 1000040697 1000040698 1000040699 1000040700 1000040701 1000040702 1000040703 1000040720 1000040726 1000040729 1000040731 1000040733 1000040814 1000040841 1000040842 1000040844 1000040846 1000040847 1000040854 1000040855 1000043321 1000043322 1000043327 1000043331 1000043335 1000043340 1000043343 1000044684 1000044685 1000044688 1000044690 1000044691 1000044693 1000044694 1000044696 1000044698 1000044699 1000044700 1000044701 1000044702 1000044705 1000044706 1000044707 1000044708 1000044709 1000044710 1000045023 1000045067 1000045069 1000045071 1000045073 1000045075 1000045076 1000045078 1000045079 1000045085 1000045086 1000045106 1000046641 1000046642 1000046643 1000047072 1000047073 1000047074 1000047075 1000047076 1000047077 1000047078 1000047079 1000047080 1000047081 1000047082 1000047083 1000047084 1000047085 1000047086 1000047087 1000047088 1000047089 1000047090 1000047091 1000047092 1000047093 1000047094 1000047095 1000047096 1000047097 1000047098 1000047099 1000047100 1000047101 1000047102 1000047103 1000047104 1000047105 1000047106 1000047107 1000047108 1000047109 1000047110 1000047111 1000047112 1000047113 1000047114 1000047115 1000047116 1000047302 1000047303 1000047304 1000047305 1000047306 1000047307 1000047308 1000047309 1000047310 1000047311 1000047312 1000047313 1000047314 1000047315 1000047316 1000047317 1000047318 1000047319 1000047320 1000047321 1000047322 1000047323 1000047324 1000047833 1000049866 1000051618 1000051621 1000052088 95965 ] |
|
272.28 ms (32.09%) |
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:
[ 95965 "2025-02-12 09:18:28" ] |
|
119.07 ms (14.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, 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:
[
"74677-recharges-noir-pilot-bls-fr7-b-s3"
]
|
|
5.06 ms (0.60%) |
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:
[ 95965 1 ] |
|
4.81 ms (0.57%) |
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" 95965 ] |
|
3.88 ms (0.46%) |
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.39 ms (0.40%) |
3 |
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:
[ 95965 7 ] |
|
3.02 ms (0.36%) |
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.77 ms (0.33%) |
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.reference IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "65383" "65384" "65385" "65386" "65387" "65388" "74674" "74675" "80675" "80676" "74676" "74678" "74679" "74680" "74681" "74682" "74683" "80677" "80678" "78475" "78476" "78477" ] |
|
2.53 ms (0.30%) |
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.15 ms (0.25%) |
11 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.94 ms (0.23%) |
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:
[ 95965 0 ] |
|
1.86 ms (0.22%) |
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:
[ 95965 "C" ] |
|
1.71 ms (0.20%) |
5 |
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:
[ 95965 9963771 ] |
|
1.51 ms (0.18%) |
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 09:18:28" "%2%" 95965 ] |
|
1.37 ms (0.16%) |
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:
[
95965
]
|
|
0.96 ms (0.11%) |
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:
[
74378
]
|
|
0.95 ms (0.11%) |
4 |
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:
[
197942
]
|
|
0.76 ms (0.09%) |
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:
[ 60 287 288 289 290 291 292 293 294 289 95965 ] |
|
0.57 ms (0.07%) |
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:
[
"74677-recharges-noir-pilot-bls-fr7-b-s3"
]
|
|
0.50 ms (0.06%) |
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.38 ms (0.04%) |
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:
[
95965
]
|
|
0.34 ms (0.04%) |
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:
[
"74677-recharges-noir-pilot-bls-fr7-b-s3"
]
|
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.