Query Metrics
28
Database Queries
11
Different statements
3886.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2806.54 ms (72.22%) |
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:
[ 70747 "2025-02-12 07:40:05" ] |
|
848.50 ms (21.83%) |
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:
[ 6336721 6337831 6337848 6337871 6337436 6338051 6338353 6338402 6338401 6338554 6338672 6338658 6338691 6279025 6313848 6311417 6339044 6339414 6339451 6339592 6339625 6339641 6339657 6339733 6338331 6339936 6340263 6340298 6338887 6340459 6340477 6340478 6340482 6340483 6340484 6340624 6340583 6340708 6315586 6321017 6323815 6324933 6332712 6341054 6341068 6341116 6341268 6314724 6315709 6316046 6316483 6316881 6341439 6341594 6341697 6341725 6341742 6341746 6341761 6341782 6341783 6323399 6341808 6341932 6337111 6341979 6341986 6342413 6342423 6342605 6342725 6341880 6342785 6343029 6343024 6343200 6343352 6343496 6343742 6344002 6344169 6344202 6316215 6316449 6326177 6333749 6335507 6335543 6335621 6335735 6335778 6336566 6336672 6336680 6337520 6337930 6338779 6344590 6334016 6344881 6344886 6345214 6345505 6345512 6345571 6345593 6345605 6345687 6345692 6345721 6345723 6345787 6345966 6346137 6346142 6346159 6346127 6346193 6346206 6346257 6346313 6346811 6346841 6347124 6347151 6347308 6347527 6347861 6347995 6348072 6348099 6348114 6348136 6348271 6348535 6348595 6348632 6348887 6348963 6349159 6349169 6349239 6349246 6349248 6349249 6349251 6349253 6349255 6349256 6349513 6349538 6349589 6349590 6349611 6349885 6349890 6349913 6349916 6349919 6349997 6350033 6350112 6350234 6350279 6350437 6350465 6350466 6350467 6350472 6350473 6350558 6350789 6350796 6350879 6334884 6351097 6351148 6351155 6351186 6351193 6351284 6351327 6351441 6351581 6351600 6351683 6351726 6351827 6351851 6351887 6351936 6352142 6352224 6352972 6352993 6353134 6353177 6353340 6353332 6353714 6353739 6352915 6354628 6354789 6355266 6355355 6355503 6355745 6355889 6355935 6356182 6356588 6356728 6356947 6357073 6357110 6357158 6357298 6357357 6357522 6357555 6357732 6345890 6356958 6339720 6358589 6358600 6358074 6359024 6359056 6359159 6359229 6359467 6359979 6360264 6335745 6360229 6361225 6361290 6361381 6361405 6361525 6361583 6336632 6338783 6339932 6345313 6358572 6361993 6362125 6361741 6362214 6362430 6362610 6362615 6361075 6362823 6363160 6363171 6363390 6363452 6363527 6363638 6363711 6363760 6363906 6364035 6364147 6364393 6364652 6364721 6364789 6364845 6364620 6365483 6365603 6366172 6345984 6366809 6367835 6367853 6367813 6368068 6368120 6368362 6368675 6369032 6369258 6369372 6369772 6370111 6370153 6370160 6370167 6370249 6370523 6370672 6370848 6370860 6370881 6370965 6371109 6371187 6371218 6371292 6371709 6371731 6371748 6371770 6371781 6371807 6371854 6371863 6371864 6371869 6371879 6371887 6371888 6371892 6371904 6371905 6371938 6371944 6372059 6372186 6372544 6372618 6372660 6372675 6372676 6372767 6372880 6373055 6373187 6373191 6373223 6373415 6373663 6374682 6374719 6374815 6374865 6374970 6375305 6375568 6376183 6376191 6376304 6376309 6376320 6376330 6376334 6376345 6376365 6376602 6376709 6376862 6376865 6376882 6377108 6377220 6377226 6377573 6377592 6377609 6377531 6377668 6377960 6378272 6378477 6378482 6378539 6378635 6378654 6378657 6378664 6378675 6378679 6378743 6378761 6378764 6378769 6378786 6378808 6378813 6378868 6378879 6378887 6378952 6378981 6378984 6378989 6379003 6379018 6379029 6379032 6379072 6379117 6379129 6379139 6379141 6379145 6379149 6379187 6379194 6379212 6379243 6379262 6379261 6379270 6379292 6379318 6379375 6379392 6379403 6379416 6379409 6379441 6379454 6379462 6373885 6379490 6379497 6379506 6379555 6379574 6379576 6379631 6379710 6379722 6379723 6379725 6379752 6379757 6379779 6379790 6379792 6379805 6379857 6379867 6379868 6379909 6379926 6379952 6379957 6379987 6379998 6380048 6380086 6380097 6380118 6380136 6380146 6380150 6380179 6380189 6380205 6380212 6380312 6380347 6380352 6380397 6380429 6380437 6380466 6380492 6380503 6380544 6380552 6380566 6380589 6380631 6380654 6380677 6380722 6380741 6380748 6380786 6380807 6380806 6380861 6380818 6380899 6381005 6381157 6381173 6381199 6381203 6381207 6381228 6381273 6381321 6381357 6381370 6381373 6381431 6381460 6381487 6381549 6381634 6381690 6381724 6382074 6382176 6382201 6382229 6382252 6382282 6382299 6382324 6382333 6382355 6382406 6382425 6382429 6382489 6382572 6382578 6382590 6383144 6383284 6379507 6383904 6380349 6384587 6384657 6384728 6384748 6384521 6385080 6385092 6385214 6385435 6385023 6385520 6385632 6385750 6352881 6356753 6386174 6386184 6386202 6386347 6357281 6382391 6355400 6386548 6386643 6386675 6386682 6385013 6386780 6388145 6388416 6388700 6389485 6389818 6389795 6389993 6390320 6390328 6389985 6390350 6390533 6390597 6390948 6391119 6391133 6391135 6391820 6391892 6391898 6392510 6392606 6391923 6393768 6393813 6393835 6393853 6393900 6393960 6394007 6394025 6394050 6394055 6394092 6394131 6394204 6394213 6394323 6394324 6394353 6394356 6394404 6394426 6394504 6394528 6394696 6394767 6394790 6394804 6394824 6395027 6395030 6395824 6395863 6395916 6395986 6395999 6396014 6396087 6396159 6396471 6396473 6396613 6396709 6396721 6396822 6397155 6397535 6397793 6397805 6397808 6397811 6397950 6397987 6397990 6397994 6397995 6397998 6398226 6398746 6398901 6398913 6398921 6398929 6398935 6398939 6398944 6398952 6398967 6399123 6399124 6399194 6399197 6399299 6399392 6399526 6399571 6399582 6399821 6399884 6399973 6399974 6400116 6400185 6400204 6400260 6400337 6400395 6400404 6400422 6400504 6400762 6400851 6400853 6400901 6400910 6401197 6401243 6401320 6401485 6401506 6401510 6401519 6401526 6401671 6401794 6401973 6402154 6402165 6402622 6402804 6402831 6402874 6403322 6403336 6403339 6403363 6403424 6403458 6403478 6403496 6403501 6403683 6405014 6405294 6405340 6405361 6405392 6405418 6404151 6405905 6406131 6407107 6407118 6407174 6407803 6408423 6408587 6409118 6409136 6409283 6409398 6409667 6409812 6410012 6410095 6410739 6410753 6410776 6410969 6411449 6411907 6411918 6411950 6412187 6412212 6413086 6413350 6413455 6413468 6414203 6414380 6414466 6415669 6415762 6417159 6417694 6417730 6417821 6417857 6418064 6418132 6418185 6418401 6418544 6418581 6418708 6418717 6418884 6419038 6419437 6419472 6419484 6419615 6419628 6419637 6419672 6419758 6419809 6420117 6420287 6420418 6420440 6420441 6420442 6420452 6420454 6420455 6420456 6420458 6420459 6420528 6420540 6420541 6421029 6421101 6421280 6421372 6421656 6421703 6422679 6422722 6422809 6423179 6423370 6423586 6423636 6423639 6423642 6423769 6423950 6424314 6424409 6425140 6425234 6425959 6426400 6426486 6427143 6427198 6427567 6428449 6428452 6428867 6429441 6429640 6430435 6430913 6431855 6433132 6433539 6434017 6434083 6434104 6434419 6434687 6435366 6435436 6436537 6436797 6437179 6437712 6437868 6437973 6438726 6438881 6439265 6439983 6440077 6441119 6441419 6441517 6441645 6442055 6442079 6442723 6442855 6443171 6443302 6443384 6443415 6443610 6444051 6444143 6444652 6444721 6445282 6446904 6448265 6448861 6449653 6449684 6449708 6449709 6450699 6450847 6451775 6452835 6452874 6452894 6452902 6452904 6452916 6452927 6453456 6453492 6453576 6453621 6453655 6453758 6453939 6454150 6454173 6454246 6454250 6454275 6454381 6454391 6454399 6454412 6454494 6454522 6454761 6454956 6455110 6456042 6456138 6456139 6456162 6456180 6456190 6456194 6456196 6456204 6456359 6456431 6456450 6456486 6456626 6456749 6457298 6457299 6457404 6457657 6457755 6457787 6458216 6458501 6459449 6459600 6459703 6459952 6459986 6460046 6460061 6461330 6462118 6462244 6462950 6462963 6462967 6462971 6462987 6463006 6463163 6463512 6463870 6464227 6464262 6464291 6464300 6464311 6464612 6464654 6464713 6464759 6464872 6464895 6465174 6465184 6465202 6465271 6465292 6465300 6465324 6465337 6465349 6465504 6465524 6465624 6465791 6465883 6465893 6465895 6465901 6465955 6466026 6466327 6466336 6466373 6466379 6466564 6466569 6466574 6466596 6466645 6466722 6466724 6466769 6466856 6466861 6466895 6466952 6466975 6466989 6467057 6467055 6467091 6467125 6467132 6467138 6467139 6467141 6467182 6467194 6467220 6467319 6467460 6467461 6468075 6468102 6468103 6468130 6468172 6468177 6468222 6468573 6468614 6468618 6468692 6468705 6468724 6468795 6468806 6468928 6468974 6469029 6469031 6469036 6469045 6469053 6385114 6383663 1000001558 1000002462 1000002480 1000002482 1000002488 1000002487 1000004016 1000004017 1000002464 1000004309 1000004311 1000003522 1000004740 1000005421 1000006019 1000006297 1000007372 1000007386 1000008079 1000008258 1000008560 1000009023 1000009095 1000004826 1000009380 1000010005 1000010155 1000010666 1000010667 1000010713 1000009425 1000011814 1000011927 1000012034 1000012050 1000006448 1000013088 1000013202 1000013244 1000006433 1000013970 1000014190 1000013747 1000014465 1000013382 1000016010 1000016011 1000017278 1000017241 1000017379 1000017566 1000018566 1000018973 1000018975 1000018987 1000018988 1000005414 1000005418 1000020782 1000021293 1000010836 1000014079 1000022398 1000022400 1000022401 1000022402 1000026595 1000027368 1000027299 1000018352 1000029810 1000026588 1000032047 1000032084 1000033854 1000030059 1000034430 1000035804 1000035833 1000036381 1000036399 6390639 1000021503 1000040330 1000040333 1000040335 1000040344 1000040713 1000040875 1000040908 1000041115 1000041171 1000041172 1000041421 1000041423 1000041425 1000041467 1000041481 1000041482 1000042026 1000040497 1000042770 1000042771 1000042772 1000042773 1000042844 1000044149 1000029916 1000030104 1000048248 1000049104 1000014604 1000016013 1000049165 1000049327 1000049101 1000050297 1000032442 1000050652 1000050764 1000035896 1000035834 1000006785 1000051306 1000042653 1000052445 70747 ] |
|
222.31 ms (5.72%) |
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:
[
"63207-blocs-de-bureau-blanc-n-c-63207"
]
|
|
3.69 ms (0.09%) |
18 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
1
]
|
|
2.48 ms (0.06%) |
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:
[ 70747 1 ] |
|
0.73 ms (0.02%) |
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 189 70747 ] |
|
0.54 ms (0.01%) |
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:
[
"63207-blocs-de-bureau-blanc-n-c-63207"
]
|
|
0.43 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.42 ms (0.01%) |
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:
[
"63207-blocs-de-bureau-blanc-n-c-63207"
]
|
|
0.35 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:
[
70747
]
|
|
0.24 ms (0.01%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.