Symfony Profiler

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '252' AND e0_.locale = 'el' AND e0_.object_class = 'App\\Entity\\Product\\Category';

SELECT
  p0_.content AS content_0,
  p0_.field AS field_1
FROM
  product_translations p0_
WHERE
  p0_.foreign_key = ?
  AND p0_.locale = ?
  AND p0_.object_class = ?

SELECT p0_.content AS content_0, p0_.field AS field_1 FROM product_translations p0_ WHERE p0_.foreign_key = '149' AND p0_.locale = 'el' AND p0_.object_class = 'App\\Entity\\Product\\Object\\BaseProduct';

SELECT
  t0.id AS id_1,
  t0.session_id AS session_id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5
FROM
  cart t0
WHERE
  t0.session_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5 FROM cart t0 WHERE t0.session_id = 'cart_69d7909d0420e6.38962849' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p0_.summary AS summary_3,
  p0_.status AS status_4,
  p0_.price_gross_amount AS price_gross_amount_5,
  p0_.price_gross_currency AS price_gross_currency_6,
  p0_.price_with_discount_amount AS price_with_discount_amount_7,
  p0_.price_with_discount_currency AS price_with_discount_currency_8,
  p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9,
  p0_.availability AS availability_10,
  p0_.mfr_code AS mfr_code_11,
  p0_.blk_code AS blk_code_12,
  p0_.offer AS offer_13,
  p0_.cash_back AS cash_back_14,
  p1_.id AS id_15,
  p1_.name AS name_16,
  a2_.name AS name_17,
  a2_.path AS path_18,
  p3_.id AS id_19,
  p3_.name AS name_20,
  p3_.slug AS slug_21,
  a4_.name AS name_22,
  a4_.path AS path_23,
  p5_.slug AS slug_24,
  GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25,
  GROUP_CONCAT(
    DISTINCT CONCAT(p7_.lvl, ':', p7_.name)
    ORDER BY
      p7_.lft ASC SEPARATOR '||'
  ) AS sclr_26
FROM
  products p0_
  INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id)
  INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id)
  AND a4_.discr IN ('manufacturer_logo')
  INNER JOIN products_categories p8_ ON (
    p0_.id = p8_.product_id
    AND p8_.main = 1
  )
  INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id)
  INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id)
  INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id)
  INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id)
  LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id)
  AND a2_.discr IN (
    'article_image', 'product_image',
    'product_category_banner', 'manufacturer_logo',
    'product_reference_pdf', 'product_reference_image',
    'slider_image'
  )
  LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id
WHERE
  (
    p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
    AND p0_.published = ?
    AND p0_.status NOT IN (?, ?)
  )
  AND p0_.discr IN ('product', 'product_kit')
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.status AS status_4, p0_.price_gross_amount AS price_gross_amount_5, p0_.price_gross_currency AS price_gross_currency_6, p0_.price_with_discount_amount AS price_with_discount_amount_7, p0_.price_with_discount_currency AS price_with_discount_currency_8, p0_.warehouse_stock_quantity AS warehouse_stock_quantity_9, p0_.availability AS availability_10, p0_.mfr_code AS mfr_code_11, p0_.blk_code AS blk_code_12, p0_.offer AS offer_13, p0_.cash_back AS cash_back_14, p1_.id AS id_15, p1_.name AS name_16, a2_.name AS name_17, a2_.path AS path_18, p3_.id AS id_19, p3_.name AS name_20, p3_.slug AS slug_21, a4_.name AS name_22, a4_.path AS path_23, p5_.slug AS slug_24, GROUP_CONCAT(DISTINCT p6_.website) AS sclr_25, GROUP_CONCAT(DISTINCT CONCAT(p7_.lvl, ':', p7_.name)  ORDER BY p7_.lft ASC SEPARATOR '||') AS sclr_26 FROM products p0_ INNER JOIN product_manufacturer p3_ ON (p0_.manufacturer_id = p3_.id) INNER JOIN app_file a4_ ON (p3_.logo_id = a4_.id) AND a4_.discr IN ('manufacturer_logo') INNER JOIN products_categories p8_ ON (p0_.id = p8_.product_id AND p8_.main = 1) INNER JOIN product_category p5_ ON (p8_.category_id = p5_.id) INNER JOIN products_categories p9_ ON (p0_.id = p9_.product_id) INNER JOIN product_category p7_ ON (p9_.category_id = p7_.id) INNER JOIN product_type p1_ ON (p0_.type_id = p1_.id) LEFT JOIN app_file a2_ ON (p0_.main_image_id = a2_.id) AND a2_.discr IN ('article_image', 'product_image', 'product_category_banner', 'manufacturer_logo', 'product_reference_pdf', 'product_reference_image', 'slider_image') LEFT JOIN product_extra_website p6_ ON p0_.id = p6_.product_id WHERE (p0_.id IN (145, 146, 150, 151, 152, 153, 222, 223) AND p0_.published = 1 AND p0_.status NOT IN ('view', 'no_view')) AND p0_.discr IN ('product', 'product_kit') GROUP BY p0_.id ORDER BY p0_.name ASC;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.parent_id = 1 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.lft ASC

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.parent_id = 4 ORDER BY t0.lft ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.rate AS rate_3,
  t0.code AS code_4,
  t0.symbol AS symbol_5,
  t0.published AS published_6,
  t0.default_currency AS default_currency_7
FROM
  currency t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.rate AS rate_3, t0.code AS code_4, t0.symbol AS symbol_5, t0.published AS published_6, t0.default_currency AS default_currency_7 FROM currency t0 WHERE t0.code = 'GBP' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.migration_id AS migration_id_1,
  p0_.softone_id AS softone_id_2,
  p0_.name AS name_3,
  p0_.slug AS slug_4,
  p0_.description AS description_5,
  p0_.lft AS lft_6,
  p0_.lvl AS lvl_7,
  p0_.rgt AS rgt_8,
  p0_.published AS published_9,
  p0_.sort_index AS sort_index_10
FROM
  product_category p0_
WHERE
  p0_.rgt < 932
  AND p0_.lft > 1
  AND p0_.tree_root = ?
ORDER BY
  p0_.tree_root ASC,
  p0_.lft ASC

SELECT p0_.id AS id_0, p0_.migration_id AS migration_id_1, p0_.softone_id AS softone_id_2, p0_.name AS name_3, p0_.slug AS slug_4, p0_.description AS description_5, p0_.lft AS lft_6, p0_.lvl AS lvl_7, p0_.rgt AS rgt_8, p0_.published AS published_9, p0_.sort_index AS sort_index_10 FROM product_category p0_ WHERE p0_.rgt < 932 AND p0_.lft > 1 AND p0_.tree_root = 1 ORDER BY p0_.tree_root ASC, p0_.lft ASC;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.slug = 'video_patch_panels' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.url AS url_4,
  t0.file_id AS file_id_5
FROM
  product_reference t0
  INNER JOIN products_references ON t0.id = products_references.reference_id
WHERE
  products_references.product_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.url AS url_4, t0.file_id AS file_id_5 FROM product_reference t0 INNER JOIN products_references ON t0.id = products_references.reference_id WHERE products_references.product_id = 149;

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.summary AS summary_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.keywords AS keywords_9,
  t0.general_comments AS general_comments_10,
  t0.published AS published_11,
  t0.featured AS featured_12,
  t0.sku AS sku_13,
  t0.mfr_code AS mfr_code_14,
  t0.blk_code AS blk_code_15,
  t0.ean_code AS ean_code_16,
  t0.supplier_code AS supplier_code_17,
  t0.volumetric_weight AS volumetric_weight_18,
  t0.views AS views_19,
  t0.sales AS sales_20,
  t0.created_at AS created_at_21,
  t0.supplier_url AS supplier_url_22,
  t0.in_the_box_text AS in_the_box_text_23,
  t0.online_discount_percentage AS online_discount_percentage_24,
  t0.availability AS availability_25,
  t0.available_at AS available_at_26,
  t0.offer AS offer_27,
  t0.cash_back AS cash_back_28,
  t0.ask_for_price AS ask_for_price_29,
  t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30,
  t0.warehouse_stock_quantity AS warehouse_stock_quantity_31,
  t0.warehouse_stock_reserved AS warehouse_stock_reserved_32,
  t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33,
  t0.warehouse_stock_immutable AS warehouse_stock_immutable_34,
  t0.price_gross_amount AS price_gross_amount_35,
  t0.price_gross_currency AS price_gross_currency_36,
  t0.price_with_discount_amount AS price_with_discount_amount_37,
  t0.price_with_discount_currency AS price_with_discount_currency_38,
  t0.type_id AS type_id_39,
  t0.main_image_id AS main_image_id_40,
  t0.manufacturer_id AS manufacturer_id_41,
  t0.variant_group_id AS variant_group_id_42,
  t0.discr,
  t0.price_url AS price_url_43,
  t0.price_comments AS price_comments_44,
  t0.supplier_discount AS supplier_discount_45,
  t0.special_discount AS special_discount_46,
  t0.customs_charges_percentage AS customs_charges_percentage_47,
  t0.markup_percentage AS markup_percentage_48,
  t0.product_dimensions AS product_dimensions_49,
  t0.net_weight AS net_weight_50,
  t0.warranty AS warranty_51,
  t0.accessories AS accessories_52,
  t0.original_price_amount AS original_price_amount_53,
  t0.original_price_currency AS original_price_currency_54,
  t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55,
  t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56,
  t0.package_length_mm AS package_length_mm_57,
  t0.package_width_mm AS package_width_mm_58,
  t0.package_height_mm AS package_height_mm_59,
  t0.package_details AS package_details_60,
  t0.package_dimension_unit AS package_dimension_unit_61,
  t0.package_grams AS package_grams_62,
  t0.package_weight_details AS package_weight_details_63,
  t0.package_weight_unit AS package_weight_unit_64,
  t0.kit_discount_percentage AS kit_discount_percentage_65
FROM
  products t0
WHERE
  t0.slug = ?
  AND t0.discr IN ('product', 'product_kit')
LIMIT
  1

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.slug = 'Musa 2x32 Midi HDTV' AND t0.discr IN ('product', 'product_kit') LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text_value AS text_value_2,
  t0.extra_info AS extra_info_3,
  t0.quantity AS quantity_4,
  t0.product_id AS product_id_5,
  t0.attribute_id AS attribute_id_6,
  t0.attribute_value_id AS attribute_value_id_7
FROM
  product_attribute_value t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.text_value AS text_value_2, t0.extra_info AS extra_info_3, t0.quantity AS quantity_4, t0.product_id AS product_id_5, t0.attribute_id AS attribute_id_6, t0.attribute_value_id AS attribute_value_id_7 FROM product_attribute_value t0 WHERE t0.product_id = 149;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.name AS name_3,
  t0.type AS type_4,
  t0.website AS website_5,
  t0.page_name AS page_name_6,
  t0.slug AS slug_7,
  t0.url AS url_8,
  t0.internal_url_data AS internal_url_data_9,
  t0.description AS description_10,
  t0.lft AS lft_11,
  t0.lvl AS lvl_12,
  t0.rgt AS rgt_13,
  t0.published AS published_14,
  t0.sort_index AS sort_index_15,
  t0.tree_root AS tree_root_16,
  t0.parent_id AS parent_id_17
FROM
  menu t0
WHERE
  t0.lvl = ?
  AND t0.website = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.name AS name_3, t0.type AS type_4, t0.website AS website_5, t0.page_name AS page_name_6, t0.slug AS slug_7, t0.url AS url_8, t0.internal_url_data AS internal_url_data_9, t0.description AS description_10, t0.lft AS lft_11, t0.lvl AS lvl_12, t0.rgt AS rgt_13, t0.published AS published_14, t0.sort_index AS sort_index_15, t0.tree_root AS tree_root_16, t0.parent_id AS parent_id_17 FROM menu t0 WHERE t0.lvl = 0 AND t0.website = 'blk.gr' ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.migration_id AS migration_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.description AS description_6,
  t0.lft AS lft_7,
  t0.lvl AS lvl_8,
  t0.rgt AS rgt_9,
  t0.published AS published_10,
  t0.sort_index AS sort_index_11,
  t0.tree_root AS tree_root_12,
  t0.parent_id AS parent_id_13,
  t0.banner_id AS banner_id_14
FROM
  product_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.migration_id AS migration_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description AS description_6, t0.lft AS lft_7, t0.lvl AS lvl_8, t0.rgt AS rgt_9, t0.published AS published_10, t0.sort_index AS sort_index_11, t0.tree_root AS tree_root_12, t0.parent_id AS parent_id_13, t0.banner_id AS banner_id_14 FROM product_category t0 WHERE t0.id = 50;

UPDATE
  products
SET
  views = ?
WHERE
  id = ?

UPDATE products SET views = 2 WHERE id = 149;

SELECT
  a0_.content AS content_0,
  a0_.field AS field_1
FROM
  attribute_translations a0_
WHERE
  a0_.foreign_key = ?
  AND a0_.locale = ?
  AND a0_.object_class = ?

SELECT a0_.content AS content_0, a0_.field AS field_1 FROM attribute_translations a0_ WHERE a0_.foreign_key = '28' AND a0_.locale = 'el' AND a0_.object_class = 'App\\Entity\\Product\\Attribute\\Attribute';

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.summary AS summary_6,
  t0.description AS description_7,
  t0.status AS status_8,
  t0.keywords AS keywords_9,
  t0.general_comments AS general_comments_10,
  t0.published AS published_11,
  t0.featured AS featured_12,
  t0.sku AS sku_13,
  t0.mfr_code AS mfr_code_14,
  t0.blk_code AS blk_code_15,
  t0.ean_code AS ean_code_16,
  t0.supplier_code AS supplier_code_17,
  t0.volumetric_weight AS volumetric_weight_18,
  t0.views AS views_19,
  t0.sales AS sales_20,
  t0.created_at AS created_at_21,
  t0.supplier_url AS supplier_url_22,
  t0.in_the_box_text AS in_the_box_text_23,
  t0.online_discount_percentage AS online_discount_percentage_24,
  t0.availability AS availability_25,
  t0.available_at AS available_at_26,
  t0.offer AS offer_27,
  t0.cash_back AS cash_back_28,
  t0.ask_for_price AS ask_for_price_29,
  t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30,
  t0.warehouse_stock_quantity AS warehouse_stock_quantity_31,
  t0.warehouse_stock_reserved AS warehouse_stock_reserved_32,
  t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33,
  t0.warehouse_stock_immutable AS warehouse_stock_immutable_34,
  t0.price_gross_amount AS price_gross_amount_35,
  t0.price_gross_currency AS price_gross_currency_36,
  t0.price_with_discount_amount AS price_with_discount_amount_37,
  t0.price_with_discount_currency AS price_with_discount_currency_38,
  t0.type_id AS type_id_39,
  t0.main_image_id AS main_image_id_40,
  t0.manufacturer_id AS manufacturer_id_41,
  t0.variant_group_id AS variant_group_id_42,
  t0.discr,
  t0.price_url AS price_url_43,
  t0.price_comments AS price_comments_44,
  t0.supplier_discount AS supplier_discount_45,
  t0.special_discount AS special_discount_46,
  t0.customs_charges_percentage AS customs_charges_percentage_47,
  t0.markup_percentage AS markup_percentage_48,
  t0.product_dimensions AS product_dimensions_49,
  t0.net_weight AS net_weight_50,
  t0.warranty AS warranty_51,
  t0.accessories AS accessories_52,
  t0.original_price_amount AS original_price_amount_53,
  t0.original_price_currency AS original_price_currency_54,
  t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55,
  t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56,
  t0.package_length_mm AS package_length_mm_57,
  t0.package_width_mm AS package_width_mm_58,
  t0.package_height_mm AS package_height_mm_59,
  t0.package_details AS package_details_60,
  t0.package_dimension_unit AS package_dimension_unit_61,
  t0.package_grams AS package_grams_62,
  t0.package_weight_details AS package_weight_details_63,
  t0.package_weight_unit AS package_weight_unit_64,
  t0.kit_discount_percentage AS kit_discount_percentage_65
FROM
  products t0
WHERE
  t0.id = ?
  AND t0.discr IN ('product', 'product_kit')

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.summary AS summary_6, t0.description AS description_7, t0.status AS status_8, t0.keywords AS keywords_9, t0.general_comments AS general_comments_10, t0.published AS published_11, t0.featured AS featured_12, t0.sku AS sku_13, t0.mfr_code AS mfr_code_14, t0.blk_code AS blk_code_15, t0.ean_code AS ean_code_16, t0.supplier_code AS supplier_code_17, t0.volumetric_weight AS volumetric_weight_18, t0.views AS views_19, t0.sales AS sales_20, t0.created_at AS created_at_21, t0.supplier_url AS supplier_url_22, t0.in_the_box_text AS in_the_box_text_23, t0.online_discount_percentage AS online_discount_percentage_24, t0.availability AS availability_25, t0.available_at AS available_at_26, t0.offer AS offer_27, t0.cash_back AS cash_back_28, t0.ask_for_price AS ask_for_price_29, t0.warehouse_stock_warehouse AS warehouse_stock_warehouse_30, t0.warehouse_stock_quantity AS warehouse_stock_quantity_31, t0.warehouse_stock_reserved AS warehouse_stock_reserved_32, t0.warehouse_stock_target_stock AS warehouse_stock_target_stock_33, t0.warehouse_stock_immutable AS warehouse_stock_immutable_34, t0.price_gross_amount AS price_gross_amount_35, t0.price_gross_currency AS price_gross_currency_36, t0.price_with_discount_amount AS price_with_discount_amount_37, t0.price_with_discount_currency AS price_with_discount_currency_38, t0.type_id AS type_id_39, t0.main_image_id AS main_image_id_40, t0.manufacturer_id AS manufacturer_id_41, t0.variant_group_id AS variant_group_id_42, t0.discr, t0.price_url AS price_url_43, t0.price_comments AS price_comments_44, t0.supplier_discount AS supplier_discount_45, t0.special_discount AS special_discount_46, t0.customs_charges_percentage AS customs_charges_percentage_47, t0.markup_percentage AS markup_percentage_48, t0.product_dimensions AS product_dimensions_49, t0.net_weight AS net_weight_50, t0.warranty AS warranty_51, t0.accessories AS accessories_52, t0.original_price_amount AS original_price_amount_53, t0.original_price_currency AS original_price_currency_54, t0.supplier_shipping_value_amount AS supplier_shipping_value_amount_55, t0.supplier_shipping_value_currency AS supplier_shipping_value_currency_56, t0.package_length_mm AS package_length_mm_57, t0.package_width_mm AS package_width_mm_58, t0.package_height_mm AS package_height_mm_59, t0.package_details AS package_details_60, t0.package_dimension_unit AS package_dimension_unit_61, t0.package_grams AS package_grams_62, t0.package_weight_details AS package_weight_details_63, t0.package_weight_unit AS package_weight_unit_64, t0.kit_discount_percentage AS kit_discount_percentage_65 FROM products t0 WHERE t0.id = 11821 AND t0.discr IN ('product', 'product_kit');

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.softone_id AS softone_id_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.url AS url_6,
  t0.email AS email_7,
  t0.published AS published_8,
  t0.official_dealer AS official_dealer_9,
  t0.european_support AS european_support_10,
  t0.discount_percent AS discount_percent_11,
  t0.extra_discount AS extra_discount_12,
  t0.logo_id AS logo_id_13
FROM
  product_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.softone_id AS softone_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.url AS url_6, t0.email AS email_7, t0.published AS published_8, t0.official_dealer AS official_dealer_9, t0.european_support AS european_support_10, t0.discount_percent AS discount_percent_11, t0.extra_discount AS extra_discount_12, t0.logo_id AS logo_id_13 FROM product_manufacturer t0 WHERE t0.id = 203;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.name AS name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.uploaded_at AS uploaded_at_6,
  t0.discr
FROM
  app_file t0
WHERE
  t0.id = ?
  AND t0.discr IN ('product_image')

SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 WHERE t0.id = 19095 AND t0.discr IN ('product_image');

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.name AS name_3,
  t0.mime_type AS mime_type_4,
  t0.size AS size_5,
  t0.uploaded_at AS uploaded_at_6,
  t0.discr
FROM
  app_file t0
  INNER JOIN product_images ON t0.id = product_images.image_id
WHERE
  product_images.product_id = ?
  AND t0.discr IN ('product_image')

SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5, t0.uploaded_at AS uploaded_at_6, t0.discr FROM app_file t0 INNER JOIN product_images ON t0.id = product_images.image_id WHERE product_images.product_id = 149 AND t0.discr IN ('product_image');

SELECT
  t0.id AS id_1,
  t0.custom_id AS custom_id_2,
  t0.name AS name_3,
  t0.comments AS comments_4,
  t0.has_quantity AS has_quantity_5,
  t0.sort_index AS sort_index_6,
  t0.filter AS filter_7,
  t0.filter_type AS filter_type_8,
  t0.published AS published_9,
  t0.attribute_type AS attribute_type_10,
  t0.attribute_group_id AS attribute_group_id_11
FROM
  attribute t0
WHERE
  t0.id = ?