Query Metrics
103
Database Queries
16
Different statements
4936.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3500.87 ms (70.92%) |
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:
[ 239 "2024-11-04 22:28:15" ] |
|
799.63 ms (16.20%) |
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 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:
[ 6237348 6240790 6247728 6222497 6231036 6257463 6257602 6257633 6257884 6258151 6258296 6245689 6258344 6245154 6220211 6221574 6258427 6258732 6258747 6258790 6258845 6258970 6258987 6259029 6259280 6259236 6259384 6258979 6259484 6259821 6259866 6259902 6260145 6260183 6260239 6260372 6260433 6261123 6261183 6261186 6261280 6258141 6261722 6261833 6261961 6262005 6262109 6262495 6262526 6262613 6262699 6262768 6262850 6262927 6263078 6263229 6263235 6263307 6263315 6263505 6263586 6263662 6263325 6236603 6263184 6260035 6263762 6263879 6263950 6262301 6264049 6264091 6264283 6264359 6264509 6264524 6264684 6264783 6264859 6265042 6265057 6265159 6239284 6265380 6265488 6265588 6265718 6265788 6265188 6265886 6266103 6266175 6266270 6266409 6266574 6264526 6266662 6266806 6266865 6266941 6244105 6267121 6257511 6267446 6267496 6234346 6267608 6267798 6267800 6266179 6267935 6268107 6268220 6268421 6268646 6268764 6268844 6269261 6269499 6269516 6269565 6269649 6267880 6264250 6270520 6270647 6182456 6270879 6231418 6271222 6271355 6271393 6271701 6271728 6271822 6271949 6269728 6272165 6272176 6272279 6272378 6270958 6272483 6273315 6273511 6273598 6273687 6272965 6271730 6273998 6274015 6274060 6274141 6274152 6273001 6274230 6274333 6274522 6274592 6274619 6274515 6274654 6263174 6265800 6274998 6275065 6265324 6275469 6275564 6268632 6275784 6269342 6275934 6275972 6276011 6276033 6275995 6276099 6276288 6276400 6276469 6276694 6276711 6276900 6277057 6277059 6272971 6277383 6277412 6277414 6274227 6277634 6276040 6278176 6274512 6278416 6278511 6278536 6278606 6278823 6278868 6279236 6279241 6279280 6279655 6279892 6279972 6280086 6280106 6280273 6280350 6280914 6281027 6281057 6281067 6281077 6281149 6281174 6281189 6281278 6281378 6281563 6281566 6281569 6281687 6281810 6281854 6281909 6281988 6282048 6282079 6282115 6282121 6282124 6282164 6282190 6282195 6282209 6282224 6282267 6282314 6282352 6282390 6282398 6282423 6282425 6282433 6282448 6282487 6282601 6282643 6282712 6282829 6282905 6283001 6283002 6283031 6283060 6283111 6283123 6283128 6283307 6283405 6283416 6283577 6283619 6283621 6283680 6283826 6284163 6284344 6284372 6284420 6284455 6284556 6284671 6284674 6284716 6284941 6285041 6285045 6285343 6285615 6285859 6285873 6286175 6286291 6286556 6286585 6286846 6286899 6287179 6287531 6288117 6288075 6288837 6277130 6289677 6275304 6289948 6289992 6290094 6290309 6272257 6290242 6290548 6290789 6290949 6291103 6291166 6291545 6291590 6291058 6291608 6291702 6292226 6292342 6293405 6293497 6294201 6294066 6294276 6294535 6294851 6295029 6295447 6295706 6295969 6296066 6278890 6296303 6296659 6296759 6296768 6296996 6297106 6297557 6297660 6297678 6297852 6297933 6298015 6298117 6298522 6296311 6296195 6298758 6270022 6298897 6298928 6298693 6299034 6299077 6299151 6299173 6297914 6299563 6299139 6299879 6299926 6300175 6300436 6300447 6300494 6272706 6299763 6300945 6301101 6296050 6301570 6301662 6289102 6263134 6301951 6302043 6302162 6302152 6302259 6302652 6302985 6303015 6303400 6303488 6303543 6303561 6303752 6303776 6303801 6304073 6302775 6304145 6304285 6304350 6304359 6304514 6304675 6304967 6305329 6305390 6305472 6305548 6305554 6305566 6305705 6305796 6305845 6306004 6306087 6306119 6306149 6306164 6306168 6306213 6306260 6306307 6306331 6306355 6306409 6306410 6306411 6306517 6306722 6306819 6306896 6306979 6307030 6307054 6307492 6307603 6307949 6308157 6308275 6308469 6308555 6308614 6308879 6308909 6309038 6309088 6309204 6309294 6299388 6309475 6309704 6309788 6309916 6310314 6310433 6310545 6310707 6310715 6310831 6310876 6311177 6311507 6311654 6311446 6311675 6311722 6298673 6312003 6312193 6312311 6312492 6312517 6303404 6312630 6312767 6312840 6313182 6313205 6313242 6313315 6313471 6313492 6313661 6313753 6301431 6313833 6299872 6313949 6313965 6314098 6314152 6314220 6314273 6314433 6314465 6314523 6314618 6314423 6314841 6314996 6315273 6313904 6315418 6315434 6315503 6315593 6315696 6310862 6315895 6316061 6309406 6313574 6316308 6316324 6316448 6316528 6316744 6316766 6316116 6316378 6316559 6275765 6316973 6316976 6317033 6317203 6317263 6317426 6317012 6317444 6316258 6314938 6317615 6317706 6317732 6317749 6317750 6317743 6317887 6317665 6317958 6318073 6318080 6318119 6318174 6318237 6317878 6318499 6318554 6318557 6318747 6318771 6318969 6319039 6319193 6317431 6314636 6319015 6319662 6319746 6319920 6319929 6319941 6320218 6320194 6320285 6320301 6320314 6320405 6320542 6318033 6320718 6320737 6321088 6321218 6321232 6321292 6321296 6321351 6321540 6321826 6322049 6320891 6317793 6321774 6322231 6322347 6322406 6322454 6322657 6317267 6322871 6323018 6323014 6323145 6323278 6323382 6323778 6323837 6323889 6323984 6323989 6324014 6324158 6317971 6324181 6324300 6324387 6324456 6324472 6296687 6321866 6324668 6324723 6324729 6324733 6324791 6324920 6325115 6325133 6322469 6325422 6325441 6325493 6325559 6325565 6325609 6325610 6325807 6325888 6325927 6323702 6325993 6319232 6326073 6326081 6326193 6326249 6326258 6326276 6326300 6326528 6326570 6326587 6326622 6326640 6326709 6327053 6327119 6327291 6327294 6327309 6327434 6327506 6327545 6327590 6327602 6327603 6327604 6327690 6327766 6327821 6327883 6327982 6327983 6328007 6328094 6328187 6328202 6328255 6328276 6328284 6328306 6328321 6328333 6328363 6328420 6328441 6328451 6328463 6328470 6328499 6328551 6328599 6328611 6328644 6328706 6328732 6328972 6328984 6328999 6329089 6329134 6329302 6329316 6329513 6329687 6329693 6329726 6329729 6329758 6329763 6329775 6329785 6329839 6329845 6329859 6329967 6329971 6329973 6330043 6330056 6330061 6330069 6330175 6330203 6330251 6330297 6330309 6330314 6330319 6330344 6330498 6330519 6330552 6330569 6330631 6330835 6330885 6330910 6331175 6331351 6331354 6331439 6331493 6331577 6331842 6332159 6332373 6332663 6332739 6333114 6333136 6333310 6333449 6333701 6333871 6333919 6334172 6324082 6332438 6334815 6334862 6334914 6335314 6335342 6334468 6334837 6335512 6335579 6335699 6335740 6335843 6335619 6335925 6336110 6336148 6336218 6336220 6325976 6325403 6336423 6336427 6336570 6325984 6331001 6336721 6336779 6336893 6337031 6335942 6337097 6337260 6337263 6337276 6337350 6335501 6337631 6337753 6337804 6337823 6337847 6338004 6338353 6314704 6338505 6338554 6338595 6338676 6338806 6338864 6338879 6332845 6322943 6339107 6339201 6339414 6337034 6338670 6339688 6339698 6339710 6339728 6339894 6339001 6340176 6340586 6340460 6340775 6341334 6341480 6341513 6341312 6341874 6341944 6342112 6342154 6342554 6342104 6340512 6342761 6342809 6342960 6343028 6343040 6343024 6343027 6343392 6343420 6343453 6343575 6343659 6343758 6343787 6343894 6344030 6344089 6344104 6341420 6344169 6344281 6344501 6343479 6344584 6344919 6344929 6344138 6344691 6345046 6345083 6345167 6344990 6345332 6345331 6345450 6345457 6345460 6345465 6345495 6344262 6345630 6345680 6345775 6345822 6345844 6345850 6345921 6344653 6346057 6346063 6346067 6346115 6346119 6346123 6346397 6346428 6346472 6346588 6346846 6346863 6346933 6347018 6347236 6347333 6347397 6347515 6347522 6347527 6347587 6347614 6347665 6347672 6347679 6347712 6347721 6347724 6347726 6347857 6347989 6348002 6348028 6348059 6348079 6348106 6348110 6348111 6348117 6348136 6348172 6348180 6348375 6348377 6348388 6348444 6348504 6348582 6348642 6348650 6348705 6348708 6348742 6348758 6348780 6348934 6348991 6348999 6349267 6349281 6349364 6349388 6349425 6349433 6349434 6349505 6349538 6349574 6349589 6349819 6349843 6349930 6349971 6350179 6350181 6350197 6350298 6350455 6350456 6350459 6350579 6350598 6344576 6350786 6337044 6350824 6350922 6350995 6351038 6351163 6351190 6351336 6351676 6332828 6351825 6351830 6352181 6352180 6352344 6352393 6352435 6276268 6351269 6352664 6353114 6353185 6353394 6353463 6353542 6353562 6353949 6353976 6315354 6353918 6354314 6354555 6354561 6354087 6354708 6354739 6343877 6354873 6354876 6354878 6354913 6355117 6355380 6355486 6355504 6355480 6355347 6354758 6355831 6355907 6355925 6356122 6356148 6356287 6356470 6356564 6356578 6354802 6356964 6357046 6357220 6357356 6357451 6357464 6354700 6357647 6357830 6357897 6354773 6358036 6358077 6356958 6358169 6358252 6358322 6358362 6356669 6357610 6358589 6358766 6358775 6358937 6357293 6359312 6358665 6359135 6359439 6359515 6359560 6359688 6359787 6359908 6357320 6359965 6360208 6360474 6360479 6360481 6360484 6360779 6360809 6360229 6361153 6360917 6361257 6361275 6361602 6362011 6362118 6359874 6362214 6362316 6362417 6362702 6358131 6362904 6362910 6362959 6363070 6363097 6363126 6363453 6363595 6363711 6363740 6342304 6363820 6363845 6364075 6362981 6364381 6341834 6364587 6364619 6364681 6364870 6365047 6365057 6365145 6365457 6365488 6365515 6365593 6365651 6365711 6365716 6365837 6365894 6365951 6366101 6366561 6366607 6366618 6366649 6366702 6366745 6366830 6359386 6366922 6366935 6366996 6367034 6367136 6367327 6359320 6367403 6367581 6335764 6367680 6367726 6367781 6367875 6367905 6368214 6368380 6368257 6368700 6368728 6368747 6368833 6368902 6369022 6369032 6369064 6369112 6369153 6369295 6369421 6369450 6369508 6369736 6369925 6369973 6369983 6370048 6370107 6370110 6370114 6370133 6370157 6370185 6370218 6370219 6370299 6370300 6370333 6370334 6370352 6370436 6370480 6370481 6370523 6370690 6370720 6370759 6370787 6370832 6370850 6370879 6370953 6371057 6371060 6371064 6371071 6371179 6371188 6371235 6371297 6371301 6371314 6371320 6371367 6371428 6371431 6371517 6371533 6371575 6371598 6371621 6371623 6371653 6371727 6371896 6371967 6372047 6372070 6372172 6372264 6372386 6372551 6372581 6372592 6372629 6372834 6372844 6372871 6372908 6372935 6372966 6373146 6373265 6373518 6373550 6373675 6373694 6373866 6373900 6373976 6374118 6374167 6374365 6368621 6374683 6374726 6374753 6374804 6374099 6375395 6375467 6375587 6375596 6375893 6376019 6376143 6376335 6376358 6376370 6376509 6376596 6358079 6376693 6367817 6376755 6376866 6376960 6364799 6377059 239 ] |
|
587.13 ms (11.89%) |
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:
[
"01522-stylos-feutres-et-rollers-rouge-paper-mate-09513"
]
|
|
11.67 ms (0.24%) |
21 |
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" 239 ] |
|
10.49 ms (0.21%) |
20 |
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:
[ 111 7 ] |
|
8.49 ms (0.17%) |
21 |
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 <= ? ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[ 239 0 ] |
|
6.42 ms (0.13%) |
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:
[ 239 1 ] |
|
3.89 ms (0.08%) |
20 |
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:
[
111
]
|
|
2.09 ms (0.04%) |
9 |
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:
[
60
]
|
|
1.62 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 LIMIT 10
Parameters:
[ 60 287 288 289 290 291 292 293 294 292 239 ] |
|
1.24 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
]
|
|
1.18 ms (0.02%) |
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_.category_parent_id IS NULL
Parameters:
[] |
|
0.77 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 WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
239
]
|
|
0.68 ms (0.01%) |
2 |
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.33 ms (0.01%) |
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.is_in_footer = ?
Parameters:
[
1
]
|
|
0.20 ms (0.00%) |
1 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
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.