Query Metrics
45
Database Queries
20
Different statements
1296.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
870.80 ms (67.14%) |
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:
[ 221522 "2025-02-12 08:29:57" ] |
|
349.45 ms (26.94%) |
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:
[ 6337848 6337915 6332408 6338024 6338310 6338679 6338800 6338971 6339504 6339796 6340242 6340339 6340426 6340437 6340489 6341197 6341325 6341698 6341765 6341779 6342010 6342164 6333903 6342551 6342915 6342926 6343037 6343086 6343290 6343369 6343397 6343676 6343771 6344077 6344162 6344491 6344786 6344957 6345059 6345092 6345233 6345239 6345242 6345462 6345538 6345829 6345916 6346469 6346588 6346797 6346965 6347015 6347034 6347140 6347170 6347391 6347397 6347450 6347485 6347570 6347689 6347768 6347799 6347804 6348077 6348122 6348214 6348397 6348408 6348502 6348527 6348582 6348799 6348886 6348891 6348942 6349090 6349284 6349286 6349295 6349449 6349582 6349611 6349663 6349838 6349858 6349869 6350033 6350134 6350302 6350650 6350670 6350926 6350965 6351224 6345823 6351593 6352023 6352031 6352063 6352182 6352288 6352342 6352454 6352542 6352562 6353335 6353486 6353493 6353749 6353761 6353771 6354450 6354859 6354926 6354967 6352682 6355363 6355731 6354454 6356259 6345393 6357287 6357620 6357642 6357645 6357924 6357950 6358014 6358062 6358126 6343042 6358383 6358232 6358417 6358453 6358846 6358915 6353564 6356461 6359208 6359209 6359286 6358207 6359383 6359147 6359723 6359769 6359806 6359821 6360063 6360089 6360129 6360440 6360817 6361158 6361250 6361370 6361414 6361374 6362125 6345543 6362222 6362378 6362371 6362220 6362863 6363153 6363390 6363489 6363758 6363767 6363824 6363854 6364001 6364331 6364398 6364539 6358561 6364846 6361942 6365014 6365019 6364104 6365168 6365140 6365449 6365619 6365703 6365704 6366536 6366841 6366873 6367111 6367693 6367729 6367897 6368183 6369246 6369306 6369439 6369496 6369527 6369530 6369572 6369831 6369856 6369873 6369923 6369939 6369966 6370184 6370277 6370420 6370487 6370589 6370673 6370741 6370871 6370890 6370933 6370972 6371247 6371313 6371322 6371418 6371523 6371539 6371561 6371594 6371841 6371920 6371923 6371925 6371951 6371967 6372132 6372358 6372384 6372415 6372438 6372634 6372690 6372792 6372926 6372934 6373011 6373055 6373110 6373129 6373174 6373254 6373514 6374006 6374070 6374420 6375128 6375394 6360466 6375856 6375950 6376232 6376418 6376587 6376568 6374616 6376962 6377350 6377053 6377428 6376960 6377832 6378075 6378528 6378767 6380069 6380133 6380751 6381038 6377643 6376808 6381983 6382006 6382433 6382438 6383230 6383291 6383495 6383590 6383728 6383729 6383914 6383956 6359623 6385092 6385632 6386389 6386771 6386848 6386894 6387271 6387490 6388244 6388445 6388503 6388618 6388690 6388754 6388858 6332146 6367817 6389495 6389657 6389714 6389988 6390449 6390967 6391119 6391226 6391562 6391820 6392473 6387947 6392753 6392851 6392790 6392950 6393184 6393288 6343287 6385453 6393915 6394004 6394118 6394822 6395035 6395063 6395087 6395466 6395601 6395733 6395854 6395871 6395949 6396607 6396766 6397042 6397051 6397443 6397450 6397459 6397577 6397606 6398058 6398059 6398208 6398264 6398268 6398297 6398882 6398888 6398920 6399076 6399123 6399124 6399217 6399268 6399283 6400446 6400562 6402577 6402395 6403693 6403856 6405384 6405608 6405674 6405683 6406216 6406379 6406594 6406728 6407061 6407353 6407529 6407533 6407950 6407953 6407995 6408279 6408583 6409437 6410430 6410900 6411660 6411697 6413083 6413680 6414159 6415120 6415610 6415654 6415951 6415991 6416344 6416444 6416524 6416818 6417120 6417151 6417160 6417263 6417312 6417667 6417750 6417792 6417961 6418169 6418172 6418328 6418403 6418458 6418482 6418956 6419088 6419213 6419534 6419538 6419553 6419582 6419583 6419901 6419991 6420753 6420701 6421753 6422187 6422230 6422633 6423135 6423800 6424033 6424180 6424419 6424982 6426370 6426791 6427497 6427697 6427996 6411500 6428341 6428754 6428878 6428917 6429044 6430644 6430918 6430953 6431278 6431325 6431398 6432198 6433532 6433539 6433656 6433735 6434201 6434276 6434633 6434835 6435137 6435208 6435210 6435287 6435636 6435920 6435946 6435972 6436460 6436714 6437070 6437073 6437164 6437178 6437825 6438468 6438595 6440058 6441366 6441869 6443129 6443823 6443988 6444496 6444606 6445234 6445288 6445745 6446242 6447062 6447259 6447391 6448985 6450253 6450312 6450484 6450506 6450855 6451060 6451129 6451287 6451616 6451631 6451765 6451770 6451819 6452069 6452091 6452197 6452276 6452425 6452559 6452600 6452619 6452707 6452799 6452892 6453216 6453641 6453711 6453713 6453746 6454112 6454177 6454586 6454614 6454622 6454732 6454736 6454761 6454860 6455423 6455564 6455616 6455648 6456053 6456068 6456674 6456725 6456808 6456874 6457036 6457172 6457645 6458297 6458566 6459266 6459319 6459423 6459958 6460061 6460320 6460325 6460537 6461153 6461746 6461877 6462440 6462805 6463005 6463512 6463926 6463940 6463959 6464444 6465367 6465933 6465935 6466050 6466498 6467230 6468762 6468778 6468896 1000001011 1000001591 6392285 1000002374 1000002599 1000001012 1000000945 6360112 6390301 6389945 1000004197 1000004380 1000004744 1000004769 1000005004 1000005267 1000005518 1000005682 1000005177 1000005708 1000005770 1000005852 1000006019 1000000884 1000006585 1000007606 1000008833 1000008222 1000010736 1000010605 1000011851 1000013074 1000013132 1000013166 1000012382 1000015185 1000015686 1000015713 1000015714 1000015715 6379266 1000014747 1000018561 1000018562 1000018598 1000018641 1000018643 6386634 1000018968 1000018969 1000018998 1000018999 1000020708 1000020963 1000020965 1000021020 1000021160 1000021427 1000021913 1000021914 1000014079 1000022517 1000019091 1000014686 1000013119 1000016998 1000022914 1000021466 1000023321 1000024663 1000024666 1000024679 1000024680 1000024681 1000024682 1000024683 1000024684 1000024685 1000024686 1000024687 1000024688 1000024689 1000024690 1000024691 1000024692 1000024693 1000024694 1000024695 1000024696 1000024697 1000024698 1000025272 1000025273 1000025625 1000025947 1000012484 1000021921 1000027643 1000027647 1000025656 1000028478 1000025626 1000026108 1000029094 1000029164 1000029168 1000029169 1000029170 1000029175 1000029856 1000030091 1000030093 1000022019 1000021229 1000032435 1000033006 1000033007 1000033009 1000033012 1000033017 1000033019 1000033021 1000033022 1000033025 1000033026 1000032294 1000034169 1000034500 1000034501 1000034502 1000015040 1000034641 1000035389 1000035398 1000035399 1000035700 1000035701 1000035702 1000036391 1000036392 1000036602 1000036985 1000036986 1000036987 1000037122 1000037123 1000037124 1000037125 1000037126 1000037138 1000037167 1000037186 1000037214 1000037215 1000037229 1000037239 1000037240 1000037241 1000037242 1000037552 1000037553 1000037556 1000037570 1000037581 1000037584 1000037585 1000037589 1000037622 1000040264 1000040271 1000040274 1000040276 1000040391 1000040462 1000022526 1000042232 1000042370 1000042674 1000042737 1000042855 1000035429 1000043627 1000043632 1000042936 1000041468 1000046040 1000046068 1000046132 1000046254 1000046528 1000046529 1000046258 1000046810 1000047562 1000046255 1000047659 1000047702 1000047708 1000047720 1000047876 1000047897 1000048488 1000048699 1000048985 1000049219 1000049909 1000049992 1000049993 1000048299 1000042372 1000048210 1000050300 1000050771 1000051251 1000051275 1000050964 1000049611 1000051607 1000050244 1000048153 1000052466 1000052470 1000052481 1000052514 1000052602 1000052603 1000049690 1000017969 1000052643 1000052870 1000049284 1000052893 1000052930 1000052932 1000053067 1000053209 1000053218 1000053315 1000053339 1000053341 1000053486 1000053487 221522 ] |
|
61.96 ms (4.78%) |
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:
[
"29963-plastification-couleur-fellowes-5306114"
]
|
|
4.81 ms (0.37%) |
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:
[ 221522 1 ] |
|
2.94 ms (0.23%) |
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.08%) |
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.73 ms (0.06%) |
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:
[ 221522 7 ] |
|
0.73 ms (0.06%) |
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" 221522 ] |
|
0.71 ms (0.06%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ 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 245 221522 ] |
|
0.45 ms (0.03%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.43 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.43 ms (0.03%) |
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.39 ms (0.03%) |
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:
[
"29963-plastification-couleur-fellowes-5306114"
]
|
|
0.38 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:
[
"29963-plastification-couleur-fellowes-5306114"
]
|
|
0.32 ms (0.02%) |
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:
[ 221522 0 ] |
|
0.32 ms (0.02%) |
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:
[ 221522 9959081 ] |
|
0.30 ms (0.02%) |
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 08:29:58" "%2%" 221522 ] |
|
0.27 ms (0.02%) |
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:
[ 221522 "C" ] |
|
0.26 ms (0.02%) |
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:
[
221522
]
|
|
0.24 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:
[
221522
]
|
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.