Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.param_id AS param_id_3,
  t0.param_value AS param_value_4,
  t0.product_id AS product_id_5,
  t0.param_id AS param_id_6
FROM
  kw_eshop_co_product_params t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.param_id AS param_id_3, t0.param_value AS param_value_4, t0.product_id AS product_id_5, t0.param_id AS param_id_6 FROM kw_eshop_co_product_params t0 WHERE t0.product_id = 1702;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.title AS title_3,
  t0.seo_name AS seo_name_4,
  t0.display_name AS display_name_5,
  t0.info_emails AS info_emails_6,
  t0.parent_row_id AS parent_row_id_7,
  t0.prevent_changes AS prevent_changes_8,
  t0.system_folder AS system_folder_9,
  t0.image_id AS image_id_10,
  t0.image_secondary_id AS image_secondary_id_11,
  t0.article_id AS article_id_12,
  t0.opt_one AS opt_one_13,
  t0.opt_two AS opt_two_14,
  t0.opt_three AS opt_three_15,
  t0.opt_four AS opt_four_16,
  t0.sort_num AS sort_num_17,
  t0.temp_id AS temp_id_18,
  t0.parent_row_id AS parent_row_id_19,
  t0.image_id AS image_id_20,
  t0.image_secondary_id AS image_secondary_id_21,
  t0.article_id AS article_id_22
FROM
  kw_eshop_kategorie t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.seo_name AS seo_name_4, t0.display_name AS display_name_5, t0.info_emails AS info_emails_6, t0.parent_row_id AS parent_row_id_7, t0.prevent_changes AS prevent_changes_8, t0.system_folder AS system_folder_9, t0.image_id AS image_id_10, t0.image_secondary_id AS image_secondary_id_11, t0.article_id AS article_id_12, t0.opt_one AS opt_one_13, t0.opt_two AS opt_two_14, t0.opt_three AS opt_three_15, t0.opt_four AS opt_four_16, t0.sort_num AS sort_num_17, t0.temp_id AS temp_id_18, t0.parent_row_id AS parent_row_id_19, t0.image_id AS image_id_20, t0.image_secondary_id AS image_secondary_id_21, t0.article_id AS article_id_22 FROM kw_eshop_kategorie t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.category_id AS category_id_3,
  t0.product_id AS product_id_4,
  t0.category_id AS category_id_5
FROM
  kw_eshop_co_product_category t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3, t0.product_id AS product_id_4, t0.category_id AS category_id_5 FROM kw_eshop_co_product_category t0 WHERE t0.product_id = 1702;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_alt AS name_alt_3,
  t0.folder_id AS folder_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.extension AS extension_8,
  t0.alt_name AS alt_name_9,
  t0.alt_desc_1 AS alt_desc_1_10,
  t0.alt_desc_2 AS alt_desc_2_11,
  t0.parent_id AS parent_id_12,
  t0.type AS type_13,
  t0.sort_num AS sort_num_14,
  t0.folder_id AS folder_id_15,
  t0.parent_id AS parent_id_16
FROM
  kw_tree_image_gallery_images t0
WHERE
  t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_alt AS name_alt_3, t0.folder_id AS folder_id_4, t0.prevent_changes AS prevent_changes_5, t0.width AS width_6, t0.height AS height_7, t0.extension AS extension_8, t0.alt_name AS alt_name_9, t0.alt_desc_1 AS alt_desc_1_10, t0.alt_desc_2 AS alt_desc_2_11, t0.parent_id AS parent_id_12, t0.type AS type_13, t0.sort_num AS sort_num_14, t0.folder_id AS folder_id_15, t0.parent_id AS parent_id_16 FROM kw_tree_image_gallery_images t0 WHERE t0.parent_id = 8899 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.attachment_id AS attachment_id_3,
  t0.file_id AS file_id_4,
  t0.product_id AS product_id_5,
  t0.attachment_id AS attachment_id_6,
  t0.file_id AS file_id_7
FROM
  kw_eshop_co_product_attachment t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.attachment_id AS attachment_id_3, t0.file_id AS file_id_4, t0.product_id AS product_id_5, t0.attachment_id AS attachment_id_6, t0.file_id AS file_id_7 FROM kw_eshop_co_product_attachment t0 WHERE t0.product_id = 1702;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_alt AS name_alt_3,
  t0.folder_id AS folder_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.extension AS extension_8,
  t0.alt_name AS alt_name_9,
  t0.alt_desc_1 AS alt_desc_1_10,
  t0.alt_desc_2 AS alt_desc_2_11,
  t0.parent_id AS parent_id_12,
  t0.type AS type_13,
  t0.sort_num AS sort_num_14,
  t0.folder_id AS folder_id_15,
  t0.parent_id AS parent_id_16
FROM
  kw_tree_image_gallery_images t0
WHERE
  t0.folder_id = ?
  AND t0.type = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_alt AS name_alt_3, t0.folder_id AS folder_id_4, t0.prevent_changes AS prevent_changes_5, t0.width AS width_6, t0.height AS height_7, t0.extension AS extension_8, t0.alt_name AS alt_name_9, t0.alt_desc_1 AS alt_desc_1_10, t0.alt_desc_2 AS alt_desc_2_11, t0.parent_id AS parent_id_12, t0.type AS type_13, t0.sort_num AS sort_num_14, t0.folder_id AS folder_id_15, t0.parent_id AS parent_id_16 FROM kw_tree_image_gallery_images t0 WHERE t0.folder_id = 1958 AND t0.type = 'image' ORDER BY t0.sort_num ASC;

SELECT
  k0_.id AS id_0,
  k0_.project_name AS project_name_1,
  k0_.domains AS domains_2,
  k0_.user_id AS user_id_3,
  k0_.eshop_id AS eshop_id_4,
  k0_.user_id AS user_id_5,
  k0_.eshop_id AS eshop_id_6
FROM
  kw_web k0_
WHERE
  k0_.domains LIKE ?
LIMIT
  1

SELECT k0_.id AS id_0, k0_.project_name AS project_name_1, k0_.domains AS domains_2, k0_.user_id AS user_id_3, k0_.eshop_id AS eshop_id_4, k0_.user_id AS user_id_5, k0_.eshop_id AS eshop_id_6 FROM kw_web k0_ WHERE k0_.domains LIKE '%farline.dot11.cz%' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.web_id AS web_id_4,
  t0.web_id AS web_id_5
FROM
  kw_languages t0
WHERE
  t0.code = ?
  AND t0.web_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_languages t0 WHERE t0.code = 'cz' AND t0.web_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.namespace AS namespace_2,
  t0.page_id AS page_id_3,
  t0.placeholder_id AS placeholder_id_4,
  t0.template_id AS template_id_5,
  t0.template_dso_service AS template_dso_service_6,
  t0.template_dso_method AS template_dso_method_7,
  t0.article_id AS article_id_8,
  t0.gallery_id AS gallery_id_9,
  t0.database_namespace AS database_namespace_10,
  t0.database_query AS database_query_11,
  t0.map_id AS map_id_12,
  t0.mirror_id AS mirror_id_13,
  t0.language_id AS language_id_14,
  t0.prevent_changes AS prevent_changes_15,
  t0.calendar_id AS calendar_id_16,
  t0.is_active AS is_active_17,
  t0.sort_num AS sort_num_18,
  t0.page_id AS page_id_19,
  t0.placeholder_id AS placeholder_id_20,
  t0.template AS template_21,
  t0.article_id AS article_id_22,
  t0.gallery_id AS gallery_id_23,
  t0.map_id AS map_id_24,
  t0.mirror_id AS mirror_id_25,
  t0.language_id AS language_id_26,
  t0.calendar_id AS calendar_id_27
FROM
  kw_tree_page_modules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.namespace AS namespace_2, t0.page_id AS page_id_3, t0.placeholder_id AS placeholder_id_4, t0.template_id AS template_id_5, t0.template_dso_service AS template_dso_service_6, t0.template_dso_method AS template_dso_method_7, t0.article_id AS article_id_8, t0.gallery_id AS gallery_id_9, t0.database_namespace AS database_namespace_10, t0.database_query AS database_query_11, t0.map_id AS map_id_12, t0.mirror_id AS mirror_id_13, t0.language_id AS language_id_14, t0.prevent_changes AS prevent_changes_15, t0.calendar_id AS calendar_id_16, t0.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.page_name AS page_name_3,
  t0.parent_row_id AS parent_row_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.sort_num AS sort_num_6,
  t0.layout_id AS layout_id_7,
  t0.in_menu_display AS in_menu_display_8,
  t0.image_id AS image_id_9,
  t0.gallery_id AS gallery_id_10,
  t0.redirect_id AS redirect_id_11,
  t0.redirect_suffix AS redirect_suffix_12,
  t0.is_templates_root AS is_templates_root_13,
  t0.system_folder AS system_folder_14,
  t0.opt_one AS opt_one_15,
  t0.opt_two AS opt_two_16,
  t0.opt_three AS opt_three_17,
  t0.web_id AS web_id_18,
  t0.parent_row_id AS parent_row_id_19,
  t0.layout_id AS layout_id_20,
  t0.image_id AS image_id_21,
  t0.gallery_id AS gallery_id_22,
  t0.redirect_id AS redirect_id_23,
  t0.web_id AS web_id_24
FROM
  kw_tree_page t0
WHERE
  t0.parent_row_id = ?
  AND t0.web_id = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id = 11 AND t0.web_id = 1 ORDER BY t0.sort_num ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phrase AS phrase_3,
  t0.language_id AS language_id_4,
  t0.language_id AS language_id_5
FROM
  kw_phrases t0
WHERE
  t0.name = ?
  AND t0.language_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = 'cookie-agree' AND t0.language_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phrase AS phrase_3,
  t0.language_id AS language_id_4,
  t0.language_id AS language_id_5
FROM
  kw_phrases t0
WHERE
  t0.name = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = 'cookie-agree';

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image_id AS image_id_4,
  t0.image_2_id AS image_2_id_5,
  t0.eshop_id AS eshop_id_6,
  t0.article_id AS article_id_7,
  t0.sort_num AS sort_num_8,
  t0.image_id AS image_id_9,
  t0.image_2_id AS image_2_id_10,
  t0.eshop_id AS eshop_id_11,
  t0.article_id AS article_id_12
FROM
  kw_eshop_producers t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.image_id AS image_id_4, t0.image_2_id AS image_2_id_5, t0.eshop_id AS eshop_id_6, t0.article_id AS article_id_7, t0.sort_num AS sort_num_8, t0.image_id AS image_id_9, t0.image_2_id AS image_2_id_10, t0.eshop_id AS eshop_id_11, t0.article_id AS article_id_12 FROM kw_eshop_producers t0 WHERE t0.code = 'castelvetro' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sub_constant_key AS sub_constant_key_2,
  t0.content AS content_3,
  t0.content_prefix AS content_prefix_4,
  t0.content_suffix AS content_suffix_5,
  t0.global_constant_id AS global_constant_id_6,
  t0.global_constant_id AS global_constant_id_7
FROM
  kw_global_sub_configs t0
WHERE
  t0.global_constant_id = ?
  AND t0.sub_constant_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sub_constant_key AS sub_constant_key_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.global_constant_id AS global_constant_id_6, t0.global_constant_id AS global_constant_id_7 FROM kw_global_sub_configs t0 WHERE t0.global_constant_id = 1 AND t0.sub_constant_key = 'page-21' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.content_prefix AS content_prefix_4,
  t0.content_suffix AS content_suffix_5,
  t0.groupper AS groupper_6,
  t0.type AS type_7,
  t0.language_id AS language_id_8,
  t0.web_id AS web_id_9,
  t0.language_id AS language_id_10,
  t0.web_id AS web_id_11
FROM
  kw_global_configs t0
WHERE
  t0.name = ?
  AND t0.language_id = ?
  AND t0.web_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.groupper AS groupper_6, t0.type AS type_7, t0.language_id AS language_id_8, t0.web_id AS web_id_9, t0.language_id AS language_id_10, t0.web_id AS web_id_11 FROM kw_global_configs t0 WHERE t0.name = 'title' AND t0.language_id = 1 AND t0.web_id = 1 LIMIT 1;

INSERT INTO kw_eshop_logger (
  log_key, message, created_time, is_error,
  is_sent
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES ('order-store', 'TEST: Vracim kosik', '2026-01-20 14:04:38', 0, 0);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.group_id AS group_id_3,
  t0.tpl AS tpl_4,
  t0.kiwi_tpl AS kiwi_tpl_5,
  t0.group_id AS group_id_6
FROM
  kw_templates_modules_groups_templates t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.group_id AS group_id_3, t0.tpl AS tpl_4, t0.kiwi_tpl AS kiwi_tpl_5, t0.group_id AS group_id_6 FROM kw_templates_modules_groups_templates t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.added AS added_3,
  t0.web_id AS web_id_4,
  t0.web_id AS web_id_5
FROM
  kw_templates_modules_groups t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_templates_modules_groups t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.version_num AS version_num_2,
  t0.last_update AS last_update_3
FROM
  kw_images_cache_version t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.version_num AS version_num_2, t0.last_update AS last_update_3 FROM kw_images_cache_version t0 WHERE t0.id = 1;

SELECT
  k0_.id AS id_0,
  k0_.product_id AS product_id_1,
  k0_.category_id AS category_id_2,
  k0_.product_id AS product_id_3,
  k0_.category_id AS category_id_4
FROM
  kw_eshop_co_product_category k0_
  INNER JOIN kw_eshop_kategorie k1_ ON k0_.category_id = k1_.id
WHERE
  k0_.product_id = 1657
  AND k1_.parent_row_id IS NULL
LIMIT
  1

SELECT k0_.id AS id_0, k0_.product_id AS product_id_1, k0_.category_id AS category_id_2, k0_.product_id AS product_id_3, k0_.category_id AS category_id_4 FROM kw_eshop_co_product_category k0_ INNER JOIN kw_eshop_kategorie k1_ ON k0_.category_id = k1_.id WHERE k0_.product_id = 1657 AND k1_.parent_row_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_alt AS name_alt_3,
  t0.folder_id AS folder_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.width AS width_6,
  t0.height AS height_7,
  t0.extension AS extension_8,
  t0.alt_name AS alt_name_9,
  t0.alt_desc_1 AS alt_desc_1_10,
  t0.alt_desc_2 AS alt_desc_2_11,
  t0.parent_id AS parent_id_12,
  t0.type AS type_13,
  t0.sort_num AS sort_num_14,
  t0.folder_id AS folder_id_15,
  t0.parent_id AS parent_id_16
FROM
  kw_tree_image_gallery_images t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_alt AS name_alt_3, t0.folder_id AS folder_id_4, t0.prevent_changes AS prevent_changes_5, t0.width AS width_6, t0.height AS height_7, t0.extension AS extension_8, t0.alt_name AS alt_name_9, t0.alt_desc_1 AS alt_desc_1_10, t0.alt_desc_2 AS alt_desc_2_11, t0.parent_id AS parent_id_12, t0.type AS type_13, t0.sort_num AS sort_num_14, t0.folder_id AS folder_id_15, t0.parent_id AS parent_id_16 FROM kw_tree_image_gallery_images t0 WHERE t0.id = 7208;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.name_alt_1 AS name_alt_1_2,
  k0_.name_alt_2 AS name_alt_2_3,
  k0_.name_letter AS name_letter_4,
  k0_.code AS code_5,
  k0_.created_time AS created_time_6,
  k0_.updated_time AS updated_time_7,
  k0_.description_fast AS description_fast_8,
  k0_.description AS description_9,
  k0_.action_text AS action_text_10,
  k0_.quantity AS quantity_11,
  k0_.quantity_in_package AS quantity_in_package_12,
  k0_.weight_g AS weight_g_13,
  k0_.price_purchase AS price_purchase_14,
  k0_.price_sale AS price_sale_15,
  k0_.price_action AS price_action_16,
  k0_.price_without_vat AS price_without_vat_17,
  k0_.price_package_with_vat AS price_package_with_vat_18,
  k0_.stock_show AS stock_show_19,
  k0_.stock_alt AS stock_alt_20,
  k0_.vat_id AS vat_id_21,
  k0_.is_action AS is_action_22,
  k0_.is_new AS is_new_23,
  k0_.is_tip AS is_tip_24,
  k0_.currency_id AS currency_id_25,
  k0_.unit_id AS unit_id_26,
  k0_.gallery_id AS gallery_id_27,
  k0_.producer_id AS producer_id_28,
  k0_.eshop_id AS eshop_id_29,
  k0_.holder_id AS holder_id_30,
  k0_.is_deleted AS is_deleted_31,
  k0_.is_hidden AS is_hidden_32,
  k0_.is_holder AS is_holder_33,
  k0_.sort_num AS sort_num_34,
  k0_.vat_id AS vat_id_35,
  k0_.currency_id AS currency_id_36,
  k0_.unit_id AS unit_id_37,
  k0_.gallery_id AS gallery_id_38,
  k0_.producer_id AS producer_id_39,
  k0_.eshop_id AS eshop_id_40,
  k0_.holder_id AS holder_id_41
FROM
  kw_eshop_co_product_category k1_
  LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id)
  LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id)
WHERE
  k0_.is_deleted = 0
  AND k0_.eshop_id = 1
  AND k0_.stock_alt >= 0
  AND k0_.producer_id IN (62)
GROUP BY
  k0_.id
ORDER BY
  k0_.id DESC
LIMIT
  10000

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.name_alt_1 AS name_alt_1_2, k0_.name_alt_2 AS name_alt_2_3, k0_.name_letter AS name_letter_4, k0_.code AS code_5, k0_.created_time AS created_time_6, k0_.updated_time AS updated_time_7, k0_.description_fast AS description_fast_8, k0_.description AS description_9, k0_.action_text AS action_text_10, k0_.quantity AS quantity_11, k0_.quantity_in_package AS quantity_in_package_12, k0_.weight_g AS weight_g_13, k0_.price_purchase AS price_purchase_14, k0_.price_sale AS price_sale_15, k0_.price_action AS price_action_16, k0_.price_without_vat AS price_without_vat_17, k0_.price_package_with_vat AS price_package_with_vat_18, k0_.stock_show AS stock_show_19, k0_.stock_alt AS stock_alt_20, k0_.vat_id AS vat_id_21, k0_.is_action AS is_action_22, k0_.is_new AS is_new_23, k0_.is_tip AS is_tip_24, k0_.currency_id AS currency_id_25, k0_.unit_id AS unit_id_26, k0_.gallery_id AS gallery_id_27, k0_.producer_id AS producer_id_28, k0_.eshop_id AS eshop_id_29, k0_.holder_id AS holder_id_30, k0_.is_deleted AS is_deleted_31, k0_.is_hidden AS is_hidden_32, k0_.is_holder AS is_holder_33, k0_.sort_num AS sort_num_34, k0_.vat_id AS vat_id_35, k0_.currency_id AS currency_id_36, k0_.unit_id AS unit_id_37, k0_.gallery_id AS gallery_id_38, k0_.producer_id AS producer_id_39, k0_.eshop_id AS eshop_id_40, k0_.holder_id AS holder_id_41 FROM kw_eshop_co_product_category k1_ LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id) LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id) WHERE k0_.is_deleted = 0 AND k0_.eshop_id = 1 AND k0_.stock_alt >= 0 AND k0_.producer_id IN (62) GROUP BY k0_.id ORDER BY k0_.id DESC LIMIT 10000;

SELECT
  k0_.id AS id_0,
  k0_.name AS name_1,
  k0_.name_alt_1 AS name_alt_1_2,
  k0_.name_alt_2 AS name_alt_2_3,
  k0_.name_letter AS name_letter_4,
  k0_.code AS code_5,
  k0_.created_time AS created_time_6,
  k0_.updated_time AS updated_time_7,
  k0_.description_fast AS description_fast_8,
  k0_.description AS description_9,
  k0_.action_text AS action_text_10,
  k0_.quantity AS quantity_11,
  k0_.quantity_in_package AS quantity_in_package_12,
  k0_.weight_g AS weight_g_13,
  k0_.price_purchase AS price_purchase_14,
  k0_.price_sale AS price_sale_15,
  k0_.price_action AS price_action_16,
  k0_.price_without_vat AS price_without_vat_17,
  k0_.price_package_with_vat AS price_package_with_vat_18,
  k0_.stock_show AS stock_show_19,
  k0_.stock_alt AS stock_alt_20,
  k0_.vat_id AS vat_id_21,
  k0_.is_action AS is_action_22,
  k0_.is_new AS is_new_23,
  k0_.is_tip AS is_tip_24,
  k0_.currency_id AS currency_id_25,
  k0_.unit_id AS unit_id_26,
  k0_.gallery_id AS gallery_id_27,
  k0_.producer_id AS producer_id_28,
  k0_.eshop_id AS eshop_id_29,
  k0_.holder_id AS holder_id_30,
  k0_.is_deleted AS is_deleted_31,
  k0_.is_hidden AS is_hidden_32,
  k0_.is_holder AS is_holder_33,
  k0_.sort_num AS sort_num_34,
  k0_.vat_id AS vat_id_35,
  k0_.currency_id AS currency_id_36,
  k0_.unit_id AS unit_id_37,
  k0_.gallery_id AS gallery_id_38,
  k0_.producer_id AS producer_id_39,
  k0_.eshop_id AS eshop_id_40,
  k0_.holder_id AS holder_id_41
FROM
  kw_eshop_co_product_category k1_
  LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id)
  LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id)
WHERE
  k0_.is_deleted = 0
  AND k0_.eshop_id = 1
  AND k0_.stock_alt >= 0
  AND k0_.producer_id IN (62)
GROUP BY
  k0_.id
ORDER BY
  k0_.id DESC

SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.name_alt_1 AS name_alt_1_2, k0_.name_alt_2 AS name_alt_2_3, k0_.name_letter AS name_letter_4, k0_.code AS code_5, k0_.created_time AS created_time_6, k0_.updated_time AS updated_time_7, k0_.description_fast AS description_fast_8, k0_.description AS description_9, k0_.action_text AS action_text_10, k0_.quantity AS quantity_11, k0_.quantity_in_package AS quantity_in_package_12, k0_.weight_g AS weight_g_13, k0_.price_purchase AS price_purchase_14, k0_.price_sale AS price_sale_15, k0_.price_action AS price_action_16, k0_.price_without_vat AS price_without_vat_17, k0_.price_package_with_vat AS price_package_with_vat_18, k0_.stock_show AS stock_show_19, k0_.stock_alt AS stock_alt_20, k0_.vat_id AS vat_id_21, k0_.is_action AS is_action_22, k0_.is_new AS is_new_23, k0_.is_tip AS is_tip_24, k0_.currency_id AS currency_id_25, k0_.unit_id AS unit_id_26, k0_.gallery_id AS gallery_id_27, k0_.producer_id AS producer_id_28, k0_.eshop_id AS eshop_id_29, k0_.holder_id AS holder_id_30, k0_.is_deleted AS is_deleted_31, k0_.is_hidden AS is_hidden_32, k0_.is_holder AS is_holder_33, k0_.sort_num AS sort_num_34, k0_.vat_id AS vat_id_35, k0_.currency_id AS currency_id_36, k0_.unit_id AS unit_id_37, k0_.gallery_id AS gallery_id_38, k0_.producer_id AS producer_id_39, k0_.eshop_id AS eshop_id_40, k0_.holder_id AS holder_id_41 FROM kw_eshop_co_product_category k1_ LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id) LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id) WHERE k0_.is_deleted = 0 AND k0_.eshop_id = 1 AND k0_.stock_alt >= 0 AND k0_.producer_id IN (62) GROUP BY k0_.id ORDER BY k0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.page_name AS page_name_3,
  t0.parent_row_id AS parent_row_id_4,
  t0.prevent_changes AS prevent_changes_5,
  t0.sort_num AS sort_num_6,
  t0.layout_id AS layout_id_7,
  t0.in_menu_display AS in_menu_display_8,
  t0.image_id AS image_id_9,
  t0.gallery_id AS gallery_id_10,
  t0.redirect_id AS redirect_id_11,
  t0.redirect_suffix AS redirect_suffix_12,
  t0.is_templates_root AS is_templates_root_13,
  t0.system_folder AS system_folder_14,
  t0.opt_one AS opt_one_15,
  t0.opt_two AS opt_two_16,
  t0.opt_three AS opt_three_17,
  t0.web_id AS web_id_18,
  t0.parent_row_id AS parent_row_id_19,
  t0.layout_id AS layout_id_20,
  t0.image_id AS image_id_21,
  t0.gallery_id AS gallery_id_22,
  t0.redirect_id AS redirect_id_23,
  t0.web_id AS web_id_24
FROM
  kw_tree_page t0
WHERE
  t0.parent_row_id IS NULL
  AND t0.web_id = ?
ORDER BY
  t0.sort_num ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id IS NULL AND t0.web_id = 1 ORDER BY t0.sort_num ASC;