Query Metrics
100
Database Queries
16
Different statements
3739.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2875.01 ms (76.88%) |
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:
[ 9797 "2024-11-04 22:48:45" ] |
|
657.45 ms (17.58%) |
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:
[ 6245648 6237540 6231203 6243566 6257279 6257403 6257461 6257802 6257924 6257912 6258152 6258178 6258479 6242192 6259085 6259251 6259263 6259360 6259400 6259877 6259894 6259990 6256033 6260006 6260007 6260048 6260195 6260470 6260471 6260504 6260365 6235368 6261081 6261097 6261186 6261693 6261785 6262109 6232212 6256213 6262528 6262372 6243218 6150813 6237455 6224531 6263218 6263323 6263634 6260849 6263925 6264476 6264506 6264757 6264759 6264877 6264885 6264893 6264998 6264403 6239284 6257759 6265443 6264895 6265540 6265600 6265394 6265736 6247390 6262822 6265886 6266097 6266098 6266125 6266280 6266468 6266544 6266795 6266863 6267060 6267330 6267342 6265307 6267394 6267415 6267430 6259421 6262855 6264950 6267114 6246506 6262274 6267666 6264660 6268089 6268140 6268157 6268195 6267406 6268421 6268595 6268647 6268881 6268892 6269191 6269239 6266362 6269392 6269584 6269599 6229930 6243731 6261051 6266061 6262363 6270273 6270469 6270520 6270648 6270657 6270573 6270749 6270750 6271136 6271252 6271344 6271518 6271595 6271669 6226003 6271728 6270089 6272259 6272371 6272619 6272711 6272895 6267953 6273060 6273417 6270624 6273937 6274103 6274351 6274592 6274426 6271718 6274652 6274654 6274661 6274698 6273426 6274982 6275033 6275071 6269058 6275206 6275356 6275451 6275634 6275690 6275722 6275911 6276078 6276224 6276309 6275888 6276460 6276555 6276848 6277030 6277263 6276636 6277883 6266194 6278296 6278471 6278869 6279236 6279319 6279372 6279496 6279535 6279770 6279817 6280037 6280104 6280118 6280302 6280438 6280443 6280996 6281027 6281093 6281108 6281179 6281201 6281247 6281260 6281288 6281309 6281428 6281503 6281794 6281820 6281852 6281959 6281994 6282098 6282102 6282181 6282262 6282601 6282615 6282639 6282685 6282795 6282840 6282882 6282892 6282900 6282901 6283084 6283091 6283098 6283111 6283240 6283241 6283286 6283299 6283383 6283414 6283421 6283620 6283662 6283689 6283698 6283738 6283818 6283879 6284077 6284205 6284297 6284371 6284436 6284565 6284612 6284741 6285018 6285062 6285137 6285208 6285295 6285342 6285388 6285574 6285812 6285940 6286125 6286175 6286303 6286360 6286658 6286709 6286735 6286769 6286912 6286958 6287201 6287218 6287377 6287500 6287535 6287689 6287703 6287765 6287767 6287777 6288389 6288560 6288991 6277718 6289878 6275463 6290700 6288512 6291107 6291270 6291316 6291470 6291725 6291809 6291964 6274412 6292314 6202989 6292408 6292418 6292843 6292888 6290318 6293020 6293049 6293197 6292630 6293323 6293337 6293367 6293898 6294216 6294592 6294627 6293970 6295057 6295185 6294837 6295244 6295730 6295851 6296598 6296688 6296848 6297038 6297137 6297184 6297207 6297402 6297426 6297239 6293685 6297860 6297881 6298446 6298657 6298713 6299498 6299002 6299767 6300014 6300106 6300821 6301279 6301689 6301869 6302111 6302341 6302421 6302423 6302591 6302656 6302668 6302773 6302866 6302868 6302934 6303337 6303523 6303602 6303912 6303941 6304347 6304348 6304473 6304497 6304521 6304533 6304749 6304756 6304864 6304995 6305092 6305269 6305281 6305347 6305349 6305382 6305431 6305605 6305619 6305703 6305808 6305951 6306215 6306247 6306517 6306882 6307323 6307353 6307366 6307547 6307594 6307603 6307738 6308014 6308275 6308368 6308652 6308682 6309099 6309308 6309386 6309425 6309623 6309662 6309753 6309774 6309847 6297257 6310275 6310676 6310715 6310737 6311432 6311469 6311543 6311574 6311664 6311865 6311987 6310629 6312186 6312409 6312513 6312517 6312025 6312812 6313182 6313489 6313542 6313591 6313595 6313637 6313123 6314054 6297945 6314098 6314313 6314385 6314604 6314679 6315195 6315458 6315601 6310862 6315967 6315647 6315995 6315748 6316182 6316193 6316194 6316744 6317988 6318659 6318834 6318906 6313932 6313528 6319516 6319804 6319883 6319885 6319189 6320010 6320044 6320305 6320301 6320412 6320837 6320959 6320374 6321282 6321578 6321661 6321667 6321649 6322068 6322136 6322164 6322181 6322318 6322401 6323391 6320183 6323941 6324090 6324098 6324123 6205365 6317737 6324439 6324512 6324709 6324868 6325247 6325256 6325330 6325389 6325666 6325903 6325933 6325958 6320553 6326070 6316948 6326095 6326649 6326833 6326965 6327178 6327227 6327288 6327464 6327511 6327640 6327722 6327724 6327780 6327842 6327911 6327983 6328003 6328143 6328234 6328279 6328305 6328338 6328359 6328395 6328419 6328452 6328465 6328478 6328480 6328596 6328675 6328688 6328953 6328984 6329013 6329032 6329033 6329048 6329088 6329217 6329226 6329294 6329328 6329599 6329687 6329716 6329804 6329840 6329845 6329849 6329917 6330202 6330416 6330456 6330508 6330640 6330690 6330915 6330738 6315113 6331392 6331397 6331493 6331590 6331625 6331974 6332006 6332096 6332182 6332098 6320235 6332244 6316264 6332487 6332706 6325658 6332992 6333073 6333114 6323785 6333217 6333234 6333794 6333907 6333909 6333919 6334133 6334144 6319916 6333872 6334210 6334350 6334478 6303942 6335124 6335779 6335798 6335928 6335844 6337188 6337258 6337164 6336425 6337078 6337430 6337960 6337966 6337985 6338016 6314704 6338464 6338595 6338623 6338938 6338970 6338164 6340045 6340224 6340381 6340322 6340560 6340601 6340773 6341003 6341009 6333733 6341108 6341153 6340453 6341405 6341463 6341478 6341658 6341688 6341934 6341995 6342142 6321456 6343049 6343144 6343402 6343577 6342737 6343240 6343898 6344063 6344069 6344205 6344343 6321728 6333749 6335467 6335507 6335543 6335621 6335735 6335778 6336566 6336672 6337249 6344872 6344878 6344857 6345056 6345083 6345505 6342088 6345515 6343444 6345567 6345593 6345653 6345687 6345693 6345721 6345723 6345844 6346015 6346040 6346057 6346069 6346115 6346159 6346193 6346206 6346711 6346773 6346781 6347261 6347265 6347297 6347387 6347392 6347422 6347452 6347605 6347631 6347744 6348020 6348067 6348124 6348306 6348335 6348504 6348656 6348658 6348676 6348777 6348801 6348860 6348891 6348939 6348944 6348991 6349090 6349324 6349335 6349420 6349425 6349427 6349434 6349528 6349529 6349535 6349539 6349597 6349675 6349757 6349785 6349816 6349930 6349955 6350099 6350329 6350745 6344576 6351163 6351219 6352065 6342932 6352124 6342982 6352425 6352442 6352551 6352554 6352653 6352693 6352961 6342209 6353230 6353287 6353337 6353440 6353676 6353744 6353988 6354044 6353994 6354078 6354204 6354265 6354278 6354438 6354796 6355071 6355103 6355802 6355864 6355872 6356095 6355441 6353957 6354823 6330409 6356800 6356875 6357234 6357269 6357229 6354441 6357913 6357989 6358062 6358083 6358155 6358248 6358449 6358591 6357070 6358741 6358846 6357577 6359184 6359527 6359564 6345645 6346364 6359911 6358033 6360050 6360107 6360153 6360271 6358372 6274338 6360482 6360539 6360552 6360559 6334929 6361254 6361353 6361542 6360138 6361894 6361978 6362341 6362360 6362506 6358366 6362829 6363222 6363227 6363543 6363573 6334636 6363711 6363951 6364521 6364549 6364666 6353943 6364838 6365159 6365124 6365482 6365490 6365657 6366193 6366232 6354440 6366565 6366799 6366849 6367034 6367496 6265119 6367894 6367813 6368118 6368368 6368659 6368675 6368935 6369032 6369041 6369130 6369153 6369246 6369278 6369282 6369290 6369385 6369495 6369747 6369861 6370253 6370284 6370374 6370432 6370525 6370621 6370740 6370847 6371156 6371288 6371310 6371323 6371356 6371366 6371420 6371473 6371524 6371562 6371592 6371607 6371645 6371696 6371895 6371994 6372070 6372083 6372270 6372413 6372421 6372578 6372592 6372697 6372729 6372731 6372777 6372780 6372812 6372834 6372841 6373028 6373206 6373283 6373542 6373663 6373842 6374182 6374285 6374683 6374712 6374884 6374653 6360466 6376236 6376335 9797 ] |
|
157.64 ms (4.22%) |
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:
[
"42880-adhesifs-couleur-3m-5501933f"
]
|
|
18.19 ms (0.49%) |
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" 9797 ] |
|
10.28 ms (0.27%) |
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:
[ 571 7 ] |
|
6.24 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:
[ 9797 0 ] |
|
4.07 ms (0.11%) |
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:
[
571
]
|
|
3.30 ms (0.09%) |
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:
[ 9797 1 ] |
|
1.88 ms (0.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_ 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:
[ 56 265 266 267 268 269 265 9797 ] |
|
1.21 ms (0.03%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.displayed_order AS displayed_order_2, c0_.is_in_footer AS is_in_footer_3, c0_.slug AS slug_4, c1_.id AS id_5, c1_.name AS name_6, c1_.displayed_order AS displayed_order_7, c1_.is_in_footer AS is_in_footer_8, c1_.slug AS slug_9, c2_.id AS id_10, c2_.name AS name_11, c2_.displayed_order AS displayed_order_12, c2_.is_in_footer AS is_in_footer_13, c2_.slug AS slug_14, c0_.category_parent_id AS category_parent_id_15, c1_.category_parent_id AS category_parent_id_16, c2_.category_parent_id AS category_parent_id_17 FROM category c0_ LEFT JOIN category c1_ ON c0_.id = c1_.category_parent_id LEFT JOIN category c2_ ON c1_.id = c2_.category_parent_id WHERE c0_.category_parent_id IS NULL
Parameters:
[] |
|
1.17 ms (0.03%) |
6 |
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:
[
56
]
|
|
1.11 ms (0.03%) |
1 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
|
0.60 ms (0.02%) |
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.52 ms (0.01%) |
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:
[
9797
]
|
|
0.42 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.id = ? LIMIT 1
Parameters:
[
1
]
|
|
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
]
|
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.