Query Metrics
45
Database Queries
20
Different statements
2934.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1524.03 ms (51.93%) |
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:
[ 3337 "2025-02-12 11:25:23" ] |
|
1243.73 ms (42.38%) |
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:
[ 6333035 6335392 6334341 6337717 6337804 6336142 6338732 6333377 6339023 6339276 6338153 6339402 6339563 6339625 6339626 6335613 6339731 6339809 6339292 6340063 6340100 6340194 6340459 6340507 6340527 6340385 6326077 6322449 6322471 6323815 6333956 6340818 6341013 6341037 6341047 6341068 6341113 6341118 6341122 6341195 6341256 6341986 6342540 6343288 6343501 6343607 6344641 6344952 6345859 6346074 6346575 6346655 6346662 6346692 6346879 6346881 6347081 6347093 6347110 6347397 6347688 6347856 6348002 6348042 6348049 6348059 6348160 6348192 6348194 6348240 6348253 6348262 6348268 6348291 6348381 6348389 6348415 6348504 6348512 6348539 6348745 6348769 6349016 6349188 6349189 6349280 6349290 6349309 6349446 6349723 6349765 6349930 6349944 6349980 6349995 6350036 6350055 6350158 6350220 6350248 6350251 6350268 6350324 6350397 6350398 6350407 6350459 6350473 6350496 6350498 6350558 6334884 6351067 6351377 6351597 6351657 6351851 6351998 6352116 6345875 6352291 6352308 6352830 6352953 6353254 6354014 6354082 6354155 6354444 6354461 6354560 6354588 6354591 6354819 6355149 6355504 6352092 6355895 6356001 6356176 6356224 6356265 6356721 6356896 6357083 6357236 6357453 6357487 6357360 6358302 6358377 6359280 6359439 6360208 6360283 6360229 6361374 6362214 6362378 6338342 6363076 6334636 6363891 6363154 6364051 6364253 6364325 6364332 6364513 6343169 6357398 6365220 6365243 6362760 6365657 6366016 6366082 6366467 6366633 6366788 6367348 6367369 6368128 6368336 6368221 6368296 6368313 6368845 6368877 6368913 6369202 6369313 6369325 6369329 6369492 6369622 6369745 6369917 6369983 6370021 6370157 6370172 6370187 6370249 6370523 6371043 6371088 6371127 6371149 6371217 6371260 6371544 6371925 6372072 6372075 6372697 6372700 6372777 6372958 6373030 6373188 6373490 6373574 6373582 6373593 6373963 6368338 6368835 6368886 6373990 6368208 6368957 6373987 6374215 6374268 6368865 6368726 6374382 6374383 6374400 6374355 6368699 6368928 6368966 6374237 6368507 6374695 6374854 6374911 6368397 6368399 6368772 6368965 6374282 6375012 6375047 6375156 6375286 6368422 6368515 6375308 6374091 6375346 6375373 6375390 6375399 6375423 6368926 6375067 6368191 6374706 6375514 6375674 6375691 6376049 6376060 6376169 6376256 6376259 6375830 6376420 6376423 6376487 6374616 6376133 6376777 6376558 6376749 6376955 6377280 6377332 6377374 6377428 6375020 6377455 6368582 6376284 6377757 6362348 6376632 6377874 6377931 6377935 6378087 6378112 6378603 6378633 6378710 6378992 6379071 6379114 6379149 6379419 6379420 6379534 6379792 6379820 6379915 6380323 6380414 6380464 6377655 6380961 6381050 6381053 6373853 6381482 6381637 6381705 6382201 6382689 6383417 6383496 6382480 6383806 6383845 6384013 6382777 6385042 6385469 6385507 6380453 6383123 6386127 6386368 6386374 6386700 6385013 6386797 6382407 6361846 6386908 6387047 6387069 6387525 6387726 6387737 6387891 6388145 6386755 6388809 6389129 6375307 6389529 6389581 6389699 6389826 6390149 6390558 6390596 6391099 6391289 6388248 6391542 6391597 6391688 6391815 6386405 6391920 6392080 6392086 6392145 6392283 6392550 6390654 6393144 6393447 6393464 6393574 6393751 6393874 6394065 6394096 6394196 6394405 6394680 6394992 6395447 6395466 6395764 6395871 6395971 6396113 6396377 6396473 6396629 6396630 6396639 6396674 6396812 6396834 6396859 6396860 6396867 6396887 6396899 6396917 6396926 6396969 6397007 6397098 6397121 6397185 6397189 6397215 6397281 6397296 6397367 6397375 6397378 6397409 6397441 6397477 6397483 6397540 6397545 6397565 6397682 6397684 6397756 6397821 6397822 6397958 6398037 6398067 6398069 6398072 6398074 6398660 6398737 6398797 6398861 6398879 6398882 6399142 6399230 6399239 6399264 6399275 6399278 6399305 6399311 6399400 6399528 6399590 6399981 6400013 6400024 6400114 6400116 6400222 6400449 6401526 6401548 6401671 6401968 6401977 6402134 6402306 6402422 6402421 6402509 6402543 6403169 6403667 6403850 6403865 6404393 6404596 6404885 6404890 6405001 6405468 6406313 6406708 6406977 6407343 6407635 6407721 6407947 6408069 6408361 6408685 6408706 6409257 6409340 6409493 6409629 6410095 6410218 6410412 6410548 6410776 6410893 6410965 6411053 6411224 6411285 6412140 6412868 6413313 6413813 6413840 6414159 6414396 6414928 6414968 6414970 6415048 6415649 6415668 6415674 6415678 6415727 6415939 6416018 6416105 6416119 6416367 6416378 6416389 6416839 6416885 6416953 6416963 6417068 6417089 6417265 6417277 6417429 6417579 6417602 6417630 6417694 6417827 6417829 6417897 6418009 6418055 6418161 6418752 6418839 6418887 6418893 6419109 6419240 6419299 6419867 6419967 6420099 6420151 6420441 6420459 6420480 6420489 6420541 6420903 6421087 6421504 6421695 6421745 6421777 6422210 6422642 6422677 6423135 6423736 6424795 6425074 6425086 6425444 6425721 6425921 6426116 6426129 6426221 6426265 6426270 6426287 6426319 6426615 6426756 6426823 6427029 6427192 6427203 6427270 6427338 6427390 6427708 6427711 6427837 6427869 6427890 6427923 6427964 6427980 6428000 6428199 6428395 6428424 6428699 6428711 6428791 6428793 6428909 6428984 6429279 6429460 6429483 6429647 6429688 6429803 6430050 6430285 6430435 6430438 6430629 6430683 6430843 6430908 6430929 6431100 6431140 6431250 6431467 6431305 6431815 6431860 6431975 6432140 6432215 6432267 6432352 6433398 6433821 6434266 6434474 6434589 6434696 6434700 6434699 6434712 6434743 6434828 6435011 6435194 6435220 6435272 6435352 6435457 6435461 6435630 6435879 6435949 6435963 6436000 6436236 6437121 6438014 6438721 6439045 6439594 6439616 6439690 6440049 6440134 6440698 6440860 6440883 6441052 6441128 6441208 6441250 6441468 6441612 6441969 6442008 6442221 6442755 6442846 6443135 6443356 6443727 6444203 6444772 6446146 6446274 6446521 6446612 6446805 6446801 6446975 6447298 6447673 6447744 6448858 6448936 6449642 6450135 6450174 6450175 6450286 6450343 6450424 6450468 6450698 6450791 6450843 6451009 6451195 6451228 6451283 6451287 6451352 6451392 6451461 6451518 6451621 6451825 6451858 6451922 6452118 6452246 6452247 6452380 6452610 6452614 6452659 6452698 6452813 6452815 6452816 6452847 6452880 6452985 6452988 6453031 6453035 6453044 6453052 6453055 6453057 6453085 6453086 6453116 6453132 6453148 6453152 6453211 6453342 6453382 6453447 6453586 6453600 6453603 6453617 6453621 6453689 6453698 6453750 6453794 6454057 6454080 6454081 6454084 6454085 6454087 6454130 6454153 6454195 6454209 6454290 6454291 6454431 6454468 6454582 6454687 6454769 6454887 6454926 6454982 6455048 6455053 6455067 6455145 6455307 6455349 6455379 6455389 6455466 6455672 6455925 6456017 6456100 6456206 6456371 6456379 6456385 6456467 6456506 6456507 6456514 6456563 6456694 6456703 6456718 6456721 6456745 6456746 6456750 6456784 6456815 6456816 6456834 6457009 6457205 6457227 6457262 6457345 6457442 6457447 6457450 6457452 6457650 6457759 6458333 6458523 6458973 6458990 6459230 6459472 6459579 6459763 6459974 6460011 6460021 6460258 6460952 6461072 6461262 6461323 6461869 6461881 6462284 6462942 6463021 6463482 6463559 6463729 6463789 6464031 6464290 6464330 6464399 6464413 6464448 6464498 6466576 6466623 6467091 6467438 6467565 6468673 6469026 1000001156 6393349 1000001415 6393680 6383786 6388304 1000002467 1000002470 1000003607 1000001157 1000004227 1000004229 1000000736 1000004315 1000005431 1000005504 1000005426 1000005801 1000006762 1000001362 1000007555 1000007606 1000007241 1000004733 1000007696 1000008041 1000008046 1000008047 1000008087 1000008090 1000008119 1000008187 1000007297 1000004815 1000009140 1000009220 1000009236 1000008887 1000009532 1000009640 1000010048 1000005503 1000001857 1000009474 1000008856 1000007492 1000010330 1000007920 1000010736 1000010549 1000010833 1000010924 1000011972 1000011983 1000008484 1000012535 1000012562 1000012563 1000012853 1000013311 1000013504 1000004777 1000013902 1000010624 1000014018 1000014197 1000014203 1000014214 1000013905 1000006150 1000014524 1000014710 1000013741 1000014975 1000014976 1000014985 1000007381 1000009163 1000015331 1000015397 1000015408 1000015496 1000012979 1000015761 1000010933 1000011898 1000014841 1000015895 1000015903 1000015957 1000012485 1000015960 1000016009 1000016174 1000016679 1000016779 1000016793 1000017019 1000017157 1000017268 1000017280 1000017283 1000017330 1000017411 1000017312 1000017305 1000017485 1000017495 1000017502 1000012264 1000017479 1000017352 1000016788 1000017338 1000017659 1000017660 1000017680 1000017682 1000017689 1000017707 1000017709 1000017710 1000017712 1000017733 1000017739 1000017746 1000013331 1000015121 1000017372 1000016845 1000013361 1000015239 1000018759 1000018605 1000018662 1000018707 1000018907 1000019212 1000019248 1000016781 1000012837 1000014390 1000017619 1000020346 1000020348 1000020349 1000020350 1000020352 1000020353 1000016983 1000019018 1000019036 1000018837 1000020804 1000020849 1000020971 1000021202 1000021204 1000021205 1000021218 1000021219 1000021227 1000021248 1000021251 1000021252 1000021258 1000021300 1000016290 1000021304 1000021324 1000012947 1000019214 1000018249 1000020896 1000018527 1000021117 1000017335 1000021686 1000021889 1000021981 1000002172 1000022066 1000022325 1000022344 1000022394 1000021015 1000022485 1000022307 1000021400 1000022611 1000022099 1000022713 1000022715 1000022718 1000020453 1000023555 1000023568 1000021543 1000017267 1000023682 1000023683 1000023687 1000024030 1000021504 1000024305 1000024306 1000024307 1000024363 1000024369 1000024370 1000018050 1000025271 1000025308 1000025311 1000025312 1000025586 1000025589 1000025590 1000025591 1000025592 1000025627 1000025630 1000025668 1000025669 1000025670 1000025671 1000025672 1000025673 1000025674 1000025676 1000025678 1000025682 1000025760 1000025762 1000025764 1000015201 1000022068 1000017401 1000026501 1000021982 1000016102 1000023091 1000026848 1000021333 1000026888 1000027004 1000027262 1000027428 1000027551 1000018257 6376174 1000028951 1000028952 1000028953 1000028955 1000028957 1000028997 1000013181 1000027051 1000029361 1000029491 1000020577 1000029528 1000013946 1000029848 1000029849 1000029853 6382786 1000029852 1000029921 1000029954 1000029932 1000030052 1000030112 1000030120 1000022840 1000030691 1000030692 1000030834 1000030926 1000030927 1000031179 1000031257 1000031528 1000031529 1000017748 1000030725 1000031781 1000032028 1000032097 1000032099 1000032102 1000032103 1000032104 1000031873 1000031448 1000016821 1000032601 1000033667 1000033668 1000033669 1000026315 1000034024 1000034025 1000021719 1000034345 1000034349 1000034596 1000032242 1000024137 1000035719 1000035725 1000029889 1000038142 1000038153 1000038411 1000039408 1000039411 1000039558 1000039573 1000039579 1000039621 1000018340 1000041015 1000041016 1000041017 1000041019 1000041020 1000041021 1000041022 1000041027 1000041395 1000041438 1000041475 1000018854 1000041760 1000041761 1000041762 1000041766 1000041793 1000034487 1000022240 1000029441 1000042612 1000042613 1000042626 1000042627 1000041849 1000043293 1000043294 1000043332 1000043333 1000043337 1000044343 1000044349 1000044353 1000044356 1000044358 1000044376 1000044389 1000044396 1000044400 1000044487 1000044534 1000038566 1000044828 1000044832 1000044836 1000044895 1000044899 1000044900 1000044901 1000044902 1000044911 1000044933 1000044945 1000039739 1000045040 1000045043 1000045045 1000045056 1000045061 1000045077 1000045080 1000045161 1000045246 1000045260 1000045262 1000045264 1000045278 1000045279 1000045280 1000045510 1000045520 1000045521 1000045526 1000045529 1000045534 1000045611 1000045613 1000045624 1000045625 1000045626 1000045628 1000045632 1000045635 1000045282 1000045944 1000045945 1000045955 1000046058 1000046144 1000046343 1000046658 1000046876 1000047065 1000047066 1000047067 1000047068 1000047069 1000047070 1000047071 1000047339 1000047341 1000047357 1000047361 1000047367 1000047372 1000047978 1000047979 1000047985 1000047990 1000048004 1000048045 1000047132 1000048237 1000048238 1000048249 1000048304 1000048313 1000048315 1000048316 1000048356 1000048561 1000048775 1000048846 1000047991 1000048983 1000049031 1000014925 1000049127 1000049054 1000048211 1000049232 1000049278 1000049390 1000048776 1000049438 1000048911 1000049126 1000049488 1000049486 1000049557 1000048900 1000048780 1000044542 1000049807 1000049880 1000050136 1000049481 1000049151 1000050593 1000046407 1000050737 1000050800 1000050235 1000050326 1000050996 1000051049 1000051109 1000051168 1000048314 1000051257 1000051286 1000051306 1000051338 1000051067 1000051398 1000051400 1000051466 1000051486 1000051518 1000051520 1000051369 1000051527 1000051574 1000051627 1000050749 1000051054 1000038011 1000048234 1000051801 1000049007 1000051847 1000051898 1000051899 1000051973 1000051975 1000052050 1000052244 1000051742 1000048894 1000052380 1000052670 1000052873 1000052898 1000052905 1000053184 1000050387 1000053292 1000048580 1000053333 1000050208 1000053405 1000053426 1000052696 1000026140 3337 ] |
|
156.65 ms (5.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, 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:
[
"18333-devidoirs-couleur-n-c-fad900563"
]
|
|
2.86 ms (0.10%) |
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
]
|
|
1.01 ms (0.03%) |
5 |
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"
]
|
|
0.72 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 = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 3337 7 ] |
|
0.69 ms (0.02%) |
2 |
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" 3337 ] |
|
0.60 ms (0.02%) |
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:
[ 56 265 266 267 268 269 268 3337 ] |
|
0.60 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:
[
"18333-devidoirs-couleur-n-c-fad900563"
]
|
|
0.45 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.43 ms (0.01%) |
2 |
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"
]
|
|
0.43 ms (0.01%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.36 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:
[ 3337 1 ] |
|
0.35 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:
[
"18333-devidoirs-couleur-n-c-fad900563"
]
|
|
0.34 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 = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 3337 9957720 ] |
|
0.33 ms (0.01%) |
1 |
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:
[ 3337 0 ] |
|
0.32 ms (0.01%) |
1 |
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:
[ 3337 "C" ] |
|
0.32 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:
[
3337
]
|
|
0.26 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_.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:
[
3337
]
|
|
0.25 ms (0.01%) |
1 |
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 11:25:26" "%2%" 3337 ] |
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.