Query Metrics
49
Database Queries
12
Different statements
1708.28 ms
Query time
0
Invalid entities
2152
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
828.43 ms (48.50%) |
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:
[ 194820 "2025-04-12 14:29:38" ] |
|
744.65 ms (43.59%) |
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:
[ 6386725 6388017 6388441 6389461 6387470 6390322 6390332 6390554 6390679 6390768 6384100 6391091 6391407 6391850 6392181 6392835 6392931 6393364 6393010 6394183 6394276 6363377 6394624 6394964 6395181 6395413 6397297 6399570 6400225 6400421 6405437 6405686 6410374 6410683 6410853 6411190 6411740 6413547 6413825 6414280 6414685 6415120 6415713 6415951 6417225 6417545 6417627 6418192 6419157 6419232 6419249 6419252 6419284 6419302 6419324 6419362 6419530 6419547 6420224 6420700 6420765 6420858 6420924 6421374 6421721 6421758 6422043 6422229 6422275 6422755 6422792 6422997 6423040 6423998 6424020 6424721 6425044 6425373 6425593 6426129 6426316 6428797 6428838 6429572 6429908 6430400 6430871 6431098 6431250 6432041 6432208 6432240 6433310 6434603 6434630 6434673 6434909 6434973 6436078 6438061 6438093 6438431 6438973 6439607 6439733 6439759 6439768 6440218 6440214 6440280 6441200 6441237 6441480 6441861 6443113 6443301 6443885 6443905 6443907 6444125 6445111 6445261 6446055 6447242 6447283 6447324 6447438 6447646 6448217 6448242 6448572 6448828 6448883 6449059 6449722 6449772 6450001 6450175 6450195 6450644 6450880 6450987 6451019 6451098 6451137 6451340 6451418 6451473 6451478 6451505 6451616 6451806 6451871 6451976 6452032 6452084 6452352 6452495 6452614 6452830 6453155 6453407 6453518 6453674 6453935 6454665 6454667 6454746 6454842 6454855 6454884 6454910 6454982 6454985 6455000 6455069 6455232 6455417 6455431 6455543 6455650 6455831 6455842 6455862 6455897 6456230 6456276 6456467 6456789 6457006 6457443 6457512 6457645 6457650 6458302 6458475 6458839 6459203 6459212 6459468 6460060 6461456 6461608 6461638 6462350 6462687 6463389 6463501 6464211 6464229 6464266 6464652 6465652 6465699 6466627 6466739 6466740 6467144 6467367 6468938 6469236 6469508 6470228 6470273 6471304 6472008 6472226 6472292 6472318 6472945 6473042 6473097 6474636 6475320 6475328 6475696 6475851 6476144 6476207 6476562 6476884 6476987 6477411 6477601 6477720 6477801 6477821 6477847 6477851 6477860 6480732 6480831 6481039 6481685 6481687 6481750 6482778 6483041 6483208 6483286 6483618 6483778 6483957 6485083 6485323 6485473 6485738 6486178 6486531 6486759 6488373 6489068 6489159 6490318 6491152 6491486 6491520 6491551 6492204 6492256 6492886 6493093 6493109 6495692 6496210 6496600 6496627 6497070 6497090 6497138 6497535 6497607 6498068 6498124 6498509 6498614 6498795 6498813 6498981 6499155 6499157 6499272 6499333 6499402 6499444 6499499 6499502 6500258 6500560 6500820 6501234 6501238 6501409 6501640 6501822 6501886 6501976 6502087 6502103 6502126 6502187 6502194 6502269 6502341 6502550 6502571 6502594 6502611 6502768 6502781 6502849 6502853 6503096 6503485 6503553 6503908 6504252 6504335 6504382 6504412 6504478 6504886 6505398 6505458 6505522 6506409 6506923 6507296 6507471 6507923 6508892 6509296 6509371 6509597 6510663 6510664 6510998 6512121 6512488 6512852 6516170 6516654 6516912 6518042 6520209 6520363 6521734 6521900 6522092 6522234 6523252 6523742 6524096 6524317 6524337 6524391 6525043 6525261 6525400 6525416 6525450 6525459 6525513 6525611 6525714 6525780 6526067 6526196 6526229 6526296 6526425 6526508 6526551 6527140 6527156 6528161 6528175 6528242 6528328 6528684 6528727 6528733 6528770 6528789 6528799 6528821 6528940 6529192 6529279 6529386 6529847 6529856 6529866 6529901 6529948 6529995 6530046 6530060 6530096 6530220 6530221 6530269 6530279 6530285 6530291 6530320 6530364 6530716 6530719 6531375 6532650 6532758 6533216 6533253 6533273 6533274 6533404 6534031 6534590 6535675 6535710 6536190 6537095 6537101 6539444 6539660 6539947 6539949 6540219 6540826 6540990 6541625 6542126 6542428 1000002566 1000002764 1000003628 1000000876 1000004508 1000004722 1000007026 1000007032 1000007328 1000007690 1000007389 1000001918 1000001670 1000008829 1000002592 1000008931 1000009130 1000007909 1000009810 1000008114 1000010174 1000010175 1000007460 1000010196 1000010223 6389047 1000010605 1000010774 1000011059 1000009265 1000011020 1000012376 1000012598 1000012631 1000012632 1000012636 1000002407 1000009879 1000009069 1000012548 1000013481 1000013577 1000006064 1000001633 1000014256 1000010226 1000011050 1000014765 1000012633 1000014277 1000006315 1000015510 1000012979 1000016486 1000016490 1000016681 1000016823 1000017882 1000015537 1000019246 1000019487 1000019563 1000019550 1000018789 1000020365 1000020366 1000020367 1000012830 1000020849 1000016784 1000010767 1000021761 1000021762 1000021763 1000021764 1000021766 1000021767 1000021770 1000021889 1000022735 1000022756 1000022781 1000022839 1000022870 1000022871 1000022872 1000023458 1000023633 1000023634 1000023724 1000023729 1000023730 1000023731 1000023732 1000023733 1000023757 1000023786 1000023787 1000023901 1000023902 1000025083 1000025108 1000025113 1000012399 1000014211 1000009869 1000023639 1000025122 1000022875 1000027884 1000027964 1000027965 1000027986 1000027987 1000014297 1000027967 1000015733 1000024088 1000030834 1000031094 1000031095 1000031096 1000031273 1000012292 1000031590 1000016835 1000031656 1000031661 1000031699 1000031703 1000031937 1000033322 1000033448 1000033503 1000034047 1000034049 1000034119 1000034129 1000023904 1000035288 1000033444 1000035529 1000035535 1000035538 1000035539 1000035545 1000035547 1000015443 1000035866 1000035867 1000035906 1000036436 1000013063 1000037187 1000037191 1000037219 1000037235 1000037251 1000037256 1000037264 1000037273 1000037289 1000037298 1000037299 1000037300 1000037306 1000037307 1000037308 1000037310 1000037766 1000038656 1000038657 1000038658 1000038659 1000038660 1000038663 1000038665 1000038671 1000038672 1000038673 1000038674 1000038679 1000038792 1000038793 1000039454 1000039457 1000039539 1000039540 1000039550 1000039554 1000039562 1000039641 1000039649 1000039664 1000039665 1000040079 1000040080 1000040081 1000040082 1000040084 1000040088 1000040097 1000040098 1000040100 1000040108 1000040109 1000040129 1000040130 1000040359 1000041495 1000041509 1000041873 1000041874 1000028250 1000041941 1000041945 1000042457 1000042458 1000042459 1000042460 1000030762 1000041424 1000043275 1000043277 1000039610 1000044071 1000044080 1000044083 1000044084 1000044097 1000044099 1000044100 1000044101 1000044576 1000044578 1000044585 1000034386 1000038837 1000026490 1000045436 1000045522 1000046013 1000046027 1000046051 1000046121 1000046284 1000009336 1000046838 1000046842 1000047676 1000047760 1000047771 1000047840 1000047839 1000047872 1000026055 1000037770 1000039658 1000048041 1000048191 1000048164 1000048383 1000048384 1000039792 1000048512 1000048508 1000048985 1000041420 1000049082 1000049085 1000049114 1000049154 1000049224 1000049399 1000045610 1000049999 1000049835 1000050236 1000050396 1000048192 1000050509 1000050624 1000049008 1000050216 1000050580 1000050118 1000049521 1000050957 1000050969 1000051043 1000051103 1000051231 1000051442 1000050746 1000051473 1000049448 1000038011 1000048163 1000051875 1000052088 1000052100 1000051896 1000052184 1000051867 1000052287 1000052289 1000052431 1000051960 1000051047 1000050975 1000052684 1000052778 1000052794 1000010492 1000052930 1000052932 1000053012 1000048794 1000053098 1000037529 1000052715 1000053438 1000053440 1000053446 1000053180 1000053512 1000053530 1000053624 1000022917 1000053853 1000019143 1000050604 1000022813 1000054404 1000054446 1000053463 1000054622 1000054665 1000054785 1000054865 1000054837 1000050540 1000054151 1000054070 1000000862 1000056242 1000056269 1000030125 1000052514 1000057125 1000055043 1000057132 1000052222 1000045710 1000057578 1000041523 1000054640 1000057882 1000056598 1000056394 1000059363 1000059454 1000059588 1000056375 1000053504 1000060501 1000060502 1000060741 1000060742 1000060835 1000059456 1000060992 1000060993 1000060990 1000061232 1000059299 1000061693 1000061745 1000052500 1000057292 1000063691 1000033359 1000064037 1000064266 1000064398 1000064433 1000064758 1000064695 1000064816 1000065137 1000065153 1000065529 1000065425 1000066128 1000065701 194820 ] |
|
122.17 ms (7.15%) |
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:
[
"25831-elastiques-couleur-n-c-fel000692"
]
|
|
4.67 ms (0.27%) |
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:
[
194820
]
|
|
3.39 ms (0.20%) |
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
]
|
|
2.15 ms (0.13%) |
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.71 ms (0.04%) |
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 256 194820 ] |
|
0.68 ms (0.04%) |
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:
[
"25831-elastiques-couleur-n-c-fel000692"
]
|
|
0.43 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:
[ 194820 1 ] |
|
0.43 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_.slug = ?
Parameters:
[
"25831-elastiques-couleur-n-c-fel000692"
]
|
|
0.32 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:
[
194820
]
|
|
0.25 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 | 849 |
| App\Entity\Customer\Customer | 321 |
| App\Entity\User\User | 235 |
| App\Entity\Delivery\Delivery | 219 |
| App\Entity\Catalog\ProductCatalog | 133 |
| App\Entity\Catalog\CustomerCatalog | 133 |
| App\Entity\Product\Market | 61 |
| App\Entity\Product\ProductPrice | 48 |
| App\Entity\Pricing\Price | 48 |
| App\Entity\Internal\Commercial | 30 |
| App\Entity\Product\Product | 21 |
| App\Entity\Product\Category | 21 |
| App\Entity\Product\Characteristic | 11 |
| App\Entity\Product\CharacteristicLabel | 11 |
| App\Entity\Delivery\DeliveryCost | 6 |
| App\Entity\Internal\Society | 4 |
| App\Entity\Internal\Parameter | 1 |