Query Metrics
316
Database Queries
25
Different statements
1235.55 ms
Query time
0
Invalid entities
1802
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
589.49 ms (47.71%) |
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:
[ 314061 "2025-04-13 00:50:26" ] |
|
445.77 ms (36.08%) |
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:
[ 6388524 6388552 6390289 6390417 6389039 6394419 6394033 6395871 6398522 6399197 6400200 6403303 6403874 6404138 6405975 6406785 6407383 6409452 6409567 6413861 6413867 6414714 6415835 6416958 6417089 6417444 6417474 6417615 6417930 6419809 6422593 6423779 6425405 6425782 6425793 6425806 6426347 6427867 6427923 6430792 6431334 6432169 6433598 6433600 6433620 6433627 6433658 6433664 6433831 6433834 6433917 6433918 6433935 6433937 6434044 6434047 6434058 6434060 6435215 6435217 6435236 6435238 6435328 6435329 6435353 6435355 6435406 6435408 6435433 6435438 6435480 6435490 6435540 6435544 6435616 6435620 6435647 6435649 6436651 6437335 6437336 6437441 6437448 6437594 6437596 6437612 6437615 6438882 6439060 6439297 6439301 6439367 6439370 6439518 6439520 6439535 6439536 6439598 6439599 6440977 6441233 6441254 6441255 6441264 6441266 6441342 6441345 6441406 6441407 6441471 6441529 6441533 6441552 6441554 6441565 6441567 6441701 6441703 6442746 6446259 6448581 6449884 6450168 6451439 6452542 6453591 6453873 6454935 6455057 6455390 6455732 6456096 6456431 6456689 6463553 6464009 6464302 6466719 6471834 6472318 6476037 6476511 6476517 6480447 6483161 6483162 6483562 6483704 6483996 6484638 6485706 6486170 6486272 6490052 6490063 6490485 6492077 6492406 6494176 6494553 6494765 6494767 6494838 6494889 6495228 6495363 6497243 6497252 6497535 6498854 6499137 6499459 6501837 6502408 6502698 6502784 6502872 6503258 6505405 6505871 6505872 6506759 6507061 6507292 6507766 6507877 6507916 6508088 6508467 6509853 6509854 6510198 6511060 6511063 6511064 6512719 6515131 6515132 6515136 6515139 6515974 6515975 6516909 6516911 6518817 6518818 6519042 6519043 6519982 6519984 6520734 6520845 6520964 6520984 6521480 6523039 6524003 6524526 6524753 6524983 6525133 6525384 6525733 6525823 6525861 6525899 6526279 6526280 6526419 6526924 6527418 6527657 6529850 6529980 6530333 6530528 6532714 6533612 6535577 6535840 6535846 6536590 6536871 6537619 6537945 6538771 6541503 1000000947 1000001883 1000003037 1000004597 1000004738 1000006096 1000007157 1000007158 1000008313 1000008321 1000008641 1000004161 1000005503 1000012955 1000013879 1000014034 1000015256 1000012619 1000013547 1000015940 1000015954 1000017017 1000007398 1000018121 1000018122 1000018123 1000018124 1000018296 1000018297 1000018300 1000018301 1000018302 1000018309 1000018311 1000018315 1000018318 1000018320 1000018326 1000018329 1000018334 1000018335 1000018464 1000018466 1000018471 1000019383 1000019403 1000019407 1000019414 1000019425 1000019611 1000022153 1000022154 1000022155 1000022156 1000022158 1000022159 1000022160 1000022161 1000022163 1000022164 1000022170 1000022171 1000022172 1000022173 1000014466 1000022880 1000022899 1000022903 1000023092 1000023163 1000023196 1000023198 1000023215 1000023217 1000023221 1000023222 1000023224 1000023227 1000023228 1000023231 1000023233 1000023236 1000023237 1000023238 1000023239 1000023240 1000023241 1000023242 1000023243 1000023244 1000023245 1000023246 1000023247 1000023248 1000023249 1000023250 1000023251 1000023252 1000023253 1000023254 1000023255 1000023256 1000023262 1000023263 1000023266 1000023267 1000023268 1000023269 1000023270 1000023271 1000023273 1000023274 1000023275 1000023276 1000023277 1000023278 1000023279 1000023280 1000023281 1000023750 1000024153 1000024154 1000024155 1000025162 1000025164 1000025168 1000025486 1000025491 1000025492 1000025493 1000025495 1000025516 1000025517 1000025518 1000025519 1000025520 1000025521 1000025522 1000025523 1000025551 1000025553 1000025555 1000025556 1000025557 1000025566 1000025704 1000025705 1000025706 1000025708 1000025710 1000025711 1000025712 1000025713 1000025722 1000025768 1000025772 1000025774 1000025775 1000025776 1000025777 1000025778 1000025779 1000025780 1000025781 1000025782 1000025783 1000025784 1000025785 1000025786 1000025787 1000025788 1000025789 1000025790 1000025791 1000025817 1000025818 1000025819 1000025820 1000025821 1000025822 1000025830 1000025848 1000025849 1000025850 1000025851 1000025852 1000025854 1000025857 1000025858 1000025860 1000025861 1000025862 1000025864 1000025865 1000025866 1000026613 1000026615 1000026625 1000026679 1000026786 1000026800 1000026802 1000026803 1000026804 1000026805 1000026806 1000026807 1000026808 1000026809 1000026810 1000026811 1000026812 1000026813 1000026814 1000026815 1000026829 1000026830 1000026831 1000027107 1000027111 1000027112 1000027115 1000027117 1000027121 1000027122 1000027124 1000027297 1000027388 1000027391 1000027393 1000027396 1000027530 1000015300 1000027650 1000027655 1000027657 1000027682 1000027683 1000027685 1000027695 1000027969 1000027971 1000027972 1000027973 1000027974 1000028138 1000028259 1000028260 1000028261 1000028262 1000028263 1000028265 1000028266 1000028269 1000028270 1000028271 1000028436 1000028437 1000028438 1000028439 1000028440 1000028441 1000028442 1000028444 1000028445 1000028446 1000028447 1000028448 1000028450 1000028451 1000028459 1000029003 1000029110 1000029112 1000029130 1000029152 1000029773 1000029983 1000029984 1000029985 1000029987 1000029988 1000029989 1000029990 1000029991 1000029992 1000029994 1000029995 1000029996 1000029997 1000029998 1000029999 1000030000 1000030001 1000030002 1000030003 1000030004 1000030005 1000030006 1000030007 1000030008 1000030009 1000030010 1000030011 1000030012 1000030013 1000030014 1000030016 1000030017 1000030049 1000030050 1000030051 1000030216 1000030403 1000030404 1000030406 1000030408 1000030869 1000030870 1000030871 1000030872 1000030873 1000030874 1000030875 1000030876 1000030877 1000030878 1000030879 1000030880 1000030881 1000030882 1000030883 1000030884 1000030885 1000030886 1000030887 1000030912 1000030913 1000030915 1000030916 1000030917 1000030918 1000030919 1000030920 1000030922 1000030924 1000030925 1000030943 1000030944 1000030946 1000030947 1000030948 1000030949 1000030950 1000030951 1000030952 1000030953 1000030954 1000030970 1000031000 1000031020 1000031032 1000031035 1000031036 1000031242 1000031243 1000031244 1000031245 1000031247 1000031292 1000031293 1000031294 1000031295 1000031296 1000031297 1000031298 1000031299 1000031300 1000031301 1000031302 1000031427 1000032472 1000032474 1000032475 1000032477 1000032478 1000032479 1000032480 1000032657 1000032659 1000032661 1000032663 1000032664 1000032670 1000032680 1000032681 1000032682 1000032685 1000032686 1000032689 1000032690 1000032702 1000032703 1000032704 1000032705 1000032706 1000032708 1000032709 1000032714 1000032718 1000032727 1000032731 1000032733 1000032734 1000032735 1000032821 1000032822 1000032823 1000033246 1000033247 1000033248 1000033250 1000033251 1000033252 1000033253 1000033255 1000033259 1000033261 1000033391 1000033393 1000033396 1000033398 1000033399 1000033400 1000033401 1000033402 1000033403 1000033404 1000033405 1000033406 1000033408 1000033409 1000033411 1000033412 1000033414 1000033415 1000033416 1000033441 1000034312 1000034546 1000035265 1000035428 1000035503 1000035542 1000035543 1000035544 1000035546 1000035583 1000035584 1000036054 1000036055 1000036056 1000036057 1000036058 1000036059 1000036060 1000036061 1000036062 1000036063 1000036064 1000036066 1000036067 1000036068 1000036070 1000037342 1000037343 1000037344 1000037345 1000037346 1000037347 1000037348 1000037349 1000037350 1000037351 1000037352 1000037353 1000037354 1000037355 1000037627 1000037629 1000037631 1000037634 1000037635 1000037637 1000037638 1000037639 1000037640 1000037643 1000037644 1000037646 1000037647 1000037650 1000037717 1000038081 1000038082 1000038083 1000038085 1000038086 1000038087 1000038099 1000038100 1000038101 1000038102 1000038103 1000038104 1000038106 1000038108 1000038109 1000038111 1000038112 1000038113 1000038114 1000038115 1000038116 1000038117 1000038118 1000038119 1000038120 1000038124 1000038125 1000038126 1000038127 1000038128 1000038130 1000038131 1000038132 1000038133 1000038134 1000038135 1000038136 1000038137 1000038138 1000038327 1000038328 1000039262 1000039384 1000039387 1000039391 1000039392 1000039393 1000039394 1000039395 1000039396 1000039397 1000039398 1000039399 1000039400 1000039402 1000039578 1000039585 1000039586 1000039587 1000039588 1000039589 1000039590 1000039591 1000039592 1000039593 1000039594 1000039595 1000039596 1000039597 1000039598 1000039599 1000039600 1000039612 1000039613 1000041025 1000042812 1000043734 1000043735 1000043736 1000043782 1000044269 1000044424 1000047441 1000047443 1000047444 1000048875 1000049204 1000049202 1000049661 1000049797 1000050479 1000025986 1000050959 1000051747 1000051751 1000049786 1000049956 1000052573 1000052794 1000053224 1000053348 1000053973 1000054140 1000055026 1000053349 1000055926 1000044003 1000056432 1000056461 1000054894 1000056524 1000054260 1000056708 1000056819 1000056820 1000056821 1000057389 1000057393 1000057446 1000057447 1000015678 1000057536 1000049963 1000057867 1000058154 1000058176 1000058177 1000058601 1000058902 1000059512 1000059525 1000009393 1000059914 1000059986 1000057884 1000060133 1000060135 1000060163 1000060340 1000060072 1000060577 1000060578 1000060717 1000060796 1000060797 1000060844 1000053194 1000061599 1000062015 1000062022 1000063402 1000055821 1000065847 314061 ] |
|
104.65 ms (8.47%) |
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:
[
"03406-trieurs-simples-couleur-n-c-1310402"
]
|
|
12.48 ms (1.01%) |
32 |
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" 314061 ] |
|
10.78 ms (0.87%) |
50 |
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"
]
|
|
10.48 ms (0.85%) |
16 |
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-09-13 00:50:27" "%2%" 314061 ] |
|
7.53 ms (0.61%) |
16 |
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:
[
314061
]
|
|
7.51 ms (0.61%) |
32 |
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"
]
|
|
7.08 ms (0.57%) |
10 |
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:
[ 314061 7 ] |
|
6.91 ms (0.56%) |
33 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
6.80 ms (0.55%) |
16 |
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:
[ 314061 0 ] |
|
4.86 ms (0.39%) |
16 |
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:
[ 314061 "C" ] |
|
3.90 ms (0.32%) |
21 |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
314061
]
|
|
3.83 ms (0.31%) |
23 |
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:
[
53
]
|
|
3.44 ms (0.28%) |
11 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 314061 9955755 ] |
|
2.98 ms (0.24%) |
15 |
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:
[
2451
]
|
|
2.34 ms (0.19%) |
8 |
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:
[
203933
]
|
|
1.52 ms (0.12%) |
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 = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
28367
]
|
|
0.91 ms (0.07%) |
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:
[ 53 249 250 251 252 252 314061 ] |
|
0.67 ms (0.05%) |
3 |
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.promotion_id = ? ORDER BY d0_.quantity DESC
Parameters:
[
183146
]
|
|
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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"03406-trieurs-simples-couleur-n-c-1310402"
]
|
|
0.36 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:
[
"03406-trieurs-simples-couleur-n-c-1310402"
]
|
|
0.34 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:
[ 314061 1 ] |
|
0.28 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:
[
314061
]
|
|
0.27 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
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Order\CustomerOrder | 903 |
| App\Entity\Catalog\ProductCatalog | 136 |
| App\Entity\Catalog\CustomerCatalog | 136 |
| App\Entity\User\User | 130 |
| App\Entity\Customer\Customer | 99 |
| App\Entity\Delivery\Delivery | 77 |
| App\Entity\Product\ProductPrice | 74 |
| App\Entity\Pricing\Price | 51 |
| App\Entity\Pricing\SocietyPromotion | 37 |
| App\Entity\Product\Market | 35 |
| App\Entity\Internal\Commercial | 31 |
| App\Entity\Product\Category | 24 |
| App\Entity\Product\Product | 21 |
| App\Entity\Internal\Society | 13 |
| App\Entity\Product\Characteristic | 12 |
| App\Entity\Product\CharacteristicLabel | 11 |
| App\Entity\Delivery\DeliveryCost | 5 |
| App\Entity\Pricing\Promotion | 4 |
| App\Entity\Internal\Parameter | 3 |