Query Metrics
102
Database Queries
16
Different statements
3954.53 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2570.44 ms (65.00%) |
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 "2024-11-04 22:14:20" ] |
|
1100.73 ms (27.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 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:
[ 6240790 6245180 6257399 6257451 6257465 6257609 6257730 6257239 6257793 6257994 6247260 6245625 6258354 6221574 6258504 6258569 6258644 6258645 6258804 6258970 6258442 6259902 6260087 6260089 6260145 6260185 6260277 6260625 6260693 6259156 6261183 6261185 6261327 6262189 6264448 6264476 6258462 6264969 6265647 6266098 6266271 6266365 6264972 6266653 6227733 6266669 6266989 6265307 6267825 6267870 6267978 6267640 6267406 6268393 6268752 6235329 6239100 6246451 6256514 6268803 6268881 6269191 6269262 6265713 6269474 6269899 6270071 6270352 6270492 6270612 6271181 6266847 6271572 6269405 6271617 6271678 6272306 6272348 6272945 6272964 6273080 6273608 6273512 6274609 6275136 6275192 6275397 6275480 6276039 6276063 6276183 6276372 6276469 6276831 6276900 6277412 6277418 6277523 6260354 6278500 6278641 6279236 6281015 6281729 6281810 6281844 6281845 6281905 6281932 6281964 6282043 6282061 6282199 6282637 6282638 6282639 6282641 6282685 6282796 6283056 6283267 6283465 6283594 6283601 6283606 6283607 6283610 6283617 6284423 6285163 6285228 6285703 6286553 6286580 6286585 6286634 6286935 6287007 6287218 6287345 6287385 6287393 6287514 6287516 6289297 6289311 6289411 6289758 6289937 6290700 6290905 6289030 6291021 6291514 6291523 6291684 6291970 6261419 6292121 6292182 6292617 6292780 6292961 6292932 6293820 6293834 6293864 6278469 6293951 6294442 6294889 6294891 6291044 6295581 6295628 6295687 6295727 6295760 6295864 6295974 6295837 6296363 6296224 6293981 6296899 6296924 6296937 6297025 6297138 6297177 6297400 6297473 6297714 6298690 6298885 6298745 6299294 6299335 6298001 6266420 6299538 6299686 6299719 6299727 6299807 6299871 6300015 6300138 6300146 6300227 6300274 6300305 6300682 6301219 6301251 6299522 6301477 6272742 6301649 6301867 6301866 6301948 6302011 6302175 6302348 6302892 6303395 6303420 6260004 6269437 6303545 6303648 6303659 6303663 6294278 6303055 6303796 6303881 6303779 6303884 6303885 6303899 6303913 6303922 6304190 6304248 6304347 6304350 6304359 6305569 6305924 6306018 6306146 6306156 6306160 6306259 6306552 6306592 6307098 6307100 6307146 6307161 6307175 6307177 6307184 6307266 6307281 6307322 6307457 6307492 6307537 6307673 6307801 6308188 6308226 6308235 6308241 6308257 6308405 6308476 6308657 6308661 6308815 6308816 6308818 6308832 6308897 6309120 6309369 6309919 6309945 6309953 6309956 6309866 6309967 6309985 6310127 6310140 6310200 6310205 6310223 6310225 6310226 6310282 6310301 6310433 6310446 6310541 6310546 6310553 6310584 6310603 6310637 6310673 6310707 6310711 6310724 6310752 6302758 6310799 6310805 6310877 6310903 6310932 6310940 6311046 6311047 6311050 6311051 6311098 6311113 6311132 6311136 6311158 6311245 6311294 6311309 6311373 6311382 6311395 6311401 6311402 6311439 6311443 6311448 6311450 6311454 6311462 6311484 6311485 6311499 6311502 6311513 6311521 6311529 6311533 6311540 6311554 6311587 6311596 6311601 6311608 6311661 6311660 6311668 6311670 6311662 6311693 6311703 6311736 6311744 6311750 6311754 6311787 6311846 6311848 6311855 6311946 6312010 6312030 6312100 6312119 6312105 6312192 6312215 6312249 6312313 6312343 6312376 6312406 6312420 6312459 6312476 6312482 6312508 6312510 6312534 6312544 6312571 6312573 6312597 6312665 6312730 6312732 6312723 6312745 6312785 6312787 6312805 6312824 6312863 6312867 6312875 6312886 6312896 6312938 6313066 6313115 6313141 6313192 6313206 6313237 6313269 6313373 6313449 6313497 6313516 6313678 6313772 6313778 6299872 6312636 6310828 6314092 6314157 6314273 6314374 6314509 6314561 6314656 6314768 6314905 6314990 6315145 6315149 6315403 6313976 6315633 6315636 6315715 6315965 6316043 6309493 6316143 6316309 6316360 6316567 6316724 6316769 6316785 6316835 6316843 6316863 6316967 6317236 6317304 6317312 6317499 6317580 6317584 6317589 6317635 6317714 6317723 6317733 6317741 6317774 6317743 6317808 6317854 6318114 6318174 6318187 6318314 6318413 6318482 6318555 6317227 6318758 6318774 6319006 6319030 6319033 6319060 6309619 6319090 6319114 6319117 6319137 6319231 6319237 6319351 6319817 6319836 6319893 6320251 6320549 6320602 6320611 6320790 6320802 6320851 6320863 6320864 6320883 6320902 6320937 6320941 6321032 6321069 6321071 6321079 6321091 6321110 6321237 6321239 6321242 6321324 6321421 6321496 6321525 6321527 6321545 6321554 6318845 6321616 6321621 6321708 6321766 6321769 6321887 6322168 6321002 6322598 6321467 6323655 6323667 6323791 6323829 6323838 6322640 6323006 6324102 6324416 6324464 6324494 6323741 6324820 6324224 6325452 6325454 6325842 6326258 6326550 6326586 6326662 6327398 6327434 6327692 6327756 6327903 6327967 6328075 6328280 6328281 6328543 6328588 6328652 6328810 6328854 6328917 6328930 6329249 6329313 6329388 6329394 6329497 6329545 6329562 6329596 6329617 6329625 6329628 6329635 6329655 6329669 6329757 6329867 6329995 6330015 6330051 6330079 6330199 6330222 6330248 6330482 6330627 6330691 6330950 6331224 6331180 6331351 6331353 6331354 6332105 6332168 6332175 6332671 6332755 6332777 6332873 6332910 6332944 6333113 6333547 6333620 6333631 6333693 6333741 6333982 6334031 6332508 6334131 6334357 6334637 6334621 6335770 6335773 6335933 6336154 6336237 6335815 6336384 6336413 6336718 6336721 6336873 6336957 6337100 6337197 6334947 6337492 6337535 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 6351581 6351600 6351683 6351726 6351827 6351851 6351887 6351936 6352142 6352224 6352972 6352993 6353134 6353177 6353340 6353332 6310328 6353714 6353739 6352915 6354628 6354789 6355266 6355355 6355503 6355745 6355889 6355935 6356182 6356588 6356728 6356753 6356947 6357073 6357110 6357158 6357281 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 6361846 6363160 6363171 6363390 6363452 6363527 6363638 6363711 6363760 6363906 6364035 6364147 6364393 6364652 6364721 6364789 6364845 6364620 6365483 6365603 6355400 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 6373885 6374682 6374719 6374815 6374865 6374970 6375305 6375568 6352881 6376183 6376191 6376304 6376309 6376320 6376330 6376334 6376345 6376365 6376602 6376709 6376862 6376865 6376882 6377108 70747 ] |
|
230.24 ms (5.82%) |
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"
]
|
|
12.93 ms (0.33%) |
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" 70747 ] |
|
11.96 ms (0.30%) |
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:
[ 581 7 ] |
|
7.80 ms (0.20%) |
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:
[ 70747 0 ] |
|
7.34 ms (0.19%) |
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 ] |
|
5.55 ms (0.14%) |
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:
[
581
]
|
|
2.26 ms (0.06%) |
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:
[ 41 189 190 191 192 193 194 195 189 70747 ] |
|
1.58 ms (0.04%) |
8 |
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:
[
41
]
|
|
1.27 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:
[] |
|
0.83 ms (0.02%) |
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:
[
70747
]
|
|
0.65 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.44 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
]
|
|
0.18 ms (0.00%) |
1 |
SELECT t0.id AS id_1 FROM price t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"CAISSE2011"
]
|
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.