Query Metrics
28
Database Queries
11
Different statements
954.27 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
517.59 ms (54.24%) |
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:
[ 106714 "2025-02-12 15:48:17" ] |
|
386.59 ms (40.51%) |
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:
[ 6341997 6343366 6332215 6344942 6346629 6346730 6347437 6348068 6348947 6349811 6353338 6356008 6357408 6343914 6361248 6359626 6364711 6366831 6368323 6370877 6372014 6372374 6375282 6375743 6380862 6384409 6386079 6386109 6388214 6388948 6386995 6390625 6390859 6391409 6391946 6391983 6392048 6392332 6365569 6393352 6394229 6386783 6394567 6394731 6394949 6396235 6398528 6398800 6398870 6399982 6400302 6400429 6400732 6400838 6401652 6401940 6402172 6405401 6405485 6405622 6407572 6409195 6410853 6412087 6412832 6413784 6414355 6414390 6414482 6415128 6415188 6415487 6416112 6416197 6416257 6416408 6416970 6417239 6417315 6417440 6417445 6417632 6418002 6418956 6418973 6419154 6419342 6419379 6419444 6419533 6420924 6420949 6420985 6421738 6421905 6422229 6422774 6423072 6425191 6425313 6426932 6428649 6429659 6429750 6429798 6430477 6431416 6432044 6432175 6432261 6433807 6434736 6434920 6434983 6435078 6435777 6437116 6438095 6438097 6438635 6438906 6439452 6439538 6439628 6441145 6441424 6441815 6444105 6444111 6444653 6444736 6445219 6445521 6445649 6446114 6446548 6447579 6447755 6447788 6448787 6448801 6449337 6449936 6449987 6449990 6450173 6450584 6450761 6450791 6451095 6451371 6451587 6452047 6452247 6452256 6452483 6452610 6452614 6454762 6454841 6454848 6454852 6454873 6454884 6455071 6455082 6455115 6455129 6455181 6455185 6455468 6455551 6455618 6455640 6455650 6455760 6455762 6455768 6456118 6456676 6457056 6457547 6457733 6457753 6457774 6457921 6459481 6459503 6459550 6459573 6460200 6460310 6461359 6462226 6462586 6462770 6463423 6464028 6466394 6466687 6466690 6466806 6467772 6468079 6393298 1000001260 6386143 1000002930 1000003877 1000000937 1000004125 1000004183 1000004818 1000004554 1000005324 1000006146 1000001918 1000001670 1000008866 6388565 1000009389 1000006153 1000009533 1000009989 1000009992 1000001727 1000001726 1000008941 1000010848 1000009234 1000011020 1000010304 1000012550 1000012636 1000012856 1000013055 1000013243 1000013248 1000013250 1000014160 1000014534 1000010125 1000014423 1000015806 1000016195 1000016472 1000014287 1000017383 1000015137 1000018746 1000018848 1000018952 1000018947 1000014395 1000019180 1000019183 1000019495 1000019628 1000016836 1000020192 1000020218 1000020406 1000012402 1000019188 1000020770 1000021053 1000020875 1000021469 1000021470 1000003579 1000022105 1000022106 1000022107 1000022377 1000022379 1000022438 1000022439 1000022444 1000022475 1000022482 1000022486 1000022487 1000022698 1000022702 1000023455 1000023682 1000023683 1000023687 1000025315 1000012407 1000014572 1000019594 1000010252 1000021671 1000027207 1000006910 1000028598 1000030380 1000030381 1000030382 1000030385 1000030386 1000030387 1000030414 1000030834 1000031706 1000016473 1000019526 6385262 1000032716 1000032729 1000032732 1000032837 1000032838 1000032840 1000032841 1000032842 1000032922 1000032943 1000033187 1000033188 1000033192 1000033196 1000033199 1000033214 1000033216 1000033219 1000033230 1000033231 1000033608 1000033609 1000033610 1000033611 1000033613 1000033614 1000033616 1000033617 1000033618 1000033620 1000031541 1000033871 1000033872 1000032524 1000015299 1000035294 1000035366 1000035406 1000035452 1000035504 1000035506 1000035515 1000035518 1000009456 1000036324 1000036327 1000036328 1000036329 1000036330 1000036331 1000036332 1000036333 1000036334 1000036794 1000036797 1000036798 1000036799 1000036800 1000036801 1000036803 1000036808 1000036809 1000036810 1000036811 1000036812 1000036821 1000036928 1000036929 1000036933 1000036935 1000036936 1000036937 1000036943 1000036945 1000036950 1000036951 1000036957 1000036958 1000036960 1000036982 1000036988 1000036991 1000036994 1000036995 1000036996 1000036997 1000036998 1000036999 1000037000 1000037001 1000037002 1000037003 1000037004 1000037005 1000037011 1000037060 1000037061 1000037070 1000037071 1000037072 1000037073 1000037085 1000037086 1000037087 1000037095 1000037096 1000037097 1000037108 1000037110 1000038656 1000038657 1000038658 1000038659 1000038660 1000038663 1000038665 1000038671 1000038672 1000038673 1000038674 1000038679 1000038683 1000038684 1000038685 1000038686 1000038687 1000038688 1000038690 1000038691 1000038692 1000038694 1000038696 1000038697 1000038698 1000038699 1000038700 1000038702 1000038703 1000038704 1000038705 1000038706 1000038707 1000038708 1000038709 1000038710 1000038869 1000038872 1000039081 1000039082 1000039184 1000039187 1000039195 1000039337 1000039339 1000009770 1000039206 1000041740 1000041741 1000041743 1000041752 1000041753 1000041754 1000041755 1000041756 1000041811 1000041813 1000041828 1000041943 1000041944 1000041946 1000041949 1000041952 1000041957 1000042160 1000042310 1000042311 1000042319 1000042323 1000042324 1000042328 1000042330 1000042354 1000042358 1000042363 1000042365 1000042492 1000042500 1000042616 1000042629 1000042630 1000042633 1000042634 1000042683 1000042687 1000042690 1000042698 1000042706 1000042717 1000042718 1000042719 1000042721 1000042729 1000042730 1000043222 1000043225 1000043227 1000043925 1000044200 1000044202 1000044229 1000044232 1000044236 1000044239 1000044267 1000044280 1000044281 1000044282 1000044293 1000044294 1000044298 1000044320 1000044328 1000044477 1000044483 1000040173 1000044645 1000044717 1000044718 1000044723 1000044724 1000044726 1000044731 1000044754 1000044756 1000044770 1000044771 1000044773 1000044776 1000044777 1000044779 1000044780 1000044782 1000044784 1000044790 1000044799 1000044801 1000044806 1000044812 1000044880 1000044896 1000044957 1000044959 1000044964 6318892 1000045342 1000045343 1000045370 1000045372 1000045380 1000045408 1000045411 1000045428 1000045437 1000045477 1000045478 1000046013 1000046027 1000046092 1000046121 1000046790 1000046794 1000046842 1000047384 1000025176 6392363 1000047759 1000047762 1000047763 1000039083 1000047836 1000047847 1000044333 1000048301 1000048327 1000043014 1000048783 1000048508 1000048008 1000048876 1000048382 1000049038 1000040215 1000049348 1000048933 1000045610 1000049250 1000049822 1000050015 1000050016 1000048253 1000050136 1000050245 1000050214 1000050614 1000051109 1000033033 1000050982 1000049222 1000051533 1000050959 1000051734 1000051737 1000024963 1000051760 1000051961 1000050154 1000051966 1000052010 1000052205 1000052442 1000052697 1000040869 1000052864 1000053037 1000050777 1000053162 1000053240 1000053244 1000053451 1000053321 106714 ] |
|
42.46 ms (4.45%) |
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:
[
"79589-crayons-de-couleur-assorties-stabilo-880-10-2"
]
|
|
3.45 ms (0.36%) |
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.28 ms (0.13%) |
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:
[ 106714 1 ] |
|
0.93 ms (0.10%) |
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:
[ 83 388 389 390 391 392 393 394 395 389 106714 ] |
|
0.57 ms (0.06%) |
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:
[
"79589-crayons-de-couleur-assorties-stabilo-880-10-2"
]
|
|
0.51 ms (0.05%) |
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.39 ms (0.04%) |
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:
[
"79589-crayons-de-couleur-assorties-stabilo-880-10-2"
]
|
|
0.27 ms (0.03%) |
1 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.product_id AS product_id_3, t0.characteristic_label_id AS characteristic_label_id_4 FROM characteristic t0 WHERE t0.product_id = ?
Parameters:
[
106714
]
|
|
0.24 ms (0.02%) |
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.