Query Metrics
112
Database Queries
21
Different statements
40.70 ms
Query time
5
Invalid entities
300
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.11 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
17731
]
|
2 | 0.46 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.id = ?
Parameters:
[
4947
]
|
3 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 WHERE t0.main_category_id = ? LIMIT 8
Parameters:
[
72
]
|
4 | 0.65 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
5 | 0.35 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
6 | 0.32 ms |
SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.rating AS rating_2, r0_.description AS description_3, r0_.author AS author_4, r0_.email AS email_5, r0_.status AS status_6, r0_.product_id AS product_id_7 FROM reviews r0_ WHERE r0_.product_id = ? AND r0_.status = 1 ORDER BY r0_.date DESC LIMIT 100
Parameters:
[
4947
]
|
7 | 0.39 ms |
SELECT avg(r0_.rating) AS sclr_0 FROM reviews r0_ WHERE r0_.product_id = ? AND r0_.status = 1
Parameters:
[
4947
]
|
8 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
9 | 0.35 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
10 | 0.33 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
4947
]
|
11 | 0.42 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"INFO_DATE_FROM"
]
|
12 | 0.49 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"INFO_DATE_TO"
]
|
13 | 0.37 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"LANDLINE_PHONE"
]
|
14 | 0.26 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"MOBILE_PHONE"
]
|
15 | 0.26 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"EMAIL"
]
|
16 | 0.26 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"INFO_TEXT"
]
|
17 | 0.29 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"INFO_COLOR_TEXT"
]
|
18 | 0.30 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"INFO_COLOR_BG"
]
|
19 | 1.90 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.left_side AS left_side_6, t0.right_side AS right_side_7, t0.level AS level_8, t0.active AS active_9, t0.url AS url_10, t0.visible_in_horizontal_menu AS visible_in_horizontal_menu_11, t0.visible_in_footer AS visible_in_footer_12, t0.short_description AS short_description_13, t0.parent_id AS parent_id_14, t0.price_factor_id AS price_factor_id_15 FROM category t0 WHERE t0.active = ? ORDER BY t0.left_side ASC
Parameters:
[
1
]
|
20 | 2.12 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.left_side AS left_side_5, c0_.right_side AS right_side_6, c0_.level AS level_7, c0_.active AS active_8, c0_.url AS url_9, c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10, c0_.visible_in_footer AS visible_in_footer_11, c0_.short_description AS short_description_12, c0_.parent_id AS parent_id_13, c0_.price_factor_id AS price_factor_id_14 FROM category c0_ WHERE c0_.level >= 1 AND c0_.level <= 3 AND c0_.active = 1 AND c0_.visible_in_horizontal_menu = 1 ORDER BY c0_.left_side ASC
Parameters:
[] |
21 | 0.58 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
688789
]
|
22 | 0.32 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17731
]
|
23 | 1.15 ms |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.filename AS filename_3, t0.original_name AS original_name_4, t0.format AS format_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
842990
]
|
24 | 0.29 ms |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.filename AS filename_3, t0.original_name AS original_name_4, t0.format AS format_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
937684
]
|
25 | 0.68 ms |
SELECT t0.id AS id_1, t0.hash AS hash_2, t0.filename AS filename_3, t0.original_name AS original_name_4, t0.format AS format_5 FROM file t0 WHERE t0.id = ?
Parameters:
[
1461699
]
|
26 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
3
]
|
27 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lead_time AS lead_time_3, t0.margin AS margin_4, t0.discount AS discount_5, t0.price_list_id AS price_list_id_6 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
2
]
|
28 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
29 | 0.29 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
30 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.unit_of_measure AS unit_of_measure_3, t0.print_height AS print_height_4, t0.print_width AS print_width_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.product_id AS product_id_8, t0.marking_price_list_id AS marking_price_list_id_9 FROM product_locations t0 WHERE t0.product_id = ?
Parameters:
[
4947
]
|
31 | 0.33 ms |
SELECT t0.id AS id_1, t0.max_number_of_colors AS max_number_of_colors_2, t0.deleted AS deleted_3, t0.for_client AS for_client_4, t0.active AS active_5, t0.location_id AS location_id_6, t0.technique_id AS technique_id_7, t0.marking_price_list_id AS marking_price_list_id_8 FROM product_locations_technique t0 WHERE t0.location_id = ?
Parameters:
[
9723
]
|
32 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.marking_code AS marking_code_3, t0.max_number_of_colors AS max_number_of_colors_4, t0.fullcolor AS fullcolor_5, t0.filetype AS filetype_6, t0.active AS active_7, t0.supplier_id AS supplier_id_8, t0.marking_description_id AS marking_description_id_9 FROM marking_technique t0 WHERE t0.id = ?
Parameters:
[
131
]
|
33 | 0.35 ms |
SELECT t0.id AS id_1, t0.max_number_of_colors AS max_number_of_colors_2, t0.deleted AS deleted_3, t0.for_client AS for_client_4, t0.active AS active_5, t0.location_id AS location_id_6, t0.technique_id AS technique_id_7, t0.marking_price_list_id AS marking_price_list_id_8 FROM product_locations_technique t0 WHERE t0.location_id = ?
Parameters:
[
50293
]
|
34 | 0.32 ms |
SELECT t0.id AS id_1, t0.max_number_of_colors AS max_number_of_colors_2, t0.deleted AS deleted_3, t0.for_client AS for_client_4, t0.active AS active_5, t0.location_id AS location_id_6, t0.technique_id AS technique_id_7, t0.marking_price_list_id AS marking_price_list_id_8 FROM product_locations_technique t0 WHERE t0.location_id = ?
Parameters:
[
65060
]
|
35 | 0.31 ms |
SELECT t0.id AS id_1, t0.max_number_of_colors AS max_number_of_colors_2, t0.deleted AS deleted_3, t0.for_client AS for_client_4, t0.active AS active_5, t0.location_id AS location_id_6, t0.technique_id AS technique_id_7, t0.marking_price_list_id AS marking_price_list_id_8 FROM product_locations_technique t0 WHERE t0.location_id = ?
Parameters:
[
65061
]
|
36 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
37 | 0.32 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
38 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
39 | 0.44 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
40 | 0.34 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
7709
]
|
41 | 0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
6
]
|
42 | 0.31 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
43 | 0.29 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
44 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17732
]
|
45 | 0.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
4
]
|
46 | 0.29 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
47 | 0.28 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
48 | 0.27 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17733
]
|
49 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
5
]
|
50 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
51 | 0.26 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
52 | 0.62 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17734
]
|
53 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
12
]
|
54 | 0.29 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
55 | 0.27 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
56 | 0.27 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
688805
]
|
57 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
7
]
|
58 | 0.28 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
59 | 0.30 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
60 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
688809
]
|
61 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
16
]
|
62 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
63 | 0.28 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
64 | 0.35 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17737
]
|
65 | 0.27 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
9
]
|
66 | 0.27 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
67 | 0.30 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
68 | 0.28 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.product_variant_id = ?
Parameters:
[
17738
]
|
69 | 0.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.hex_code AS hex_code_3 FROM product_color t0 WHERE t0.id = ?
Parameters:
[
11
]
|
70 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
71 | 0.32 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
72 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.product_code AS product_code_3, t0.description AS description_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.url AS url_7, t0.weight AS weight_8, t0.min_amount AS min_amount_9, t0.price_netto AS price_netto_10, t0.vat AS vat_11, t0.promotional_price AS promotional_price_12, t0.homepage AS homepage_13, t0.recommended AS recommended_14, t0.new AS new_15, t0.active AS active_16, t0.calculator AS calculator_17, t0.supplier_product_id AS supplier_product_id_18, t0.bestseller AS bestseller_19, t0.final_price AS final_price_20, t0.is_visible_in_uncategorized AS is_visible_in_uncategorized_21, t0.supplier_id AS supplier_id_22, t0.main_category_id AS main_category_id_23, t0.price_factor_id AS price_factor_id_24, t0.handling_cost_id AS handling_cost_id_25, t0.main_product_variant_file_id AS main_product_variant_file_id_26, t0.canonical_variant_id AS canonical_variant_id_27 FROM product t0 INNER JOIN product_product ON t0.id = product_product.product_target WHERE product_product.product_source = ?
Parameters:
[
4947
]
|
73 | 0.38 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
472772
]
|
74 | 0.39 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2244
]
|
75 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lead_time AS lead_time_3, t0.margin AS margin_4, t0.discount AS discount_5, t0.price_list_id AS price_list_id_6 FROM supplier t0 WHERE t0.id = ?
Parameters:
[
3
]
|
76 | 0.35 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.86" "0.86" ] |
77 | 0.34 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
78 | 0.28 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
472945
]
|
79 | 0.33 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2251
]
|
80 | 0.27 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "2.49" "2.49" ] |
81 | 0.29 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
22
]
|
82 | 0.31 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
472964
]
|
83 | 0.29 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2255
]
|
84 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "4.99" "4.99" ] |
85 | 0.31 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
50
]
|
86 | 0.29 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
473939
]
|
87 | 0.30 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2288
]
|
88 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "1.49" "1.49" ] |
89 | 0.29 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
16
]
|
90 | 0.30 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
474275
]
|
91 | 0.29 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2300
]
|
92 | 0.33 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "2.79" "2.79" ] |
93 | 0.27 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
46
]
|
94 | 0.25 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
474308
]
|
95 | 0.23 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2301
]
|
96 | 0.24 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "1.19" "1.19" ] |
97 | 0.25 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
16
]
|
98 | 0.22 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
474333
]
|
99 | 0.24 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2302
]
|
100 | 0.23 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "1.09" "1.09" ] |
101 | 0.22 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
16
]
|
102 | 0.28 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.to_delete AS to_delete_3, t0.alt AS alt_4, t0.from_import AS from_import_5, t0.file_id AS file_id_6, t0.product_variant_id AS product_variant_id_7 FROM product_variant_file t0 WHERE t0.id = ?
Parameters:
[
474910
]
|
103 | 0.28 ms |
SELECT t0.id AS id_1, t0.variant_code AS variant_code_2, t0.size AS size_3, t0.system_magazine AS system_magazine_4, t0.own_magazine AS own_magazine_5, t0.delivery_magazine AS delivery_magazine_6, t0.delivery_magazine_date AS delivery_magazine_date_7, t0.color_hex AS color_hex_8, t0.url AS url_9, t0.in_week_magazine AS in_week_magazine_10, t0.material AS material_11, t0.delivery_magazine_label AS delivery_magazine_label_12, t0.product_id AS product_id_13, t0.variant_color_id AS variant_color_id_14, t0.main_image_id AS main_image_id_15 FROM product_variant t0 WHERE t0.product_id = ?
Parameters:
[
2320
]
|
104 | 0.25 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "1.15" "1.15" ] |
105 | 0.26 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
16
]
|
106 | 0.36 ms |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.seo_title AS seo_title_3, c0_.seo_description AS seo_description_4, c0_.left_side AS left_side_5, c0_.right_side AS right_side_6, c0_.level AS level_7, c0_.active AS active_8, c0_.url AS url_9, c0_.visible_in_horizontal_menu AS visible_in_horizontal_menu_10, c0_.visible_in_footer AS visible_in_footer_11, c0_.short_description AS short_description_12, c0_.parent_id AS parent_id_13, c0_.price_factor_id AS price_factor_id_14 FROM category c0_ WHERE c0_.active = 1 AND c0_.visible_in_footer = 1
Parameters:
[] |
107 | 0.27 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"LANDLINE_PHONE"
]
|
108 | 0.26 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"MOBILE_PHONE"
]
|
109 | 0.34 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"FAX_PHONE"
]
|
110 | 0.24 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.value AS value_3, t0.display_name AS display_name_4 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1
Parameters:
[
"EMAIL"
]
|
111 | 0.28 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price_from AS price_from_2, p0_.price_to AS price_to_3 FROM price_factor p0_ WHERE p0_.price_from <= ? AND p0_.price_to > ? ORDER BY p0_.id ASC LIMIT 1
Parameters:
[ "0.72" "0.72" ] |
112 | 0.26 ms |
SELECT t0.id AS id_1, t0.amount_from AS amount_from_2, t0.amount_to AS amount_to_3, t0.margin AS margin_4, t0.price_factor_id AS price_factor_id_5 FROM price_factor_item t0 WHERE t0.price_factor_id = ?
Parameters:
[
14
]
|
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\Category | 115 |
App\Entity\ProductVariant | 49 |
App\Entity\ProductVariantFile | 35 |
App\Entity\File | 35 |
App\Entity\PriceFactorItem | 16 |
App\Entity\ProductColor | 10 |
App\Entity\Product | 9 |
App\Entity\Settings | 9 |
App\Entity\PriceFactor | 6 |
App\Entity\ProductLocationsTechnique | 5 |
App\Entity\ProductLocations | 4 |
App\Entity\Supplier | 2 |
App\Entity\MarkingPriceList | 2 |
App\Entity\MarkingTechnique | 2 |
App\Entity\MarkingPriceListHandlingCost | 1 |
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\ProductVariant | No errors. |
App\Entity\Product |
|
App\Entity\ProductColor | No errors. |
App\Entity\ProductVariantFile | No errors. |
App\Entity\Supplier | No errors. |
App\Entity\Category | No errors. |
App\Entity\PriceFactor | No errors. |
App\Entity\MarkingPriceListHandlingCost |
|
App\Entity\ProductLocations | No errors. |
App\Entity\PriceLog | No errors. |
App\Entity\Reviews | No errors. |
App\Entity\PriceFactorItem | No errors. |
App\Entity\Settings | No errors. |
App\Entity\File | No errors. |
App\Entity\MarkingPriceList |
|
App\Entity\ProductLocationsTechnique |
|
App\Entity\ProductLocationFile | No errors. |
App\Entity\MarkingPriceListType | No errors. |
App\Entity\MarkingTechnique |
|
App\Entity\MarkingPriceListCost | No errors. |
App\Entity\MarkingPriceListExtraCost | No errors. |
App\Entity\MarkingDescription | No errors. |