Query Metrics
100
Database Queries
16
Different statements
4545.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2994.22 ms (65.87%) |
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:
[ 71996 "2024-11-04 23:16:35" ] |
|
1313.59 ms (28.90%) |
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:
[ 6222497 6207535 6246226 6257214 6257475 6257496 6246424 6246415 6244063 6241420 6258076 6258193 6258211 6246852 6258336 6258730 6258744 6234760 6259236 6259980 6260141 6260363 6260372 6260400 6224067 6261159 6261280 6246791 6262090 6262110 6262109 6262635 6262803 6262936 6263215 6263655 6263296 6263769 6264334 6263166 6264792 6265055 6258462 6265162 6265269 6239284 6265367 6265524 6265886 6265912 6265373 6266270 6266271 6267404 6268362 6259519 6238650 6268666 6268841 6269296 6269843 6269487 6270116 6270091 6262337 6270413 6270468 6270809 6270820 6270935 6270552 6271316 6271615 6271650 6271977 6272198 6271410 6272474 6272573 6273217 6271381 6273604 6273675 6274136 6273347 6274182 6274203 6273704 6270478 6272904 6274906 6245592 6275372 6275385 6275434 6275490 6275619 6275807 6276000 6276409 6276509 6274975 6276975 6277349 6277234 6275943 6277621 6277749 6278201 6278281 6278503 6278835 6274003 6279658 6279771 6279975 6280038 6280214 6280426 6280466 6280536 6280647 6280801 6280812 6281027 6281762 6281777 6281953 6282124 6282219 6282306 6282393 6282477 6282486 6282569 6282573 6282576 6282578 6282580 6282587 6282592 6282597 6282601 6282671 6282777 6282783 6282874 6282915 6282963 6283310 6283331 6283517 6283863 6283971 6283990 6284007 6284216 6284489 6284770 6284919 6284941 6285050 6285155 6285403 6285706 6285825 6285945 6285978 6286241 6286331 6286699 6286851 6286857 6287213 6287368 6287370 6287371 6287516 6287674 6287677 6287679 6287825 6288275 6288797 6288755 6288835 6288493 6288907 6288838 6288827 6288767 6289126 6288662 6288660 6288656 6288654 6288653 6288613 6288540 6288621 6288903 6288485 6289218 6289205 6289139 6289127 6289098 6289117 6289031 6288850 6288477 6289248 6288465 6288432 6288421 6288419 6288415 6289374 6289380 6289419 6289432 6289435 6289447 6289467 6289475 6289583 6289591 6289599 6289638 6289667 6289690 6289697 6275084 6275304 6289802 6288441 6289391 6289146 6289883 6288620 6289903 6289927 6289931 6289959 6290002 6290094 6290134 6290141 6290166 6290168 6290173 6288738 6290163 6290098 6290096 6290005 6290405 6290419 6290289 6290448 6289996 6290367 6289989 6290053 6289943 6289892 6289876 6289867 6289816 6289815 6290585 6290624 6290647 6290827 6290837 6290945 6290952 6290955 6291260 6262726 6291542 6291838 6291845 6291883 6260624 6272610 6291910 6290423 6291125 6291918 6291920 6291929 6291931 6291985 6292104 6292205 6292249 6292304 6292391 6292512 6292772 6292960 6292992 6292994 6290034 6293006 6289321 6292172 6292158 6292045 6291982 6291392 6291364 6291218 6290607 6292189 6293095 6290559 6290352 6290065 6289824 6289206 6288645 6291561 6291482 6291434 6291389 6291294 6291187 6291104 6291087 6291004 6290975 6290894 6290657 6290554 6290531 6290420 6290399 6290345 6290124 6289364 6289375 6289390 6288364 6288521 6288587 6288824 6288889 6289004 6289426 6289770 6289819 6289894 6289913 6289920 6290047 6290063 6290071 6290241 6290297 6290544 6289214 6289224 6289302 6289404 6289847 6289952 6290026 6290176 6290185 6288347 6288361 6288401 6288413 6288430 6288605 6288681 6288731 6288855 6288912 6289038 6289222 6289482 6290078 6288792 6290024 6288532 6290294 6289896 6289720 6288397 6289422 6288480 6289223 6288833 6288803 6288515 6293287 6288806 6293308 6293361 6293388 6293430 6293723 6293729 6293750 6293752 6293770 6293772 6293784 6293789 6293791 6293801 6293802 6293811 6293826 6293827 6293837 6293861 6293873 6293930 6293942 6293950 6293954 6293960 6293983 6293984 6294006 6294028 6294081 6294088 6294124 6294130 6294132 6294139 6289489 6290593 6294538 6294544 6294562 6294595 6294603 6294646 6294660 6294662 6294680 6294683 6294700 6294701 6294709 6294714 6292203 6294924 6295053 6295112 6294837 6295253 6294367 6295552 6295584 6295594 6295606 6295663 6295708 6295718 6295742 6295833 6295973 6295975 6290950 6296586 6296590 6296607 6296616 6296617 6296657 6296672 6296708 6296721 6296734 6296735 6296736 6296754 6296755 6296770 6296803 6296859 6296879 6296881 6296882 6297121 6297137 6297258 6297278 6297446 6297487 6297492 6297508 6297522 6297543 6297588 6297596 6277639 6297622 6297647 6297650 6297653 6297671 6297697 6297701 6297907 6291709 6299317 6299458 6258456 6299599 6299570 6298144 6300220 6300241 6301062 6299837 6301624 6301838 6301944 6301986 6301968 6302259 6302344 6277631 6303907 6304021 6304412 6304496 6304741 6304831 6304855 6305136 6305328 6305331 6305349 6305356 6305430 6305687 6305921 6306055 6306094 6306095 6306098 6306099 6306104 6306108 6306138 6306204 6306229 6306230 6306237 6306239 6306240 6306270 6306274 6306278 6306285 6306288 6306289 6306291 6306292 6306299 6306300 6306303 6306309 6306319 6306323 6306326 6306327 6306333 6306334 6306338 6306375 6306390 6306393 6306403 6306405 6306407 6306417 6306421 6306424 6306428 6306470 6306510 6306511 6306531 6306533 6306535 6306586 6306697 6306726 6306727 6306764 6306765 6306772 6306773 6306775 6306776 6306805 6306842 6306844 6306858 6306860 6306918 6306919 6306920 6306921 6306951 6306952 6307019 6307022 6307043 6307044 6307046 6307048 6307049 6307051 6307061 6307077 6307092 6307093 6307194 6307195 6307196 6307197 6307198 6307239 6307241 6307242 6307243 6307292 6307294 6307295 6307297 6307335 6307337 6307342 6308072 6308080 6308081 6308082 6308159 6308160 6308161 6308162 6308191 6308289 6308334 6308336 6308337 6308339 6308357 6308359 6308361 6308390 6308391 6308410 6308527 6308550 6308551 6308580 6308581 6308582 6308583 6308584 6308585 6308602 6308606 6308607 6308625 6308626 6308627 6308629 6308631 6308632 6308636 6308655 6308659 6308696 6308698 6308699 6308700 6308726 6308734 6308736 6308737 6308753 6308768 6308775 6308785 6308786 6308794 6308795 6308796 6308878 6308909 6308912 6308913 6308914 6299388 6309423 6309475 6302219 6310289 6310300 6310431 6310776 6310952 6310959 6309530 6311347 6311507 6311854 6312556 6312632 6312846 6313138 6313139 6313716 6314034 6314598 6314423 6314834 6314563 6315190 6315233 6315273 6310862 6310949 6315816 6313596 6315877 6303722 6313574 6316373 6316662 6316737 6316744 6316801 6316961 6316976 6317020 6317615 6317938 6318047 6318274 6318408 6318554 6318609 6318720 6317520 6319634 6317864 6319780 6320194 6320336 6320547 6320550 6320388 6319587 6317057 6320827 6321232 6321258 6321308 6321360 6322141 6322688 6323014 6323653 6321652 6321607 6321402 6324273 6314715 6324291 6324364 6324456 6324084 6324594 6324780 6325131 6325183 6323039 6325550 6325989 6326258 6326340 6326521 6326562 6326979 6326985 6327030 6327113 6327114 6327265 6327470 6327506 6327629 6327816 6327883 6327945 6327992 6328003 6328168 6328239 6328242 6328245 6328255 6328363 6328420 6328432 6328510 6328911 6328913 6328984 6329249 6329469 6329515 6329516 6329687 6330207 6330297 6330309 6330314 6330317 6330340 6330513 6319592 6324525 6330539 6325274 6325390 6326066 6326109 6330600 6330621 6330756 6324567 6326079 6330891 6330969 6330977 6330978 6330994 6331016 6330946 6330961 6330401 6330739 6330753 6330757 6330793 6330914 6330558 6330663 6330675 6330694 6330700 6330529 6330647 6330532 6331203 6331218 6331292 6330775 6330801 6330877 6330896 6330958 6330963 6331167 6331239 6330927 6330932 6330975 6330934 6331192 6331269 6330839 6330938 6331020 6331215 6330826 6331326 6330974 6331154 6331362 6331381 6331431 6331451 6331511 6331519 6331550 6331600 6331619 6331639 6331006 6331095 6331153 6331400 6331429 6330955 6331653 6331654 6331668 6326141 6331680 6331681 6331709 6331141 6330679 6331198 6331651 6331287 6331724 6331200 6330818 6331731 6331127 6331157 6331235 6331748 6331428 6330889 6331199 6331692 6330669 6331791 6331798 6331801 6331803 6331804 6331816 6331819 6331822 6331809 6331848 6331853 6331840 6324113 6331882 6331916 6331944 6330846 6330945 6331013 6331022 6331297 6331630 6331658 6331773 6331818 6331959 6331963 6331975 6331981 6331982 6331989 6331999 6332008 6332015 6332145 6323132 6332090 6332287 6332289 6332297 6332310 6332342 6332358 6332399 6332429 6332468 6332629 6332336 6332698 6331805 6331823 6331869 6331872 6331902 6331907 6331923 6331928 6331970 6331980 6332011 6332029 6332063 6332083 6332111 6332255 6332322 6332348 6332404 6331341 6331449 6331696 6331739 6331745 6332725 6331767 6331800 6332338 6330834 6331011 6331049 6331063 6331166 6331196 6331227 6331250 6331268 6331317 6331325 6330535 6330746 6330828 6330968 6331727 6331258 6330988 6331792 6331305 6331264 6331080 6331284 6332233 6332426 6332509 6331695 6331802 6331270 6332837 6332916 6332941 6332962 6332968 6333002 6331932 6333004 6330895 6330693 6330747 6330789 6330792 6333005 6331857 6331435 6331834 6331077 6333026 6333031 6332001 6333039 6333055 6333079 6333094 6333095 6332811 6333142 6333145 6333149 6333156 6333180 6333187 6331685 6331712 6332089 6332232 6332363 6333025 6333233 6333241 6333246 6333252 6333271 6332416 6333280 6333295 6333299 6333302 6333304 6333385 6333417 6333505 6333531 6333544 6333545 6333546 6333556 6333563 6333577 6333581 6333591 6333594 6333616 6332350 6333093 6333341 6333457 6332799 6333628 6333633 6333664 6333677 6333745 6333764 6333774 6333775 6333346 6333682 6332994 6333790 6333791 6333797 6333805 6333820 6333822 6331319 6331897 6330642 6333656 6333863 6333884 6333914 6333947 6333966 6333969 6332357 6315546 6334070 6334164 6334170 6330549 6331025 6332017 6332154 6332266 6332466 6334163 6334281 6334404 6334452 6334455 6334463 6334465 6330665 6330733 6334267 6334272 6325194 6334587 6334702 6334703 6334704 6334713 6334730 6334736 6334750 6334802 6334838 6334904 6334908 6334937 6334716 6333199 6333155 6334980 6333305 6335043 6335114 6335125 6335145 6335288 6335331 6335333 6335406 6335408 6335423 6335429 6335444 6335460 6335487 6335524 6335548 6335569 6335573 6333647 6332280 6335469 6335963 6334976 6336092 6336141 6336166 6336182 6336196 6332642 6326036 6325883 6335627 6324925 6318581 6334961 6336478 6336501 6336521 6336636 6336663 6336677 6325614 6331029 6332691 6331001 6336721 6336916 6336935 6336959 6336962 6336989 6337011 6337022 6336299 6337029 6337080 6337135 6337180 6336592 6334947 6337220 6337233 6337246 6337259 6337271 6337295 6337324 6337340 6337351 6337287 6337427 6336430 6337557 6337595 6337607 6337705 6337721 6337752 6337753 6337769 6337778 6337840 6337852 6337871 6337877 6337879 6337881 6337919 6337921 6337934 6337961 6337979 6338023 6337950 6338244 6338465 6338554 6338612 6338697 6338732 6338772 6338013 6335392 6338934 6324883 6322943 6339023 6339164 6339207 6339471 6339636 6339688 6339700 6339860 6340063 6339983 6332459 6333352 6340375 6340424 6340507 6340541 6340805 6341113 6341295 6341604 6341630 6342042 6342944 6343003 6340841 6343806 6343935 6341422 6339179 6343823 6344293 6344751 6344811 6344355 6344623 6325195 6344932 6344986 6336804 6345091 6345155 6345183 6345284 6345618 6345089 6345683 6346087 6346140 6344947 6346297 6346462 6346635 6346828 6346854 6346953 6347237 6347258 6347397 6347402 6347412 6347687 6347688 6347786 6347800 6347854 6347981 6348002 6348039 6348040 6348041 6348044 6348047 6348132 6348159 6348160 6348192 6348194 6348198 6348200 6348213 6348232 6348234 6348236 6348238 6348240 6348241 6348242 6348246 6348249 6348250 6348252 6348253 6348258 6348259 6348262 6348263 6348265 6348272 6348275 6348276 6348279 6348280 6348292 6348297 6348300 6348307 6348308 6348352 6348355 6348366 6348375 6348390 6348391 6348392 6348393 6348397 6348403 6348410 6348451 6348452 6348470 6348473 6348476 6348478 6348479 6348483 6348485 6348486 6348495 6348498 6348504 6348509 6348510 6348514 6348517 6348568 6348682 6348697 6348735 6348739 6348744 6348747 6348748 6348749 6348750 6348751 6348769 6348770 6348771 6348772 6348814 6348815 6348828 6348830 6348871 6348892 6348893 6348896 6348914 6348916 6348920 6349014 6349015 6349016 6349025 6349026 6349029 6349030 6349045 6349067 6349080 6349082 6349084 6349085 6349090 6349187 6349188 6349189 6349190 6349191 6349216 6349217 6349218 6349219 6349220 6349262 6349265 6349266 6349307 6349308 6349315 6349316 6349317 6349446 6349511 6349538 6349549 6349580 6349589 6349659 6349679 6349688 6349743 6349748 6349765 6349768 6349779 6349787 6349799 6349812 6349820 6349821 6349822 6349823 6349930 6349946 6349947 6349960 6349965 6349980 6349982 6349986 6350014 6350016 6350037 6350038 6350040 6350042 6350045 6350050 6350055 6350074 6350076 6350126 6350157 6350158 6350199 6350204 6350205 6350207 6350209 6350220 6350221 6350223 6350242 6350243 6350248 6350268 6350273 6350278 6350279 6350322 6350323 6350326 6350336 6350339 6350341 6350346 6350347 6350350 6350396 6350397 6350398 6350401 6350407 6350443 6350444 6350445 6350565 6350573 6350574 6350576 6350596 6340325 6340406 6351657 6351684 6352093 6346261 6352462 6352582 6353351 6353918 6354374 6354645 6354689 6355143 6355148 6355200 6355306 6353449 6354827 6355486 6353963 6355653 6356045 6356149 6357094 6357356 6354914 6357453 6357853 6357959 6356260 6357360 6357424 6358280 6358377 6358479 6358546 6359165 6359183 6359795 6359118 6359901 6359624 6360680 6360683 6361068 6361407 6361434 6361643 6361872 6337933 6361075 6359879 6362795 6362962 6363015 6363171 6363201 6363334 6363528 6363955 6364051 6364131 6364326 6364332 6364603 6364798 6365132 6365554 6365687 6365830 6358745 6366788 6315555 6366972 6367336 6367438 6367586 6367511 6368243 6368245 6368355 6368359 6368376 6368240 6368318 6368337 6368361 6368378 6368335 6368435 6368437 6368458 6368583 6368591 6368608 6368221 6368296 6368309 6368311 6368313 6368425 6368460 6368469 6368499 6368504 6368523 6368553 6368582 6368639 6368649 6368629 6368670 6368719 6368877 6368209 6368246 6368328 6368404 6368534 6368595 6368655 6368908 6368913 6368955 6368956 6368962 6369121 6369418 6369825 6369983 6370110 6370197 6370431 6370541 6370542 6370842 6370881 6371043 6371127 6371128 6371129 6371140 6371147 6371156 6371276 6371297 6371306 6371553 6371555 6372105 6372186 6372528 6372697 6373017 6373188 6373547 6373671 6373709 6373715 6373718 6373818 6373821 6373823 6373826 6373831 6373848 6373883 6373905 6373913 6373922 6373943 6373963 6368247 6368302 6368338 6368341 6368367 6368382 6368431 6368463 6368482 6368697 6368720 6368796 6368829 6368838 6368886 6368900 6368915 6368358 6373980 6374084 6374123 6374130 6374138 6368184 6368208 6368525 6368713 6373968 6373993 6360804 6368980 6374173 6374204 6374215 6374240 6374258 6374268 6374278 6374284 6374324 6364868 6374326 6374327 6368869 6368865 6374191 6368976 6368726 6374352 6374356 6374361 6374371 6374401 6374418 6374428 6368933 6374445 6368872 6368931 6368974 6374189 6374217 6374530 6374539 6374355 6374586 6374611 6374621 6368565 6368575 6368584 6368654 6368699 6368824 6368863 6369061 6373894 6373977 6374188 6374237 6374275 6374276 6374290 6374296 6374350 6368177 6368295 6368383 6368396 6368414 6374633 6374695 6374825 6374829 6374846 6374874 6374878 6374882 6374906 6374911 6374912 6374917 6374922 6374936 6374939 6374949 6374953 6375003 6368285 6368288 6368397 6368512 6368892 6368965 6374054 6374067 6374171 6374277 6374279 6374282 6374294 6374404 6374426 6374465 6374527 6374755 6375012 6375014 6375025 6375033 6375040 6375009 6375126 6375127 6375176 6375180 6375200 6375223 6368472 6374662 6375050 6375275 6368259 6375286 6375288 6368422 6368429 6368515 6375308 6368542 6368556 6374091 6375326 6374099 6375336 6375346 6375350 6375251 6375357 6375374 6375376 6375377 6375379 6375399 6375421 6375423 6368216 6369017 6375135 6375225 6375460 6375494 6375067 6375246 6375426 6368920 6374641 6375571 6375202 6375249 6375596 6375361 6368278 6374482 6375687 6375790 6375825 6375988 6375993 6376007 6376049 6376113 6376120 6376172 6376198 6376204 6376245 6376256 6376259 6376314 6376242 6376390 6374229 6374613 6374622 6374754 6375074 6375219 6375229 6375670 6375830 6376244 6376397 6376404 6376410 6376420 6376423 6376427 6376436 6376447 6376481 6376491 6376505 6376552 6376561 6376511 6376575 6376609 6376666 6376715 6374335 6375846 6375088 6368258 6376558 6376749 6374125 6376284 6377179 71996 ] |
|
174.93 ms (3.85%) |
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:
[
"62871-adhesifs-couleur-n-c-62871-busines"
]
|
|
14.96 ms (0.33%) |
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:
[ 71996 1 ] |
|
14.19 ms (0.31%) |
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" 71996 ] |
|
11.06 ms (0.24%) |
20 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ? AND t0.characteristic_label_id = ? LIMIT 1
Parameters:
[ 571 7 ] |
|
8.30 ms (0.18%) |
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:
[ 71996 0 ] |
|
6.52 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:
[
571
]
|
|
3.13 ms (0.07%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 LIMIT 10
Parameters:
[ 56 265 266 267 268 269 265 71996 ] |
|
1.41 ms (0.03%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.displayed_order AS displayed_order_3, t0.is_in_footer AS is_in_footer_4, t0.slug AS slug_5, t0.category_parent_id AS category_parent_id_6 FROM category t0 WHERE t0.category_parent_id = ?
Parameters:
[
56
]
|
|
1.33 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.68 ms (0.02%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value1 AS value1_3, t0.value2 AS value2_4, t0.value3 AS value3_5 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"ourClientsAlsoBoughtMonths"
]
|
|
0.52 ms (0.01%) |
1 |
SELECT d0_.quantity AS quantity_0, MIN(d0_.price_ht) AS sclr_1, MIN(d0_.price_ttc) AS sclr_2 FROM decreasing_price d0_ LEFT JOIN product p1_ ON d0_.product_id = p1_.id WHERE p1_.id = ? GROUP BY d0_.quantity ORDER BY d0_.quantity ASC
Parameters:
[
71996
]
|
|
0.47 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.19 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.