Query Metrics
99
Database Queries
16
Different statements
1712.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1027.59 ms (59.99%) |
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:
[ 70730 "2024-11-04 22:03:59" ] |
|
446.19 ms (26.05%) |
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:
[ 6245180 6245726 6259063 6261517 6262915 6263027 6263373 6263663 6264221 6263980 6264826 6223348 6265052 6265230 6265505 6265894 6266034 6265723 6266250 6266418 6266474 6263148 6267361 6267374 6232580 6268061 6260783 6268309 6268436 6268598 6268724 6268795 6269835 6269916 6270210 6270442 6264206 6270658 6271010 6271355 6272165 6272228 6271421 6256352 6264876 6267077 6272504 6272953 6272968 6273008 6273066 6273944 6274092 6274396 6274748 6274871 6275192 6275730 6275812 6275916 6276000 6276075 6276183 6276709 6276831 6276286 6277282 6274512 6278281 6278301 6278823 6279241 6279757 6279881 6279882 6279885 6280061 6280195 6280902 6280924 6281014 6281198 6281528 6281530 6281842 6281965 6282012 6282220 6282261 6282601 6283108 6283279 6283450 6283453 6283470 6283476 6283482 6283487 6283491 6283506 6285917 6286548 6286935 6287007 6287134 6287421 6287520 6287659 6289094 6290676 6290682 6291322 6291998 6292123 6292932 6293820 6293875 6294110 6294151 6294382 6294620 6294615 6294817 6294829 6267483 6295064 6295034 6295206 6295671 6295697 6293358 6296717 6296768 6296845 6296996 6293712 6297184 6297207 6297279 6297736 6297803 6297858 6297877 6298047 6298195 6298199 6298011 6298446 6296195 6298703 6298732 6298758 6298745 6299103 6299294 6299327 6299335 6294231 6300290 6299522 6293667 6298447 6301710 6301818 6301867 6302047 6302067 6302148 6302333 6303234 6303420 6303593 6303659 6303674 6304032 6304179 6304774 6304780 6304786 6305281 6305351 6305405 6305463 6305568 6305921 6305924 6306317 6306367 6306409 6306517 6306781 6306819 6307100 6307133 6307137 6307165 6307176 6307177 6307191 6307234 6307322 6308017 6308345 6308381 6308459 6308476 6308519 6308797 6308887 6309014 6309349 6309380 6309709 6309787 6309857 6310358 6310574 6310652 6310897 6310907 6311643 6312056 6312132 6298251 6312377 6312742 6312842 6313082 6313164 6313204 6313470 6313529 6313555 6311938 6313821 6313863 6314263 6314298 6314336 6314392 6314467 6314547 6314622 6314648 6312693 6296645 6314851 6314978 6315389 6315411 6315427 6315718 6315962 6316143 6316234 6316283 6316769 6314807 6317252 6317627 6317743 6318038 6318174 6318305 6318660 6319579 6319808 6319614 6320554 6318727 6319205 6321404 6321552 6321672 6321947 6322649 6322952 6323241 6323687 6324104 6324110 6324489 6321425 6320687 6318257 6313593 6317833 6325134 6325196 6325198 6325223 6325283 6323294 6325648 6325897 6326194 6326258 6326260 6326513 6326578 6326644 6326661 6326754 6326913 6326961 6327327 6327528 6327659 6327666 6327867 6327907 6328033 6328199 6328390 6328704 6328790 6328792 6328794 6328805 6328808 6328810 6328847 6328854 6328951 6329300 6329731 6329742 6329867 6330047 6330143 6330302 6330546 6317840 6331711 6332005 6323132 6323098 6323085 6323070 6320733 6332453 6316264 6332485 6332492 6332495 6332609 6332629 6333050 6333573 6334133 6334201 6334275 6324082 6334679 6334862 6334914 6334963 6333305 6335088 6335145 6335194 6335302 6335360 6335375 6335473 6335404 6335824 6335924 6335940 6333179 6336164 6336201 6336220 6335614 6336372 6336602 6336944 6336995 6337006 6322317 6337700 6337989 6338378 6339194 6339761 6339898 6340024 6340222 6340457 6340696 6325327 6322449 6322471 6331021 6331295 6332712 6340835 6340874 6340962 6341037 6341045 6341047 6324386 6341247 6341268 6341336 6341596 6341697 6341721 6341742 6341845 6341987 6342087 6342306 6342540 6343085 6343467 6343501 6343621 6270106 6321728 6334542 6334984 6335484 6335621 6335735 6335778 6336635 6336681 6337245 6337520 6337930 6337935 6337941 6344821 6344881 6344926 6345214 6345185 6345500 6345508 6345510 6345567 6345571 6345654 6345655 6345682 6345687 6345692 6345709 6345721 6346175 6346206 6346711 6346795 6346875 6346880 6346932 6347087 6347233 6347530 6347645 6347857 6347984 6348083 6348117 6348269 6348399 6348626 6348920 6349008 6349090 6349129 6349133 6349152 6349168 6349170 6349171 6349177 6349298 6349302 6350112 6350458 6350496 6350498 6350499 6350541 6350556 6350558 6351275 6351614 6351773 6351635 6351988 6352146 6352388 6352391 6352483 6352537 6336529 6352819 6352987 6353119 6353210 6353285 6353424 6353819 6354108 6354664 6354704 6354739 6354803 6354910 6354929 6354941 6355108 6355199 6355338 6334826 6355380 6353975 6355494 6355504 6355706 6355889 6356174 6356182 6356567 6356902 6357145 6357232 6357347 6357459 6357488 6357246 6358556 6358894 6357730 6359182 6358296 6359707 6360260 6360496 6360788 6360981 6358452 6361276 6361322 6361610 6361771 6361848 6361934 6334633 6362078 6362089 6362125 6362227 6362294 6362418 6362496 6362601 6362659 6362661 6342426 6352347 6362766 6342762 6360463 6363186 6363220 6363270 6363390 6363392 6363411 6363464 6363741 6363851 6363968 6364386 6364426 6364464 6364529 6362657 6365537 6365622 6363892 6366594 6366758 6366873 6367111 6367118 6367270 6368415 6367523 6368752 6369027 6369155 6369352 6369428 6369432 6369553 6369564 6369622 6369692 6369772 6370114 6370126 6370411 6370570 6370697 6370859 6370860 6370987 6371237 6371640 6371672 6371728 6371739 6371745 6371747 6371756 6371764 6371773 6371783 6371784 6371828 6371904 6372247 6372264 6372277 6372788 6372840 6372880 6373055 6373056 6373119 6373177 6373440 6373574 6373663 6373691 6375856 6376125 6376514 6376654 6376795 6376882 6376931 6376961 6377032 70730 ] |
|
196.25 ms (11.46%) |
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:
[
"63014-marqueurs-effacables-noir-n-c-63014-first"
]
|
|
10.24 ms (0.60%) |
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:
[ 139 7 ] |
|
9.97 ms (0.58%) |
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" 70730 ] |
|
6.57 ms (0.38%) |
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:
[ 70730 0 ] |
|
5.69 ms (0.33%) |
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:
[ 70730 1 ] |
|
3.65 ms (0.21%) |
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:
[
139
]
|
|
1.41 ms (0.08%) |
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"
]
|
|
1.23 ms (0.07%) |
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:
[] |
|
1.09 ms (0.06%) |
1 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
|
1.08 ms (0.06%) |
5 |
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:
[
58
]
|
|
0.64 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 LIMIT 10
Parameters:
[ 58 275 276 277 278 275 70730 ] |
|
0.55 ms (0.03%) |
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:
[
70730
]
|
|
0.44 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.33 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.is_in_footer = ?
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.