GET https://caprea.jcd.pl/produkt/nozyk-nife/5009/

Query Metrics

83 Database Queries
21 Different statements
25.85 ms Query time
5 Invalid entities
219 Managed entities

Queries

Group similar statements

# Time Info
1 1.84 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:
[
  5009
]
2 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.id = ?
Parameters:
[
  2584
]
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:
[
  68
]
4 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:
[
  "1.29"
  "1.29"
]
5 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:
[
  16
]
6 0.26 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:
[
  2584
]
7 0.23 ms
SELECT avg(r0_.rating) AS sclr_0 FROM reviews r0_ WHERE r0_.product_id = ? AND r0_.status = 1
Parameters:
[
  2584
]
8 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.29"
  "1.29"
]
9 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
]
10 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:
[
  2584
]
11 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:
[
  "INFO_DATE_FROM"
]
12 0.25 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.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:
[
  "LANDLINE_PHONE"
]
14 0.23 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.25 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.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:
[
  "INFO_TEXT"
]
17 0.25 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.25 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.62 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 1.52 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.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:
[
  5009
]
22 0.66 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:
[
  1213652
]
23 0.41 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:
[
  1213653
]
24 0.40 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:
[
  1213654
]
25 0.38 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:
[
  1213655
]
26 0.42 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:
[
  1213656
]
27 0.25 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
]
28 0.26 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
]
29 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:
[
  "1.29"
  "1.29"
]
30 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
]
31 0.24 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:
[
  2584
]
32 0.27 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:
[
  28806
]
33 0.35 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:
[
  92
]
34 0.25 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:
[
  28807
]
35 0.28 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:
[
  100
]
36 0.25 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:
[
  36998
]
37 0.30 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:
[
  36999
]
38 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.29"
  "1.29"
]
39 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
]
40 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.29"
  "1.29"
]
41 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
]
42 0.20 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:
[
  5008
]
43 0.22 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.29"
  "1.29"
]
44 0.19 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
]
45 0.31 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:
[
  2584
]
46 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:
[
  478762
]
47 0.27 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:
[
  2121
]
48 0.26 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:
[
  "9.30"
  "9.30"
]
49 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:
[
  23
]
50 0.26 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:
[
  472939
]
51 0.27 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:
[
  2250
]
52 0.26 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.69"
  "4.69"
]
53 0.24 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
]
54 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:
[
  476934
]
55 0.27 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:
[
  2559
]
56 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:
[
  "8.90"
  "8.90"
]
57 0.24 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:
[
  23
]
58 0.24 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:
[
  476938
]
59 0.25 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:
[
  2560
]
60 0.20 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:
[
  "8.90"
  "8.90"
]
61 0.21 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:
[
  23
]
62 0.19 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:
[
  477101
]
63 0.25 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:
[
  2581
]
64 0.20 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:
[
  "24.50"
  "24.50"
]
65 0.23 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:
[
  28
]
66 0.20 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.29"
  "1.29"
]
67 0.19 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
]
68 0.21 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:
[
  505987
]
69 0.20 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:
[
  2965
]
70 0.19 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
]
71 0.20 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:
[
  "13.55"
  "13.55"
]
72 0.19 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:
[
  25
]
73 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:
[
  505990
]
74 0.22 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:
[
  2966
]
75 0.21 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:
[
  "31.99"
  "31.99"
]
76 0.20 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:
[
  29
]
77 0.32 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:
[]
78 0.20 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"
]
79 0.20 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"
]
80 0.20 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"
]
81 0.19 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"
]
82 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.29"
  "1.29"
]
83 0.20 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
]

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\ProductVariantFile 19
App\Entity\File 19
App\Entity\PriceFactorItem 14
App\Entity\ProductVariant 9
App\Entity\Settings 9
App\Entity\Product 8
App\Entity\PriceFactor 7
App\Entity\ProductLocations 4
App\Entity\ProductLocationsTechnique 4
App\Entity\ProductColor 3
App\Entity\MarkingPriceList 3
App\Entity\Supplier 2
App\Entity\MarkingTechnique 2
App\Entity\MarkingPriceListHandlingCost 1

Entities Mapping

Class Mapping errors
App\Entity\ProductVariant No errors.
App\Entity\Product
  • The field 'App\Entity\Product#finalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The association App\Entity\Product#supplier refers to the inverse side field App\Entity\Supplier#products which does not exist.
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
  • The association App\Entity\MarkingPriceListHandlingCost#supplier refers to the inverse side field App\Entity\Supplier#markingPriceListHandlingCosts which does not exist.
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
  • The association App\Entity\MarkingPriceList#supplier refers to the inverse side field App\Entity\Supplier#markingPriceLists which does not exist.
App\Entity\ProductLocationsTechnique
  • The association App\Entity\ProductLocationsTechnique#technique refers to the inverse side field App\Entity\MarkingTechnique#productLocationsTechniques which does not exist.
App\Entity\ProductLocationFile No errors.
App\Entity\MarkingPriceListType No errors.
App\Entity\MarkingTechnique
  • The association App\Entity\MarkingTechnique#supplier refers to the inverse side field App\Entity\Supplier#markingTechniques which does not exist.
App\Entity\MarkingPriceListCost No errors.
App\Entity\MarkingPriceListExtraCost No errors.
App\Entity\MarkingDescription No errors.