Query Metrics
49
Database Queries
12
Different statements
4410.95 ms
Query time
0
Invalid entities
2727
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 190.02 ms |
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:
[
"10112-agrafes-couleur-esselte-24861800"
]
|
2 | 0.47 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
498
]
|
3 | 0.84 ms |
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, t27.id AS id_28, t27.min_qty AS min_qty_29, t27.max_qty AS max_qty_30, t27.step_qty AS step_qty_31, t27.product_id AS product_id_32 FROM product t0 LEFT JOIN product_rule t27 ON t27.product_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"10112-agrafes-couleur-esselte-24861800"
]
|
4 | 0.84 ms |
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:
[
"10112-agrafes-couleur-esselte-24861800"
]
|
5 | 0.97 ms |
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:
[ 498 1 ] |
6 | 1.89 ms |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.manufacturer AS manufacturer_2, p0_.short_label AS short_label_3, p0_.long_label AS long_label_4, p0_.weight AS weight_5, p0_.sold_by AS sold_by_6, p0_.ppht AS ppht_7, p0_.ppttc AS ppttc_8, p0_.paht AS paht_9, p0_.pattc AS pattc_10, p0_.legal_discount_library AS legal_discount_library_11, p0_.fidelity_bonus AS fidelity_bonus_12, p0_.brand AS brand_13, p0_.time_limit AS time_limit_14, p0_.coef AS coef_15, p0_.is_discountable AS is_discountable_16, p0_.is_btob AS is_btob_17, p0_.is_btoc AS is_btoc_18, p0_.is_customizable AS is_customizable_19, p0_.is_library AS is_library_20, p0_.is_nathan AS is_nathan_21, p0_.is_green AS is_green_22, p0_.is_orapi_grand_frais AS is_orapi_grand_frais_23, p0_.is_active AS is_active_24, p0_.slug AS slug_25 FROM product p0_ LEFT JOIN product_category p2_ ON p0_.id = p2_.product_id LEFT JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id IN (?, ?, ?, ?, ?, ?, ?, ?) AND p0_.is_active = 1 AND p0_.id <> ? AND p0_.is_btoc = 1 AND p0_.is_orapi_grand_frais <> 1 LIMIT 10
Parameters:
[ 54 253 254 255 256 257 258 253 498 ] |
7 | 0.67 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
481
]
|
8 | 0.55 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
482
]
|
9 | 0.90 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
484
]
|
10 | 0.57 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
485
]
|
11 | 0.54 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
486
]
|
12 | 0.49 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
487
]
|
13 | 0.42 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
488
]
|
14 | 0.39 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
490
]
|
15 | 0.25 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
491
]
|
16 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
492
]
|
17 | 1.02 ms |
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"
]
|
18 | 3566.61 ms |
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:
[ 498 "2025-04-11 13:52:09" ] |
19 | 635.68 ms |
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:
[ 6383653 6384386 6384443 6384732 6384734 6384745 6384863 6384973 6385058 6385079 6385104 6385135 6385148 6385659 6382350 6386007 6386020 6386219 6386490 6386534 6386705 6385013 6386715 6387345 6386018 6386509 6387232 6385530 6387747 6387783 6387838 6388034 6388145 6388148 6388689 6388995 6389044 6389102 6389116 6389514 6389719 6385841 6389956 6390006 6390130 6390320 6390368 6390499 6390774 6390775 6390782 6391013 6391113 6391128 6391367 6391368 6391898 6392081 6392709 6392860 6392977 6393433 6366128 6365392 6394861 6395095 6395135 6395281 6395326 6395924 6395963 6395976 6396154 6396161 6396173 6396220 6396262 6396270 6396281 6396342 6396678 6396680 6396683 6396755 6396756 6396838 6396846 6397009 6397011 6397059 6397072 6397149 6397194 6397307 6397353 6397597 6397695 6397746 6397957 6398018 6398029 6398264 6398743 6398746 6399142 6399411 6399418 6399458 6399461 6399524 6399591 6399676 6399689 6399745 6399770 6399796 6399817 6399823 6399828 6399884 6399943 6399952 6400116 6400207 6400287 6400340 6400425 6400535 6400585 6402139 6402140 6402322 6402535 6402807 6402831 6402978 6403323 6403652 6404008 6404022 6404141 6405049 6405112 6405420 6405572 6405601 6405983 6406216 6406285 6406298 6406583 6406601 6407011 6407372 6407482 6407562 6407566 6407582 6407971 6405362 6408387 6409060 6409392 6409395 6409478 6409570 6410140 6410242 6410369 6410570 6410657 6410711 6410875 6411295 6406394 6411338 6411736 6409174 6411795 6411873 6411918 6411994 6412078 6412695 6412840 6413027 6413075 6413086 6413109 6413320 6413366 6413479 6413689 6413823 6414159 6414363 6414469 6414685 6415579 6415589 6415658 6415768 6415797 6415843 6415951 6416318 6416374 6416416 6416444 6416594 6416713 6417092 6417156 6417163 6417376 6417382 6417385 6417392 6417410 6417431 6417455 6417491 6417534 6417612 6417695 6417742 6417795 6417876 6417890 6417893 6417927 6418030 6418043 6418062 6418064 6418077 6418078 6418185 6418283 6418304 6418372 6418430 6418449 6418466 6418522 6418698 6419089 6419688 6419696 6419849 6419880 6420168 6420174 6420264 6420331 6420423 6420593 6420770 6420990 6421257 6421277 6421495 6422100 6422380 6422507 6422697 6422900 6423120 6423135 6423457 6423728 6424014 6424193 6424218 6424253 6424398 6424435 6424672 6425855 6425131 6426217 6426473 6426487 6426559 6426628 6426638 6426698 6426793 6426811 6426849 6427083 6427365 6427374 6427746 6427991 6427996 6428241 6428313 6428532 6428688 6428827 6428959 6429343 6430575 6430587 6430810 6430873 6431733 6431816 6431985 6432073 6433354 6433662 6434072 6434219 6434240 6434393 6434467 6435007 6435597 6436080 6436755 6436820 6437722 6438121 6438150 6438652 6438985 6439192 6439448 6440150 6440794 6440834 6440847 6441314 6441705 6441964 6442143 6443493 6443580 6443705 6443724 6444277 6444382 6444606 6444888 6445003 6445019 6445255 6445288 6445648 6445819 6446105 6446119 6446442 6446910 6447682 6448239 6448273 6448845 6448936 6449713 6449786 6449796 6449804 6450195 6450217 6450330 6450402 6450442 6450528 6450635 6450726 6450855 6450896 6451221 6451287 6451311 6451496 6451631 6451787 6451998 6452102 6452106 6452120 6452139 6452142 6452146 6452239 6452272 6452274 6452291 6452507 6452617 6452723 6452760 6452761 6452762 6452803 6452810 6452894 6452967 6452998 6453054 6453083 6453206 6453215 6453267 6453420 6453431 6453450 6453532 6453572 6453652 6453657 6453663 6453847 6454061 6454095 6454165 6454286 6454343 6454586 6454748 6454761 6454844 6454976 6455004 6455110 6455260 6455264 6455915 6456135 6456212 6456422 6456523 6456835 6456860 6456897 6456913 6456928 6456982 6456986 6457092 6457188 6457443 6458297 6458412 6460058 6460095 6460112 6460450 6461029 6461476 6461598 6461630 6461825 6459152 6462209 6462244 6463402 6463783 6462505 6464470 6464689 6464695 6465193 6465276 6465619 6465652 1000051495 6465891 6465910 6465933 6465935 6466049 6466460 6467214 6468181 6469143 6469314 6469441 6471235 6472169 6472441 6472664 6473593 6474536 6474679 6474770 6474785 6475766 6475769 6475783 6475800 1000055708 6476943 6477412 6477582 6480609 6480786 6480884 6480911 6482487 6482720 6482783 1000056413 6483805 6483961 6484122 6484841 6485544 6485925 6486727 6486788 6488838 6490898 6491253 6491347 6492063 6492177 6492270 6493135 6494292 6494787 6494872 6494902 6495424 6496140 6496402 6497044 6497049 6497308 6497379 6497386 6497570 6497871 6498003 6498031 6498374 6498516 6498527 6498555 6498596 6499041 6499056 6499080 6499082 6499125 6499146 6499207 6499308 6499595 6499715 6499806 6499896 6500137 6500182 6500222 6500224 6500289 6500370 6500422 6500447 6500881 6500991 6501247 6501307 6501633 6501728 6501827 6501888 6501978 6501990 6502006 6502146 6502722 6502838 6503145 6503295 6503314 6503509 6503628 6503633 6503642 6503660 6503661 6503871 6503908 6503917 6503957 6505454 6507174 6507203 6507294 6507993 6508631 6510176 6510348 6510748 6510987 6512565 6512818 6513235 6513346 6514627 6515074 6515473 6515784 6515855 6515994 6516043 6517120 6517575 6521738 6522098 6522644 6522750 6523659 6523914 6524366 6525171 6525276 6525872 6526120 6526127 6526186 6526743 6526745 6526746 6526995 6527174 6527260 6527278 6527649 6527719 6528119 6528303 6528900 6529113 6529278 6529944 6530418 6530726 6530939 6531316 6532753 6532910 6533262 6533650 6533782 6534602 6535478 6535581 6535892 6535979 6536702 6536716 6536765 6537395 6537458 6537609 6538021 6538335 6538553 6538575 6538950 6539297 6539527 6539529 6539618 6539820 6539905 6539947 6539972 6540460 6541384 6541467 6541762 6542065 6542179 1000000741 1000000723 1000001162 1000001269 1000001426 1000001558 6388954 1000002326 1000002589 1000002593 1000003186 1000003919 1000003541 1000004168 1000004226 1000004233 1000004214 1000004328 1000004599 1000004617 1000004645 1000004714 1000004769 1000005105 1000005108 1000005148 1000005182 1000005201 1000005214 1000004329 6340647 6382649 1000006376 1000007260 1000007361 1000007606 1000005008 1000004395 1000007839 1000007961 1000005128 1000008045 1000008186 1000008191 1000008205 1000008195 1000008986 1000009088 1000004826 1000009324 1000009451 1000009452 1000009481 1000009533 1000010005 1000009516 1000008314 1000007460 1000010644 1000010657 1000010673 1000010691 1000010736 1000010400 1000010524 1000011874 1000012129 1000012213 1000012334 1000012486 1000012527 1000012588 1000012789 1000013012 1000013024 1000013118 1000013232 1000013135 1000013643 1000013744 1000012385 1000010199 1000010355 1000014073 1000014135 1000014136 1000014137 1000014168 1000014418 1000001025 1000015049 1000015082 1000010243 1000015349 1000014419 1000005239 1000015865 1000015743 1000014224 1000015984 1000016166 1000016168 1000016169 1000012570 1000014594 1000009659 1000017683 1000017684 1000017698 1000017944 1000017948 1000017950 1000018268 1000018370 1000018598 1000018686 1000018708 1000018840 1000004387 1000019413 1000019555 1000019556 1000019558 1000020000 1000020027 1000020032 1000020033 1000020034 1000020035 1000020038 1000020039 1000020044 1000020045 1000020062 1000008970 1000015117 1000021244 1000021247 1000021250 1000021745 1000021818 1000021825 1000021828 1000021864 1000021886 1000021891 1000021904 1000022053 1000022057 1000014766 1000022517 1000022587 1000022588 1000022589 1000022593 1000021928 1000017945 1000017951 1000027361 1000028749 1000028954 1000028956 1000029195 1000029353 1000028090 1000029914 1000029206 1000031094 1000031095 1000031096 1000031273 1000015927 1000032078 1000032183 1000032222 1000032240 1000032243 1000032304 1000032351 1000033827 1000033899 1000034176 1000034250 1000034642 1000034754 1000035370 1000035371 1000002590 1000015039 1000035782 1000036325 1000036667 1000036671 1000037500 1000037810 1000037823 1000037824 1000037840 1000037864 1000037915 1000037921 1000037932 1000038006 1000038008 1000038858 1000038868 1000038871 1000040264 1000021503 1000040271 1000040274 1000040276 1000040301 1000040302 1000040303 1000040305 1000040737 1000022526 1000041288 1000041311 1000041319 1000041348 1000041401 1000041403 1000041408 1000042024 1000042382 1000042647 1000029888 1000042651 1000042657 1000042658 1000042659 1000042660 1000042667 1000042668 1000042669 1000042671 1000042672 1000042694 1000042696 1000042701 1000042702 1000042703 1000042704 1000043124 1000043125 1000043470 1000043471 1000043472 1000043473 1000043491 1000043544 1000043545 1000043548 1000043549 1000005141 1000044120 1000044122 1000044123 1000044487 1000045963 1000045981 1000046068 1000046132 1000047876 1000048560 1000037931 1000049352 1000048341 1000020532 1000050425 6337781 1000040542 1000051054 1000052069 1000052088 1000052146 1000052149 1000030625 1000052371 1000053006 1000053130 1000053271 1000053281 1000053847 1000048210 1000049709 1000054220 1000053863 1000054485 1000054539 1000054698 1000056010 1000055699 1000056170 1000056936 1000056997 1000057045 1000057101 1000057686 1000057704 1000057782 1000057835 1000056360 1000058340 1000058616 1000058855 1000058971 1000059009 1000059733 1000059735 1000059812 1000059857 1000058321 1000054541 1000060487 1000060849 1000060908 1000060957 1000060983 1000060984 1000061324 1000061671 1000061804 1000062028 1000062054 1000062518 1000063208 1000063947 1000064070 1000064125 1000059956 1000064459 1000064814 1000064885 1000064886 1000064978 1000064990 1000064999 1000065087 1000065375 1000065682 1000065681 1000061250 1000066020 1000066021 1000066086 1000066180 1000065465 498 ] |
20 | 0.47 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
86862
]
|
21 | 0.34 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
65561
]
|
22 | 0.23 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
10481
]
|
23 | 0.18 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
9651
]
|
24 | 0.21 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
26728
]
|
25 | 0.22 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
11358
]
|
26 | 0.46 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
80486
]
|
27 | 0.21 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
65676
]
|
28 | 0.15 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
145260
]
|
29 | 0.21 ms |
SELECT t0.id AS id_1, t0.min_qty AS min_qty_2, t0.max_qty AS max_qty_3, t0.step_qty AS step_qty_4, t0.product_id AS product_id_5 FROM product_rule t0 WHERE t0.product_id = ?
Parameters:
[
21052
]
|
30 | 0.59 ms |
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
]
|
31 | 0.39 ms |
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
]
|
32 | 0.28 ms |
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:
[
16
]
|
33 | 0.21 ms |
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:
[
17
]
|
34 | 0.23 ms |
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:
[
18
]
|
35 | 0.32 ms |
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:
[
19
]
|
36 | 0.19 ms |
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:
[
20
]
|
37 | 0.36 ms |
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:
[
21
]
|
38 | 0.20 ms |
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:
[
22
]
|
39 | 0.18 ms |
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:
[
23
]
|
40 | 0.16 ms |
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:
[
24
]
|
41 | 0.15 ms |
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:
[
25
]
|
42 | 0.16 ms |
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:
[
26
]
|
43 | 0.16 ms |
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:
[
27
]
|
44 | 0.25 ms |
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:
[
28
]
|
45 | 0.18 ms |
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:
[
29
]
|
46 | 0.16 ms |
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:
[
30
]
|
47 | 0.16 ms |
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:
[
31
]
|
48 | 0.17 ms |
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:
[
32
]
|
49 | 0.45 ms |
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:
[
498
]
|
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.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Order\CustomerOrder | 1031 |
App\Entity\Customer\Customer | 320 |
App\Entity\Delivery\Delivery | 298 |
App\Entity\Catalog\ProductCatalog | 231 |
App\Entity\Catalog\CustomerCatalog | 231 |
App\Entity\User\User | 222 |
App\Entity\Product\Market | 156 |
App\Entity\Internal\Commercial | 69 |
App\Entity\Pricing\Price | 48 |
App\Entity\Product\ProductPrice | 47 |
App\Entity\Product\Product | 21 |
App\Entity\Product\Category | 21 |
App\Entity\Product\Characteristic | 10 |
App\Entity\Product\CharacteristicLabel | 10 |
App\Entity\Delivery\DeliveryCost | 6 |
App\Entity\Internal\Society | 4 |
App\Entity\Internal\Parameter | 1 |
App\Infrastructure\Doctrine\Entity\ProductRule | 1 |