Query Metrics
49
Database Queries
12
Different statements
2785.72 ms
Query time
0
Invalid entities
3313
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1701.45 ms (61.08%) |
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:
[ 87308 "2025-04-12 19:00:45" ] |
|
952.23 ms (34.18%) |
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:
[ 6384121 6384289 6384453 6384501 6384588 6384592 6384700 6381432 6384820 6384925 6385357 6382373 6385412 6385450 6385601 6385625 6385693 6385701 6385725 6378191 6386083 6386344 6386493 6386512 6386574 6386685 6386881 6386922 6386938 6386964 6386977 6386985 6386989 6387067 6387070 6387080 6387269 6387284 6387681 6387706 6382645 6387791 6388119 6388451 6388534 6388551 6388627 6388638 6388639 6388658 6374299 6388774 6388977 6389009 6389010 6389012 6389013 6389014 6389015 6388915 6389053 6385867 6389380 6389389 6389402 6389429 6389440 6389445 6389452 6389518 6389580 6389624 6389639 6390035 6390053 6390056 6390058 6390061 6390064 6390073 6390074 6389983 6390270 6390283 6390324 6390336 6390351 6390402 6390443 6390579 6390606 6390913 6390941 6390963 6390970 6391160 6391284 6391323 6391330 6391363 6391485 6391721 6391722 6391723 6391744 6391745 6391746 6391747 6391777 6391823 6391866 6392118 6392120 6392139 6392166 6392175 6392177 6392195 6389573 6391742 6392600 6392607 6392881 6392933 6392937 6392938 6392944 6392967 6393151 6393183 6393229 6393241 6393273 6393274 6393285 6393290 6393395 6393416 6393418 6393420 6393424 6393426 6393428 6393010 6378047 6394184 6368035 6365392 6394880 6394934 6394964 6395119 6395451 6395895 6395916 6396566 6396751 6397032 6397039 6397317 6397394 6397837 6397839 6397841 6397843 6397844 6397849 6397854 6397855 6397859 6397860 6397869 6397870 6397872 6397874 6397877 6397879 6397881 6397882 6397884 6397885 6397887 6397888 6397901 6397902 6397903 6397905 6397913 6397915 6397917 6397918 6397919 6397925 6397927 6397931 6397933 6397936 6397938 6397939 6397964 6397969 6398016 6398034 6398055 6398829 6399007 6399009 6399053 6399060 6399081 6399085 6399088 6399091 6399137 6399212 6399259 6399263 6399266 6399355 6399359 6399395 6399397 6399431 6399449 6399459 6399490 6399491 6399507 6399551 6399560 6399649 6399655 6399718 6399911 6400212 6400216 6400227 6400230 6400239 6400425 6400452 6400791 6400922 6401161 6401320 6401343 6401361 6401506 6401511 6401532 6401615 6401624 6401639 6401655 6401682 6401707 6401716 6401734 6401753 6401783 6401786 6401811 6401820 6401829 6401977 6402284 6402306 6402388 6403126 6403223 6403506 6404692 6404810 6404807 6405630 6406129 6406274 6406535 6406831 6407114 6407704 6407753 6407820 6408061 6408070 6408865 6409064 6409678 6409680 6409681 6409683 6409686 6410884 6410952 6410970 6410988 6411043 6411051 6411103 6411211 6411282 6411512 6411729 6411811 6411855 6411856 6411936 6412087 6412187 6412635 6412682 6412719 6413624 6413660 6413925 6413987 6414248 6414610 6414639 6415030 6415350 6415658 6415818 6415967 6416120 6416148 6416216 6416257 6416398 6416814 6416933 6416987 6417287 6417452 6417534 6417535 6417747 6418009 6418115 6418158 6418294 6418393 6418544 6418645 6418647 6418649 6418650 6418652 6418653 6418654 6418659 6418661 6418662 6418664 6418665 6418666 6418669 6418670 6418677 6418682 6418683 6418684 6418685 6418686 6418694 6418773 6418948 6418975 6418981 6419024 6419302 6419350 6419372 6419432 6419476 6419507 6419577 6419614 6419615 6419626 6419652 6419694 6419718 6419730 6419740 6419761 6419767 6419768 6419769 6419858 6419904 6419907 6419916 6419947 6419949 6420014 6420025 6420045 6420064 6420447 6420695 6420715 6420877 6421596 6422458 6422720 6422772 6423176 6423203 6423816 6424017 6424140 6424309 6424326 6425052 6425107 6425117 6425120 6425207 6425286 6425347 6426129 6426167 6426211 6426244 6426437 6426502 6426398 6426661 6426665 6426993 6427031 6427085 6427226 6427665 6427857 6428170 6428427 6428454 6428512 6428638 6428677 6430124 6430649 6430646 6431602 6431755 6431949 6432239 6432240 6432244 6432294 6433448 6433659 6433661 6433697 6434067 6434406 6434552 6434891 6434933 6434981 6435644 6435972 6436245 6436827 6437121 6437097 6437367 6437733 6437968 6438035 6438100 6438825 6439118 6439360 6439980 6439983 6440287 6440366 6440558 6441367 6441434 6441780 6441864 6442654 6443134 6443268 6443320 6443439 6443537 6443612 6444080 6444083 6444179 6444597 6444650 6444671 6444920 6445264 6445288 6445455 6445787 6445790 6445820 6445853 6445859 6446260 6446467 6447331 6447395 6447435 6447437 6448232 6448857 6449383 6449588 6449784 6449832 6449918 6449919 6449978 6450174 6450175 6450497 6450565 6450654 6450744 6451049 6451103 6451338 6451435 6451650 6451701 6451703 6451823 6451988 6452433 6452536 6452586 6452724 6452727 6452830 6452927 6452929 6453009 6453375 6453378 6453450 6453458 6453552 6453604 6453674 6453929 6454136 6454152 6454180 6454308 6454323 6454328 6454330 6454334 6454336 6454337 6454339 6454429 6454546 6454586 6454773 6454801 6454842 6454860 6454949 6455308 6455332 6455354 6455419 6455434 6455459 6455528 6455606 6455750 6455762 6455820 6455918 6456117 6456150 6456154 6456211 6456238 6456239 6456505 6456510 6456519 6456581 6456600 6456614 6456620 6456732 6456748 6456949 6456979 6457224 6457300 6457316 6457441 6457539 6457767 6458430 6458475 6459082 6459112 6459200 6459472 6459612 6460036 6460232 6460399 6460453 6460634 6461321 6461615 6461668 6462686 6462931 6463016 6463760 6464204 6464400 6464416 6464485 6465052 6465809 6465814 6466687 6468039 6468839 6468862 6469140 6469293 6469473 6470275 6470438 6471370 6472395 6472397 6472474 6472531 6472651 6472869 6472953 6473053 6474544 6475575 6476462 6476784 6476877 6476979 6477577 6477597 6477854 6477925 6478286 6480471 6480498 6480585 6480650 6480858 6481080 6481710 6483631 6483946 6485130 6485195 6485208 6485270 6485502 6485919 6485992 6485993 6486013 6486738 6487914 6488475 6488569 6488586 6489003 6489748 6490144 6490616 6490832 6491478 6491500 6491575 6491788 6492093 6492263 6494289 6495738 6496213 6496246 6496425 6496451 6496867 6497147 6497168 6497199 6497256 6497605 6497616 6497912 6498113 6498114 6498236 6498275 6498346 6498347 6498438 6498608 6498618 6498624 6498665 6498774 6499145 6499146 6499157 6499263 6499327 6499331 6499413 6499558 6499778 6499782 6499992 6500242 6500341 6500361 6500566 6500588 6500722 6500986 6501208 6501561 6501579 6501599 6501652 6501976 6501985 6501986 6501990 6502049 6502159 6502369 6502398 6502403 6502404 6502459 6502519 6502565 6502760 6502802 6502822 6503029 6503059 6503087 6503446 6503473 6503655 6503778 6504032 6504036 6504290 6504718 6505038 6505500 6505697 6505922 6505976 6506023 6506282 6506330 6506345 6507167 6507278 6507494 6507680 6507707 6508488 6508506 6508557 6508736 6508998 6509296 6509319 6509462 6509615 6510602 6510624 6510720 6510724 6512216 6512539 6512801 6512990 6513071 6515551 6515674 6516050 6516303 6516417 6516670 6517142 6518272 6518862 6518947 6519294 6519402 6520257 6521236 6521406 6521895 6523731 6524008 6524298 6524392 6524460 6524470 6524492 6525043 6525051 6525177 6525226 6525245 6525308 6525377 6525793 6525820 6525821 6525883 6525913 6526070 6526127 6526212 6526624 6526738 6526739 6526775 6526916 6526980 6527043 6527130 6527295 6527431 6527546 6527602 6527875 6528160 6528166 6528214 6528338 6528347 6528419 6528476 6528571 6528573 6528584 6528640 6528652 6528671 6528705 6528720 6528803 6528942 6529009 6529326 6529335 6529377 6529416 6529841 6529968 6530102 6530105 6530118 6530160 6530253 6530356 6530558 6530663 6530667 6530870 6530950 6531291 6532954 6533035 6533039 6533595 6534945 6535771 6535773 6535999 6536049 6536075 6536080 6536126 6536247 6536616 6536971 6536975 6537048 6537062 6537072 6537075 6537095 6537101 6537422 6538230 6538776 6541945 6542374 6389017 6394917 1000001430 1000001867 1000001874 1000002065 1000002433 1000002584 1000002734 1000003065 1000002327 1000004341 1000004342 1000004363 1000004364 1000004365 1000004366 1000004371 1000004396 1000004410 1000004411 1000004414 1000001454 1000002774 1000005166 1000005407 6391433 1000005995 1000006000 1000006595 1000006837 1000006839 1000006873 1000006917 1000006924 1000006937 1000006940 1000006949 1000006978 1000007011 6366500 1000007263 1000007368 1000007518 1000007881 1000000974 1000008560 1000006838 1000008866 1000009034 1000001531 1000009270 6386802 1000006610 1000009945 1000004069 1000006056 1000010067 1000004422 1000010635 1000009248 1000011024 1000011844 1000012129 6343241 1000010480 1000012741 1000012621 1000013018 1000006028 1000005959 1000010763 1000013397 1000012923 1000014416 1000014982 1000014989 1000013459 1000015028 1000015096 1000015097 1000015283 1000015252 1000015383 1000012979 1000015780 1000016178 1000016180 1000016501 1000016593 1000016811 1000017302 1000008325 1000017685 1000017763 1000017853 1000017868 1000017870 1000017988 1000017989 1000017990 1000017991 1000017992 1000018679 1000018835 1000018901 1000018902 1000018903 1000018904 1000019075 1000019082 1000019103 1000019136 1000019215 1000019271 1000019283 1000019295 1000019300 1000019344 1000019371 1000019482 1000019614 1000019863 1000019864 1000019895 1000019896 1000019917 1000019919 1000019920 1000019921 1000017115 1000020454 1000020572 1000020668 1000020671 1000020689 1000020690 1000020776 1000020845 1000020851 1000020966 1000019489 1000019930 1000021241 1000015487 6375799 1000010767 1000002357 1000002434 1000018938 1000022113 1000015083 1000022517 1000019198 1000021390 6378270 1000024568 1000024569 1000024570 1000024571 1000024572 1000024573 1000024574 1000024575 1000024576 1000024577 1000024578 1000024579 1000024580 1000024581 1000024582 1000024583 1000024584 1000024585 1000025575 1000025585 1000025746 1000025813 1000025814 1000025835 1000025853 1000025855 1000025890 1000025891 1000012484 1000026147 1000026148 1000026149 1000026178 1000026220 1000015517 1000021242 1000027005 1000023910 1000027979 1000027984 1000027988 1000012775 1000028089 1000028492 1000028592 1000028597 1000028671 1000028673 1000030691 1000030692 1000028675 1000028244 1000028676 1000030725 1000031933 1000017001 1000032084 1000033443 1000033575 1000031799 1000031954 1000030466 1000033579 1000026221 1000034091 1000034095 1000034096 1000034098 1000034099 1000034100 1000034101 1000034102 1000034103 1000034105 1000034106 1000034107 1000034113 1000034114 1000034120 1000034133 1000034134 1000019123 1000034396 1000034399 1000034993 1000035001 1000035004 1000035728 1000035661 1000035891 1000035907 1000035909 1000035971 1000035974 1000035980 1000035984 1000035988 1000035990 1000036440 1000036445 1000036450 1000016099 1000036472 1000036475 1000036666 1000036668 1000037194 1000037725 1000037738 1000038180 1000038181 1000038182 1000038183 1000038184 1000038185 1000038186 1000038339 1000038602 1000031619 1000039214 1000039216 1000039217 1000039218 1000039221 1000039223 1000039224 1000039331 1000039337 1000039339 1000022526 1000041416 1000041417 1000041441 1000041445 1000041446 1000041454 1000041457 1000041458 1000041609 1000041610 1000041662 1000042069 1000042253 1000042956 1000042958 1000042963 1000043341 1000043344 1000043358 1000043361 1000043362 1000043364 1000043394 1000043395 1000043396 1000043416 1000043417 1000043418 1000043419 1000043420 1000043424 1000043432 1000043434 1000043440 1000043441 1000040197 1000020573 1000019315 1000044794 1000026490 1000044986 1000045614 1000045987 1000046063 1000046105 1000046140 1000046199 1000046220 1000046221 1000046222 1000046223 1000046224 1000046200 1000047467 1000037109 1000047483 1000043611 1000037216 1000041444 1000047952 1000032846 1000046193 1000048671 1000036007 1000048803 1000048981 1000048982 1000048382 1000048211 1000049208 1000049220 1000049253 1000048769 1000049471 1000049126 1000049469 1000049555 1000048963 1000049910 1000049947 1000049953 1000049954 1000050347 1000050075 1000050466 1000050802 1000050933 1000048190 1000050999 1000051016 1000051049 1000051056 1000039012 1000051223 1000050835 1000051224 1000051375 1000049648 1000050134 1000051488 1000051057 1000051567 1000051610 1000051664 1000051795 1000051796 1000039445 1000052025 1000052181 1000050874 1000052407 1000050268 1000052905 1000053035 1000053081 1000053358 1000053839 1000053965 1000052238 1000054115 1000054116 1000054134 1000054136 1000019932 1000054246 1000054248 1000039234 1000054319 1000027680 1000053093 1000054786 1000054893 1000054581 1000054907 1000053815 1000050011 1000054983 1000055130 1000055228 1000055116 1000055815 1000055816 1000055817 1000055818 1000055686 1000055959 1000010727 1000056297 1000056764 1000056718 1000056896 1000056955 1000057042 1000057043 1000057052 1000023450 1000049250 1000056859 1000057178 1000057053 1000057135 1000057366 1000057486 1000057602 1000057640 1000057655 1000057656 1000050326 1000055655 1000059315 1000053605 1000059422 1000059488 1000059510 1000059515 1000059516 1000059588 1000059667 1000060450 1000060560 1000060561 1000060562 1000060757 1000047485 1000060852 1000060975 1000061038 1000061039 1000061139 1000061372 1000061425 1000061747 1000061753 1000062361 1000062596 1000062599 1000062609 1000062319 1000063000 1000063194 1000062610 1000063293 1000063297 1000063474 1000062604 1000063773 1000064426 1000064680 1000064769 1000065340 1000061281 1000065716 1000065841 1000063878 1000064406 1000066185 1000066265 1000066292 1000066302 1000066381 1000065701 87308 ] |
|
121.89 ms (4.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, 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:
[
"70370-agrafes-couleur-pavo-8043071"
]
|
|
3.93 ms (0.14%) |
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:
[
87308
]
|
|
3.03 ms (0.11%) |
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
]
|
|
0.78 ms (0.03%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 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:
[ 54 253 254 255 256 257 258 253 87308 ] |
|
0.63 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, 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:
[
"70370-agrafes-couleur-pavo-8043071"
]
|
|
0.42 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.41 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:
[
"70370-agrafes-couleur-pavo-8043071"
]
|
|
0.39 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:
[ 87308 1 ] |
|
0.31 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:
[
87308
]
|
|
0.24 ms (0.01%) |
1 |
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"
]
|
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 | 1426 |
| App\Entity\Customer\Customer | 497 |
| App\Entity\Delivery\Delivery | 412 |
| App\Entity\User\User | 291 |
| App\Entity\Catalog\ProductCatalog | 191 |
| App\Entity\Catalog\CustomerCatalog | 191 |
| App\Entity\Product\Market | 83 |
| App\Entity\Internal\Commercial | 50 |
| App\Entity\Pricing\Price | 49 |
| App\Entity\Product\ProductPrice | 48 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 11 |
| App\Entity\Product\CharacteristicLabel | 11 |
| App\Entity\Internal\Society | 5 |
| App\Entity\Delivery\DeliveryCost | 5 |
| App\Entity\Internal\Parameter | 1 |