Query Metrics
130
Database Queries
23
Different statements
1498.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
680.78 ms (45.43%) |
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:
[ 85320 "2025-02-13 05:28:48" ] |
|
623.08 ms (41.58%) |
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:
[ 6343061 6344112 6345882 6346068 6349257 6349370 6349512 6350050 6357966 6358230 6358928 6359309 6364027 6341834 6365047 6360884 6370284 6371598 6372300 6375358 6375476 6376195 6376749 6377112 6377874 6384047 6387267 6388530 6389516 6368973 6391179 6391234 6391365 6391377 6391444 6392298 6384712 6386793 6393687 6394067 6394096 6394022 6388974 6397098 6399160 6399467 6400222 6400742 6402000 6402794 6403129 6403372 6403623 6404991 6404992 6405408 6405912 6405935 6406482 6409981 6409982 6409983 6409984 6409985 6409986 6409987 6409988 6411719 6412095 6412157 6412162 6412728 6412823 6416116 6416781 6416805 6417089 6417432 6417579 6418318 6418711 6419215 6419994 6420856 6421974 6423558 6423559 6423561 6423562 6423563 6423564 6423565 6423566 6423567 6423942 6424052 6425095 6426199 6428557 6429135 6429631 6429680 6429779 6430729 6430730 6430731 6430732 6430733 6430880 6408052 6431782 6431793 6431869 6432222 6432227 6432334 6434288 6434384 6434404 6434484 6434876 6434917 6435466 6435945 6436449 6437042 6437075 6438026 6439266 6439946 6439962 6439975 6440370 6440558 6442084 6442136 6442151 6442165 6442208 6442255 6442571 6443320 6443757 6444089 6444311 6444333 6446160 6447150 6448224 6448235 6449778 6449879 6450424 6451129 6451239 6451349 6451631 6452108 6452193 6452418 6453154 6453476 6454657 6454677 6454690 6454855 6454865 6455238 6455257 6455267 6455326 6455700 6456025 6456116 6456357 6456873 6457209 6457228 6457539 6459222 6460679 6460724 6460726 6460727 6460728 6460729 6460730 6460731 6460732 6460733 6460734 6460735 6460736 6460737 6460738 6460739 6460740 6460741 6460742 6460743 6460744 6460745 6460746 6460747 6460748 6460749 6460750 6460751 6460752 6460753 6460754 6460755 6460756 6460757 6460758 6460759 6460760 6460761 6460762 6460763 6460765 6460767 6460768 6460769 6460770 6460771 6460772 6460773 6460774 6460775 6460776 6460777 6460778 6460779 6460780 6460781 6460782 6460783 6460784 6460785 6460786 6460787 6460788 6460789 6460790 6460791 6460793 6460794 6460795 6460796 6460797 6460798 6460799 6460800 6460912 6460999 6461039 6461401 6462667 6463281 6463282 6463283 6463284 6463285 6463286 6463287 6463288 6463289 6463290 6463291 6463292 6463293 6463294 6463295 6463296 6463297 6463298 6463299 6463300 6463301 6463354 6463355 6463356 6463358 6463359 6463360 6463361 6463362 6463363 6463364 6463365 6463366 6463367 6463368 6464466 6464796 6464841 6464845 6464896 6465933 6465935 6467161 6467816 6467908 6467909 6467910 6467911 6467912 6467913 6467914 6467915 6467916 6467917 6467918 6467920 6467921 6467922 6467924 6467925 6467930 6467931 6467932 6467933 6467934 6467935 6467936 6467937 6467938 6467939 6467940 6467941 6467942 6467943 6467944 6467945 6467946 6467947 6467948 6467949 6467950 6467951 1000001574 1000001638 1000001349 1000001981 1000002130 1000004874 1000006095 1000007591 1000002507 1000004822 1000010191 1000012011 1000012100 1000010193 1000012621 1000012503 1000014709 1000013648 1000015476 1000015886 1000015888 1000016480 1000017219 1000001816 1000017023 1000015386 1000019637 1000015124 1000016076 1000013979 1000015937 1000015117 1000012146 1000021652 1000021654 1000017611 1000016210 1000006074 1000022298 1000022303 1000022315 1000022345 1000022347 1000022355 1000022356 1000022658 1000022659 1000022997 1000023008 1000015535 1000023727 1000025086 1000026202 1000026216 1000026513 1000026673 1000026676 1000026833 1000027010 1000027011 1000027018 1000027054 1000027119 1000012775 1000028762 1000028778 1000028783 1000028821 1000028824 1000028864 1000028865 1000028866 1000028918 1000028979 1000028980 1000028981 1000029011 1000029012 1000029013 1000029014 1000029015 1000029016 1000029017 1000029018 1000029019 1000029020 1000029021 1000029022 1000029023 1000029024 1000029025 1000029027 1000029028 1000029029 1000029030 1000029031 1000029032 1000029033 1000029034 1000029035 1000029036 1000029037 1000029038 1000029039 1000029057 1000029058 1000029059 1000029060 1000029061 1000029062 1000029063 1000029064 1000029065 1000029066 1000029067 1000029068 1000029069 1000029070 1000016103 1000019640 1000029959 1000029962 1000029963 1000029964 1000029965 1000029966 1000029968 1000029969 1000029971 1000029972 1000029974 1000029975 1000029976 1000029978 1000029981 1000030071 1000030072 1000030073 1000030074 1000030075 1000030076 1000030077 1000030078 1000030079 1000030080 1000030081 1000030082 1000030083 1000030084 1000030086 1000030089 1000030137 1000030287 1000030288 1000030289 1000030293 1000030294 1000030295 1000030296 1000030297 1000030298 1000030299 1000030300 1000030301 1000030302 1000030303 1000030304 1000030305 1000030306 1000030307 1000030308 1000030309 1000030310 1000030311 1000030312 1000030313 1000030314 1000030315 1000030316 1000030317 1000030318 1000030319 1000030353 1000030354 1000030355 1000030357 1000030358 1000030488 1000030489 1000030490 1000030491 1000030492 1000030493 1000030494 1000030495 1000030496 1000030497 1000030498 1000030499 1000030500 1000030501 1000030502 1000030503 1000030504 1000030505 1000030506 1000030507 1000030508 1000030509 1000030510 1000030511 1000030512 1000030513 1000030514 1000030515 1000030516 1000030528 1000030529 1000030530 1000030531 1000030532 1000030533 1000030534 1000030535 1000030536 1000030537 1000030538 1000030539 1000030540 1000030541 1000030542 1000030543 1000030544 1000030546 1000030547 1000030548 1000030549 1000030550 1000030551 1000030552 1000030553 1000030554 1000030555 1000030556 1000030557 1000030558 1000030560 1000030561 1000030563 1000030564 1000030565 1000030566 1000030567 1000030569 1000030636 1000030638 1000030639 1000030640 1000030641 1000030643 1000030644 1000030645 1000030646 1000030647 1000030648 1000030649 1000030651 1000030665 1000030666 1000030667 1000030668 1000030670 1000030673 1000030680 1000030681 1000030683 1000030686 1000031115 1000031116 1000031117 1000031118 1000031119 1000031120 1000031121 1000031122 1000031123 1000031124 1000031125 1000031126 1000031127 1000031128 1000031129 1000031130 1000031131 1000031132 1000031133 1000031134 1000031135 1000031136 1000031137 1000031138 1000031139 1000031140 1000031141 1000031142 1000031158 1000031159 1000031160 1000031161 1000031162 1000031163 1000031164 1000031165 1000031166 1000031167 1000031168 1000031169 1000031170 1000031171 1000031172 1000031173 1000031174 1000031184 1000031185 1000031186 1000031187 1000031188 1000031189 1000031190 1000031191 1000031192 1000031193 1000031194 1000031195 1000031196 1000031197 1000031280 1000031281 1000031283 1000031284 1000031285 1000031286 1000031287 1000031288 1000031289 1000031290 1000031304 1000031305 1000031306 1000031307 1000031874 1000031917 1000031923 1000031943 1000031944 1000031945 1000031942 1000031952 1000031955 1000031966 1000031967 1000032092 1000032095 1000032191 1000032195 1000032199 1000032201 1000032205 1000032208 1000032287 1000032301 1000032303 1000032320 1000032330 1000032331 1000032346 1000032347 1000032349 1000032418 1000033037 1000033038 1000033041 1000033071 1000033072 1000033081 1000033092 1000033093 1000033120 1000033215 1000033222 1000033224 1000033226 1000033229 1000033244 1000034092 1000034180 1000034384 1000034401 1000034402 1000034744 1000034753 1000035021 1000035022 1000035023 1000035025 1000035026 1000035027 1000035028 1000035029 1000035030 1000035031 1000035032 1000035033 1000035034 1000035035 1000035036 1000035037 1000035038 1000035039 1000035040 1000035041 1000035042 1000035043 1000035044 1000035045 1000035046 1000035047 1000035048 1000035049 1000035050 1000035051 1000035052 1000035053 1000035054 1000035136 1000035137 1000035138 1000035143 1000035144 1000035147 1000035148 1000035149 1000035150 1000035512 1000035529 1000035535 1000035538 1000035539 1000035545 1000035547 1000035699 1000036111 1000036112 1000036113 1000036114 1000036115 1000036116 1000036117 1000036118 1000036119 1000036121 1000036122 1000036124 1000036125 1000036132 1000036133 1000036134 1000036135 1000036136 1000036137 1000036140 1000035153 1000036669 1000036670 1000036672 1000036673 1000036674 1000036675 1000036680 1000036684 1000036704 1000036705 1000036706 1000036708 1000036709 1000036710 1000036711 1000036712 1000036713 1000036715 1000036716 1000036717 1000036719 1000036724 1000036726 1000036727 1000036728 1000036729 1000036730 1000036731 1000036732 1000036739 1000036743 1000036746 1000036943 1000036945 1000036950 1000036951 1000036957 1000036958 1000036960 1000037196 1000037197 1000037198 1000037199 1000037200 1000037201 1000037202 1000037203 1000037204 1000037205 1000037206 1000037207 1000037208 1000037209 1000037210 1000037211 1000037212 1000037213 1000037282 1000037284 1000037290 1000037292 1000037578 1000037583 1000037591 1000037605 1000037606 1000037616 1000037618 1000037619 1000037645 1000038191 1000035441 1000040130 1000040439 1000040440 1000040441 1000040442 1000040443 1000040444 1000040445 1000040448 1000040449 1000040450 1000040451 1000040452 1000040455 1000040456 1000040458 1000040460 1000040461 1000040466 1000040503 1000040504 1000040505 1000040506 1000040507 1000040508 1000040509 1000040510 1000040511 1000040512 1000040513 1000040514 1000040515 1000040516 1000040519 1000040520 1000040521 1000040522 1000040523 1000040535 1000041032 1000041038 1000041041 1000041042 1000041069 1000041070 1000041071 1000041072 1000041077 1000041078 1000041079 1000041081 1000041087 1000041089 1000041091 1000041111 1000041667 1000041668 1000041669 1000041670 1000041671 1000041672 1000041673 1000041674 1000041675 1000041676 1000041677 1000041678 1000041679 1000041680 1000041681 1000041682 1000041683 1000041684 1000041685 1000041716 1000042220 1000042222 1000042250 1000042251 1000042486 1000042497 1000042528 1000034960 1000042841 1000042842 1000042843 1000042845 1000042847 1000042848 1000042852 1000042854 1000042857 1000042858 1000042860 1000042861 1000042862 1000041721 1000043683 1000043684 1000043685 1000043686 1000043689 1000043690 1000043691 1000043692 1000043693 1000043694 1000043695 1000043696 1000043697 1000043698 1000043700 1000043701 1000043702 1000043703 1000043704 1000043707 1000043708 1000043709 1000043710 1000043711 1000043712 1000043713 1000043717 1000043718 1000043719 1000043720 1000044151 1000044152 1000044155 1000044163 1000044164 1000044166 1000044167 1000044168 1000044169 1000044170 1000044171 1000044172 1000044173 1000044174 1000044176 1000044178 1000044185 1000044186 1000044187 1000044189 1000044190 1000044193 1000044194 1000044196 1000044206 1000044208 1000044209 1000044243 1000044244 1000044245 1000044246 1000044247 1000044248 1000044249 1000044259 1000044260 1000044261 1000044262 1000044263 1000044264 1000044265 1000044266 1000044268 1000044271 1000044272 1000044273 1000044274 1000044276 1000044277 1000044278 1000044279 1000044373 1000044374 1000044375 1000044377 1000044378 1000044379 1000044381 1000044489 1000044490 1000044491 1000044524 1000044525 1000044533 1000044540 1000044552 1000044555 1000044556 1000044558 1000044559 1000044579 1000045543 1000045544 1000045545 1000045546 1000045547 1000045548 1000045549 1000045550 1000045551 1000045552 1000045553 1000045554 1000045555 1000045556 1000045557 1000045558 1000045559 1000045560 1000045561 1000045589 1000045590 1000045591 1000045592 1000045593 1000045594 1000045595 1000045596 1000045597 1000045598 1000045599 1000045600 1000045601 1000045602 1000045603 1000045604 1000045605 1000045606 1000045609 1000045722 1000045723 1000045726 1000046217 1000014614 1000047168 1000047171 1000047172 1000047174 1000047175 1000047176 1000047179 1000047180 1000047181 1000047182 1000047183 1000047184 1000047185 1000047186 1000047191 1000047193 1000047194 1000047195 1000047197 1000047198 1000047200 1000047201 1000047202 1000047204 1000047205 1000047206 1000047207 1000047208 1000047210 1000047213 1000033122 1000047547 1000029001 1000044583 1000048091 1000048274 1000048275 1000048292 1000048298 1000048312 1000047196 1000022457 1000019114 1000048499 1000048635 1000048539 1000048849 1000019184 1000048936 1000048937 1000048947 1000048967 1000048995 1000048827 1000049388 1000049530 1000049967 1000049968 1000013231 1000050065 1000050452 1000050637 1000050828 1000050881 1000051089 1000051117 1000051128 1000051130 1000051132 1000051133 1000051733 1000051816 1000051837 1000051903 1000051948 1000051249 1000047926 1000052138 1000052241 1000051461 1000048930 1000052352 1000052353 1000052358 1000052359 1000052385 1000048167 1000052454 1000052458 1000052783 1000052807 1000052802 1000053115 1000053346 85320 ] |
|
158.59 ms (10.58%) |
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:
[
"70212-protege-documents-et-press-book-rouge-n-c-400-050-640"
]
|
|
6.56 ms (0.44%) |
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.price_id = ? AND t0.product_id = ? LIMIT 1
Parameters:
[ "CAISSE2011" 85320 ] |
|
3.77 ms (0.25%) |
20 |
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.55 ms (0.24%) |
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:
[ 85320 7 ] |
|
2.84 ms (0.19%) |
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.79 ms (0.19%) |
6 |
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:
[
85320
]
|
|
2.72 ms (0.18%) |
6 |
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:
[ 85320 0 ] |
|
2.48 ms (0.17%) |
12 |
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.90 ms (0.13%) |
13 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
1.72 ms (0.11%) |
6 |
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:
[ 85320 "C" ] |
|
1.43 ms (0.10%) |
6 |
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-13 05:28:49" "%2%" 85320 ] |
|
1.10 ms (0.07%) |
6 |
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:
[
197779
]
|
|
0.94 ms (0.06%) |
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:
[ 85320 9963476 ] |
|
0.91 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.discount AS discount_4, t0.product_id AS product_id_5 FROM promotion t0 WHERE t0.product_id = ?
Parameters:
[
28694
]
|
|
0.75 ms (0.05%) |
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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
52440
]
|
|
0.64 ms (0.04%) |
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:
[ 52 245 246 247 248 247 85320 ] |
|
0.54 ms (0.04%) |
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:
[
"70212-protege-documents-et-press-book-rouge-n-c-400-050-640"
]
|
|
0.41 ms (0.03%) |
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.40 ms (0.03%) |
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:
[
"70212-protege-documents-et-press-book-rouge-n-c-400-050-640"
]
|
|
0.38 ms (0.03%) |
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:
[ 85320 1 ] |
|
0.26 ms (0.02%) |
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:
[
85320
]
|
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.