Query Metrics
28
Database Queries
11
Different statements
2177.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
995.82 ms (45.73%) |
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:
[ 547 "2025-02-12 09:20:08" ] |
|
986.58 ms (45.31%) |
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:
[ 6338032 6337278 6314704 6338595 6338669 6338376 6339510 6339556 6339625 6339685 6339001 6340063 6332459 6340459 6340586 6332712 6333590 6335082 6341068 6341153 6341478 6341630 6341697 6341768 6341982 6343789 6344080 6325195 6344932 6344968 6345155 6345885 6346140 6346251 6345274 6346896 6346933 6347392 6347397 6347414 6347721 6348015 6348043 6348081 6348158 6348232 6348266 6348389 6348390 6348451 6348481 6348745 6348771 6348864 6348991 6349063 6349315 6349317 6349323 6349505 6349538 6349572 6349592 6349719 6349796 6349838 6349983 6350055 6350074 6350396 6350444 6350473 6350558 6350656 6350903 6351340 6351170 6351657 6353182 6353308 6351861 6353738 6354616 6354666 6354739 6355176 6312761 6355380 6355897 6356239 6356943 6357133 6357428 6357453 6357901 6358277 6355933 6359202 6359504 6361604 6361647 6362423 6362506 6362563 6363015 6363442 6363785 6363265 6364326 6364521 6364557 6364707 6365109 6358195 6365816 6365949 6366788 6359386 6366560 6367136 6368246 6368740 6369032 6369138 6369465 6369490 6369566 6369983 6370184 6370332 6370339 6370476 6370698 6371036 6371114 6371388 6371439 6372087 6372264 6372461 6373003 6373188 6373202 6373283 6373285 6373903 6373953 6368302 6368796 6374138 6374183 6374371 6374611 6374290 6374838 6374878 6368965 6374404 6368472 6375286 6368926 6375202 6375764 6375917 6376019 6376060 6376245 6374613 6375554 6376481 6376505 6376596 6377257 6377312 6376793 6375251 6377629 6376247 6377913 6377965 6351447 6362779 6378565 6378965 6379875 6380024 6380119 6380375 6380809 6381258 6381482 6377147 6367103 6381954 6382201 6382226 6382227 6382690 6382764 6383109 6378215 6383720 6380583 6383737 6384803 6385068 6385524 6385438 6386515 6386700 6386807 6379280 6388625 6388802 6388916 6388985 6388995 6389034 6389065 6389421 6389464 6389826 6390182 6390457 6390491 6390562 6385519 6391060 6391502 6390792 6391960 6392248 6390654 6393122 6393144 6393658 6393734 6393267 6394176 6394196 6395715 6395771 6395818 6395871 6396196 6396356 6396363 6396473 6396619 6396633 6396896 6396900 6397009 6397072 6397195 6397365 6397373 6397404 6397482 6397543 6398020 6398069 6398074 6398079 6398168 6398170 6398692 6398693 6398982 6399210 6399447 6399494 6399508 6399512 6399698 6400449 6401526 6401671 6401802 6401903 6403661 6404355 6404608 6405128 6405468 6406315 6406490 6406638 6407582 6407656 6409400 6409452 6409469 6409478 6409575 6409627 6409704 6410046 6410095 6410127 6410426 6410708 6410867 6410875 6411099 6411314 6411512 6411620 6411811 6411822 6412015 6412150 6412614 6413024 6413068 6413075 6413366 6413427 6413768 6414246 6414471 6414583 6414685 6415635 6415649 6415891 6415953 6415954 6416115 6416270 6416406 6416655 6416757 6416829 6416977 6417089 6417103 6417256 6417418 6417539 6417644 6417718 6417863 6418023 6418096 6418206 6418479 6418536 6418779 6418843 6418893 6418975 6418981 6419296 6419371 6419541 6419693 6419702 6419914 6419916 6420099 6420264 6420413 6420423 6420441 6420459 6420593 6421028 6421721 6422500 6423120 6423190 6423659 6424028 6424251 6424340 6425448 6426230 6426279 6426524 6426628 6426652 6426704 6427231 6427270 6427390 6427549 6427658 6427703 6427726 6427980 6428017 6428380 6428408 6428427 6428489 6428711 6428909 6428984 6429055 6429339 6429402 6429411 6429452 6429471 6429582 6429618 6429645 6429675 6429830 6430114 6430124 6430285 6430358 6430367 6430560 6430585 6430843 6430849 6430857 6430858 6430860 6430986 6431244 6431371 6431517 6431895 6431916 6431971 6432176 6432240 6432360 6433359 6433679 6433815 6434623 6434789 6434807 6434852 6434909 6434906 6435183 6435303 6435351 6435356 6435867 6435897 6435930 6436262 6437148 6437791 6438015 6438086 6438093 6438797 6438966 6438939 6439224 6439631 6439632 6439651 6440049 6440363 6440826 6441314 6441605 6442244 6442340 6443277 6443310 6443408 6443464 6443537 6443912 6444054 6444274 6444739 6445264 6445288 6446089 6446252 6446515 6446785 6446801 6446892 6447224 6447386 6447395 6447505 6447553 6447747 6448808 6448828 6449348 6449673 6449713 6449804 6449871 6450129 6450167 6450229 6450251 6450497 6450500 6450579 6450661 6450682 6450745 6451025 6451026 6451364 6451412 6451434 6451439 6451561 6451631 6451679 6451701 6451707 6451976 6452004 6452045 6452053 6452059 6452101 6452247 6452352 6452372 6452378 6452428 6452553 6452669 6452814 6452851 6452898 6452954 6452989 6452999 6453035 6453047 6453085 6453093 6453211 6453249 6453252 6453445 6453518 6453556 6453560 6453571 6453661 6453674 6453694 6453697 6453762 6453836 6453922 6453945 6453962 6454057 6454058 6454081 6454140 6454286 6454352 6454364 6454495 6454497 6454517 6454564 6454855 6454906 6454935 6454936 6454985 6455199 6455292 6455301 6455389 6455497 6455528 6455566 6456247 6456485 6456549 6456564 6456567 6456700 6456701 6456729 6456750 6456815 6456816 6456986 6456987 6457087 6457209 6457271 6457284 6457443 6457452 6457646 6457803 6459165 6459411 6459638 6461309 6462227 6462364 6462498 6462967 6463032 6463068 6463404 6463789 6463961 6464291 6464306 6464872 6464905 6465379 6465933 6465935 6466429 6466572 6466613 6466695 6466736 6468618 6468644 6468695 6468784 1000000775 6388022 1000001269 6393349 1000001759 1000001543 1000002039 1000002399 1000002408 1000002486 1000001338 1000000976 1000003753 1000003942 1000001329 1000003095 1000004707 1000004747 1000001198 1000003875 6390109 1000005344 1000004539 1000004780 1000006027 1000006030 1000006068 1000006499 1000006852 1000007011 1000007157 1000007158 1000003850 1000007511 1000005008 1000000974 1000002495 1000008495 1000008522 1000008523 1000008813 1000008814 1000008815 1000008962 1000007878 1000006212 1000009689 1000009918 1000009989 1000009992 1000005293 1000009516 1000005960 1000007460 1000009625 1000010738 1000010537 1000010932 1000011059 1000011933 1000012147 1000012588 6391132 1000013094 1000013164 1000008008 1000012172 1000000852 1000010199 1000013803 1000013806 1000013861 1000010389 1000014214 1000014342 1000014304 1000014985 1000015552 1000006062 1000015748 1000014506 1000014308 1000016010 1000016011 1000016166 1000016168 1000016169 1000016174 1000014118 1000016586 1000016793 1000016923 1000017268 1000017280 1000017196 1000017283 1000016961 1000014594 1000007022 1000017330 1000016695 1000017298 1000017312 1000012415 1000017386 1000017530 1000017338 1000017685 1000017763 1000017853 1000017868 1000017870 1000018176 1000018177 1000014189 1000012790 1000018513 1000018751 1000017295 1000018461 1000018662 1000018968 1000018969 1000018998 1000018999 1000017455 1000018915 1000018940 1000016929 1000019212 1000019248 1000015386 1000019467 1000018597 1000019682 1000019709 1000019722 1000018367 1000019886 1000019917 1000019919 1000019920 1000019921 1000014390 1000020338 1000020365 1000020366 1000020367 1000017139 1000017331 1000020487 1000019624 1000020838 1000020839 1000020846 1000019469 1000020971 1000021128 1000020879 1000019930 1000021285 1000021230 1000020896 1000016527 1000010767 1000016858 1000014715 1000018178 1000021451 1000022325 1000020893 1000022344 1000022394 1000021490 1000022485 1000022517 1000010727 1000021400 1000021521 1000022611 1000017181 1000021221 1000018922 1000023633 1000023634 1000024313 1000024315 1000024344 1000024347 1000024355 1000024356 1000024358 1000024367 1000024386 1000024396 1000024397 1000025170 1000025315 1000024403 1000018196 1000018971 1000022522 1000026575 1000023639 1000024139 1000026703 1000026704 1000023743 1000026837 1000027004 1000014853 1000017580 1000018449 1000027551 1000028252 1000028289 1000028292 1000028294 1000028295 1000028302 1000028587 1000028648 1000028997 1000029456 1000029457 1000029458 1000029459 1000029460 1000029707 1000029708 1000029709 1000029710 1000015733 1000029921 1000029952 1000029954 1000029986 1000030021 1000030023 1000030025 1000030027 1000019159 1000030767 1000026930 1000012010 1000031536 1000031537 1000031551 1000031565 1000031568 1000031571 1000031844 1000031845 1000031848 1000031852 1000032263 1000032493 1000032527 1000032710 1000032315 1000032824 1000032826 1000033123 1000033130 1000033162 1000033166 1000033227 1000033238 1000033464 1000033508 1000033513 1000033520 1000024133 1000026315 1000033521 1000020351 1000035356 1000014560 1000035721 1000035723 1000035727 1000036187 1000016099 1000036703 1000036907 1000036908 1000036909 1000036925 1000036930 1000037031 1000037032 1000037033 1000037034 1000037035 1000037036 1000037037 1000037038 1000037039 1000037040 1000037041 1000037042 1000037043 1000037044 1000037045 1000037046 1000037266 1000037277 1000037725 1000037738 1000039350 1000039359 1000039493 1000040114 1000040203 1000040204 1000040208 1000040210 1000040211 1000040212 1000040409 1000040412 1000040526 1000040828 1000040831 1000040909 1000040913 1000040933 1000040966 1000022526 1000027462 1000040985 1000040991 1000040992 1000041043 1000031575 1000041248 1000041291 1000041292 1000041293 1000041301 1000041305 1000041317 1000041322 1000041323 1000041324 1000041337 1000041340 1000033144 1000042033 1000042044 1000042055 1000042056 1000042061 1000042062 1000042077 1000042080 1000042870 1000030762 1000043032 1000043033 1000043034 1000043035 1000043036 1000043037 1000043038 1000043039 1000043054 1000043229 1000043231 1000043233 1000043234 1000043235 1000043236 1000043244 1000043247 1000043249 1000043250 1000043251 1000043253 1000043279 1000043408 1000043614 1000043724 1000017588 1000044140 1000044142 1000044147 1000044148 1000044150 1000044275 1000044336 1000037918 1000046220 1000046221 1000046222 1000046223 1000046224 1000046225 1000046226 1000047154 1000047155 1000047424 1000047422 1000033049 1000048106 1000048107 1000048137 1000048145 1000048146 1000048147 1000047265 1000048304 1000026297 1000048315 1000048316 1000048561 1000048893 1000019184 1000049060 1000016013 1000020885 1000049298 1000049456 1000049706 1000045610 1000049747 1000049754 1000049757 1000049641 1000048142 1000049875 1000049980 1000044804 1000050094 1000029115 1000050373 1000043301 1000050445 1000050453 1000050522 1000050555 1000050742 1000050887 1000051068 1000051074 1000039012 1000051247 1000051331 1000051298 1000051474 1000050807 1000051610 1000048241 1000051775 1000051781 1000051902 1000051504 1000051924 1000051936 1000036990 1000050171 1000021337 1000052393 1000052450 1000052563 1000052565 1000052656 1000052873 1000049273 1000050357 1000006965 1000053053 1000053184 1000053452 547 ] |
|
188.38 ms (8.65%) |
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:
[
"10177-attaches-et-piques-notes-couleur-n-c-ftb250373"
]
|
|
2.76 ms (0.13%) |
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.16 ms (0.05%) |
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:
[ 547 1 ] |
|
0.81 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 255 547 ] |
|
0.58 ms (0.03%) |
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:
[
"10177-attaches-et-piques-notes-couleur-n-c-ftb250373"
]
|
|
0.43 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.id = ? LIMIT 1
Parameters:
[
1
]
|
|
0.37 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:
[
"10177-attaches-et-piques-notes-couleur-n-c-ftb250373"
]
|
|
0.27 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"
]
|
|
0.26 ms (0.01%) |
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:
[
547
]
|
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.