Query Metrics
46
Database Queries
20
Different statements
825.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
468.10 ms (56.73%) |
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:
[ 6347857 6358230 6358177 6361665 6361839 6361849 6362117 6362127 6362138 6364027 6364548 6367444 6373176 6385117 6385913 6382595 6386739 6387984 6390469 6392835 6393417 6393484 6393640 6394029 6394466 6394624 6396416 6396418 6400726 6402616 6403156 6403194 6405744 6405745 6405746 6405747 6405748 6405749 6405750 6405751 6405752 6405753 6405754 6405755 6405756 6405757 6405758 6405759 6405760 6405761 6405762 6405764 6405765 6405766 6405767 6405768 6405769 6405770 6405772 6405773 6405774 6405775 6405776 6405777 6405778 6405779 6405780 6405781 6405782 6405783 6406282 6407279 6407280 6407281 6407282 6407283 6407284 6407286 6407287 6407288 6407289 6407290 6407291 6407292 6407293 6407294 6407295 6407296 6407297 6407298 6407299 6407300 6407301 6407302 6407303 6407304 6407305 6407306 6407307 6407308 6407309 6407310 6407312 6407313 6407314 6407315 6407316 6407318 6407319 6407320 6408915 6411799 6411800 6412636 6413749 6413897 6413900 6413904 6414558 6416117 6418171 6418380 6419284 6419340 6419354 6419371 6420646 6422649 6424344 6425378 6425538 6426346 6428751 6429489 6429619 6434087 6434092 6434136 6434139 6434141 6434144 6434151 6434153 6434157 6434161 6434173 6434169 6434179 6434189 6434190 6434193 6434870 6434872 6435466 6435673 6435674 6435690 6435693 6435708 6435714 6436829 6436903 6436994 6436995 6437013 6437014 6437021 6437022 6437046 6437047 6437085 6437089 6437100 6437103 6438446 6439007 6439011 6439053 6439057 6439062 6439066 6439129 6439132 6439152 6439154 6439175 6439176 6439199 6439202 6440203 6440209 6440359 6442019 6442024 6442088 6442262 6442295 6442458 6442545 6443275 6443447 6443450 6443516 6443524 6443532 6443549 6443554 6443885 6444643 6446201 6446234 6446648 6446653 6446655 6446656 6446657 6447374 6448866 6448906 6449062 6449126 6449525 6449728 6449885 6450674 6450989 6450994 6450999 6451248 6452086 6452175 6452176 6454811 6454885 6455610 6455897 6458430 6461641 6461661 6461669 6461829 6463231 6463332 6463333 6463334 6463335 6463336 6463337 6463338 6463339 6463340 6463341 6463343 6463344 6463345 6463346 6463347 6463348 6463349 6463350 6463351 6463352 6463353 6467882 6467883 6467884 6467885 6467886 6467887 6467888 6467889 6467890 6467891 6467892 6467893 6467894 6467895 6467896 6467897 6467898 6467900 6467901 6467902 6467903 6467904 6468700 6468703 6468884 1000002104 1000002718 1000002120 1000004999 1000005101 1000011034 1000011861 1000012598 1000013427 1000012768 1000017150 1000009779 1000018769 1000020534 1000020536 1000020537 1000020542 1000016153 1000022722 1000023824 1000023828 1000023830 1000023886 1000023887 1000023888 1000023889 1000023890 1000023891 1000023892 1000023893 1000023957 1000023958 1000023959 1000023960 1000023961 1000023962 1000023965 1000023966 1000023969 1000023973 1000023983 1000023985 1000024140 1000024141 1000024142 1000024536 1000024550 1000024551 1000024552 1000024553 1000024554 1000024555 1000024556 1000024557 1000024558 1000024559 1000024560 1000024561 1000024562 1000024564 1000024608 1000024609 1000024610 1000024612 1000024641 1000025088 1000025090 1000025096 1000025097 1000025099 1000025101 1000025102 1000025103 1000025104 1000025105 1000025106 1000025107 1000025110 1000025111 1000025112 1000025114 1000025117 1000025120 1000025121 1000025126 1000025142 1000025143 1000025144 1000025145 1000025146 1000025147 1000025148 1000025149 1000025150 1000025153 1000025154 1000025155 1000025156 1000025158 1000025290 1000025291 1000025294 1000025300 1000025301 1000025306 1000026053 1000026068 1000026077 1000026115 1000026116 1000026117 1000026118 1000026119 1000026120 1000026209 1000026219 1000026479 1000026480 1000026481 1000006166 1000010115 1000013934 1000026706 1000026707 1000026708 1000026709 1000026710 1000026711 1000026712 1000026713 1000026715 1000026716 1000026717 1000026718 1000026719 1000026720 1000026721 1000026723 1000026724 1000026725 1000026727 1000026729 1000026730 1000026731 1000026733 1000026734 1000026736 1000026738 1000026769 1000010752 1000026826 1000026887 1000026965 1000026996 1000027511 1000027575 1000027638 1000027664 1000027668 1000027671 1000027673 1000027688 1000027689 1000027691 1000027693 1000027694 1000027696 1000027700 1000027704 1000027705 1000027706 1000027710 1000027711 1000027713 1000027716 1000027717 1000027718 1000027720 1000027723 1000027725 1000027728 1000027729 1000027730 1000027733 1000027739 1000027742 1000027745 1000027747 1000027750 1000027751 1000027753 1000027758 1000027788 1000027875 1000028319 1000028321 1000028322 1000028323 1000028324 1000028325 1000028326 1000028327 1000028328 1000028335 1000028336 1000028434 1000028449 1000028779 1000028781 1000028782 1000028787 1000028792 1000028795 1000029140 1000029141 1000029142 1000029144 1000029146 1000029155 1000029501 1000030250 1000030251 1000030252 1000030253 1000030254 1000030255 1000030256 1000030257 1000030258 1000030259 1000030260 1000030261 1000030262 1000030263 1000030264 1000030265 1000030266 1000030267 1000030268 1000030269 1000030270 1000030271 1000030272 1000030273 1000030274 1000030281 1000030282 1000030283 1000030284 1000030285 1000030286 1000030360 1000030361 1000030362 1000030363 1000030366 1000030377 1000030482 1000030751 1000030754 1000030755 1000030764 1000030768 1000030769 1000030770 1000030771 1000030772 1000030773 1000030775 1000030792 1000030797 1000010418 1000012014 1000031689 1000031691 1000031692 1000031695 1000031701 1000031702 1000031704 1000031717 1000031995 1000031996 1000031998 1000031999 1000032000 1000032001 1000032002 1000032005 1000032006 1000032015 1000032017 1000032029 1000032034 1000032592 1000032594 1000032636 1000032652 1000032777 1000032791 1000032804 1000032805 1000032806 1000032807 1000032808 1000032809 1000032810 1000032811 1000032812 1000032813 1000032814 1000032815 1000032816 1000032956 1000032957 1000032959 1000032960 1000032961 1000032963 1000032964 1000032965 1000032966 1000032967 1000032968 1000032970 1000032972 1000032975 1000032976 1000032977 1000032978 1000032979 1000032980 1000032981 1000032982 1000032983 1000032984 1000032985 1000032986 1000032987 1000032988 1000032989 1000033005 1000033008 1000033010 1000033284 1000033289 1000033290 1000033291 1000033292 1000033293 1000033294 1000033300 1000033301 1000033744 1000034897 1000034899 1000034902 1000034903 1000034904 1000034905 1000034911 1000034912 1000034913 1000034914 1000034916 1000034918 1000035020 1000035382 1000035673 1000035674 1000035675 1000035676 1000035677 1000035678 1000035807 1000035824 1000035831 1000035832 1000035838 1000035840 1000035841 1000035846 1000035848 1000035849 1000035850 1000035865 1000036839 1000036840 1000037312 1000037313 1000037314 1000037315 1000037316 1000037317 1000037318 1000037321 1000037324 1000037390 1000037392 1000037393 1000037394 1000037395 1000037396 1000037397 1000037398 1000037399 1000037401 1000037404 1000037437 1000037438 1000037439 1000037440 1000037441 1000037442 1000037443 1000037444 1000037445 1000037446 1000037454 1000037455 1000037456 1000037457 1000037458 1000037459 1000037460 1000037462 1000037463 1000037464 1000037465 1000037530 1000037532 1000038164 1000038165 1000038166 1000038171 1000038172 1000038173 1000038174 1000038176 1000038177 1000038339 1000038416 1000038417 1000038435 1000038436 1000038447 1000038448 1000038449 1000038450 1000038452 1000038453 1000038454 1000038455 1000038456 1000038457 1000038458 1000038459 1000038460 1000038461 1000038462 1000038463 1000038464 1000038465 1000038466 1000038467 1000038468 1000038469 1000038470 1000038471 1000038472 1000038473 1000038474 1000038475 1000038476 1000038477 1000038484 1000038485 1000038486 1000038487 1000038488 1000038489 1000038490 1000038491 1000038492 1000038493 1000038494 1000038495 1000038496 1000038497 1000038498 1000038499 1000038500 1000038501 1000038502 1000038503 1000038504 1000038505 1000038506 1000038507 1000038509 1000038510 1000038511 1000038512 1000038513 1000038514 1000038515 1000038516 1000038517 1000038518 1000038522 1000038526 1000038527 1000038529 1000038531 1000038540 1000038541 1000038542 1000038543 1000038544 1000038545 1000038546 1000038547 1000038549 1000038550 1000038551 1000038552 1000038553 1000038555 1000038596 1000038597 1000038601 1000038607 1000038611 1000038613 1000038617 1000038741 1000038743 1000038744 1000038747 1000038758 1000038808 1000038809 1000038810 1000038811 1000038812 1000038813 1000038814 1000038815 1000038816 1000038817 1000038818 1000038819 1000038820 1000038821 1000038822 1000038823 1000038824 1000038825 1000038826 1000038827 1000038840 1000038841 1000038842 1000038843 1000038844 1000038960 1000039000 1000039001 1000039030 1000039031 1000039032 1000039033 1000039034 1000039035 1000039036 1000039037 1000039038 1000039039 1000039040 1000039041 1000039043 1000039044 1000039045 1000039054 1000039055 1000039062 1000039063 1000039073 1000039074 1000039077 1000039079 1000039084 1000039085 1000039086 1000039099 1000039100 1000039101 1000039103 1000039105 1000039106 1000039107 1000039119 1000039120 1000039165 1000039166 1000039168 1000039169 1000039170 1000039171 1000039172 1000039173 1000039174 1000039175 1000039176 1000039177 1000039178 1000039180 1000039181 1000039182 1000039183 1000039188 1000039190 1000039191 1000039192 1000039205 1000039319 1000040035 1000040036 1000040040 1000040041 1000040042 1000040043 1000040046 1000040051 1000040053 1000040054 1000040055 1000040056 1000040057 1000040059 1000040060 1000040061 1000040062 6376593 1000045012 1000048012 1000047950 1000049183 1000049184 1000049346 1000048487 1000051432 1000051563 1000051831 1000052096 1000052097 1000052248 1000052588 1000052777 1000010492 183568 ] |
|
235.53 ms (28.54%) |
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:
[ 183568 "2025-02-12 12:01:03" ] |
|
107.56 ms (13.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, 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:
[
"24587-carnets-et-repertoires-couleur-n-c-24587-maju"
]
|
|
3.70 ms (0.45%) |
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
]
|
|
1.77 ms (0.21%) |
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:
[ 41 189 190 191 192 193 194 195 193 183568 ] |
|
1.17 ms (0.14%) |
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:
[ 183568 1 ] |
|
1.12 ms (0.14%) |
5 |
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.90 ms (0.11%) |
2 |
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" 183568 ] |
|
0.79 ms (0.10%) |
1 |
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 <= ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC LIMIT 1
Parameters:
[ 183568 0 ] |
|
0.60 ms (0.07%) |
1 |
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.product_id = ? AND t0.price_id = ? LIMIT 1
Parameters:
[ 183568 "C" ] |
|
0.57 ms (0.07%) |
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 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"24587-carnets-et-repertoires-couleur-n-c-24587-maju"
]
|
|
0.52 ms (0.06%) |
3 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"C"
]
|
|
0.48 ms (0.06%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.affiliated_society AS affiliated_society_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.zip_code AS zip_code_7, t0.city AS city_8, t0.email AS email_9, t0.phone_number AS phone_number_10, t0.fax AS fax_11, t0.id_deposit AS id_deposit_12, t0.gen_code AS gen_code_13, t0.newspaper AS newspaper_14, t0.siren AS siren_15, t0.ape AS ape_16, t0.trading_registry AS trading_registry_17, t0.internal_tva AS internal_tva_18, t0.rib AS rib_19, t0.general_account AS general_account_20, t0.capital AS capital_21 FROM society t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"MOZ"
]
|
|
0.47 ms (0.06%) |
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.40 ms (0.05%) |
2 |
SELECT t0.id AS id_1, t0.promotion_id AS promotion_id_2, t0.society_id AS society_id_3 FROM society_promotion t0 WHERE t0.promotion_id = ?
Parameters:
[
197611
]
|
|
0.37 ms (0.05%) |
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:
[
"24587-carnets-et-repertoires-couleur-n-c-24587-maju"
]
|
|
0.35 ms (0.04%) |
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 LEFT JOIN product_price p2_ ON d0_.product_price_id = p2_.id WHERE p1_.id = ? AND p2_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[ 183568 9958429 ] |
|
0.26 ms (0.03%) |
1 |
SELECT d0_.quantity AS quantity_0, d0_.price_ht AS price_ht_1, d0_.price_ttc AS price_ttc_2 FROM decreasing_price d0_ WHERE d0_.product_id = ? AND d0_.market_id IS NULL AND d0_.product_price_id IS NULL AND d0_.promotion_id IS NULL ORDER BY d0_.quantity DESC
Parameters:
[
183568
]
|
|
0.26 ms (0.03%) |
1 |
SELECT p0_.id AS id_0, p0_.label_reduction AS label_reduction_1, p0_.description_reduction AS description_reduction_2, p0_.product_id AS product_id_3, p0_.operation_id AS operation_id_4 FROM product_reduction_label p0_ INNER JOIN operation o1_ ON p0_.operation_id = o1_.id WHERE o1_.is_active = 1 AND o1_.end_date >= ? AND o1_.is_active = 1 AND o1_.view_by LIKE ? AND p0_.product_id = ?
Parameters:
[ "2025-07-12 12:01:04" "%2%" 183568 ] |
|
0.26 ms (0.03%) |
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:
[
183568
]
|
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.