Symfony Profiler

SELECT
  GROUP_CONCAT(f0_.product_id) AS sclr_0,
  f1_.value AS value_1,
  f1_.id AS id_2,
  f1_.code AS code_3,
  f2_.feature_id AS feature_id_4,
  f2_.value_id AS value_id_5,
  f2_.weight AS weight_6,
  f2_.img AS img_7,
  f2_.url AS url_8,
  f2_.description AS description_9,
  f2_.color AS color_10,
  k3_.value_id AS value_id_11,
  k3_.feature_id AS feature_id_12,
  k3_.ln_id AS ln_id_13,
  k3_.value AS value_14,
  k3_.url AS url_15,
  k3_.description AS description_16,
  f1_.id AS id_17,
  f1_.feature_id AS feature_id_18,
  f1_.feature_id AS feature_id_19,
  k3_.value_id AS value_id_20,
  k3_.feature_id AS feature_id_21
FROM
  Feature_Values_string f1_
  INNER JOIN Feature_Value_Settings f2_ ON f1_.id = f2_.value_id
  AND f1_.feature_id = f2_.feature_id
  LEFT JOIN kk_features_values_ln k3_ ON f2_.value_id = k3_.value_id
  AND f2_.feature_id = k3_.feature_id
  INNER JOIN Feature_Product_Values f0_ ON (
    f1_.id = f0_.value_id
    AND f1_.feature_id = f0_.feature_id
  )
WHERE
  f1_.feature_id = ?
  AND f1_.value <> ''
  AND f0_.product_id IN (?)
GROUP BY
  f1_.id
ORDER BY
  f2_.weight ASC

SELECT GROUP_CONCAT(f0_.product_id) AS sclr_0, f1_.value AS value_1, f1_.id AS id_2, f1_.code AS code_3, f2_.feature_id AS feature_id_4, f2_.value_id AS value_id_5, f2_.weight AS weight_6, f2_.img AS img_7, f2_.url AS url_8, f2_.description AS description_9, f2_.color AS color_10, k3_.value_id AS value_id_11, k3_.feature_id AS feature_id_12, k3_.ln_id AS ln_id_13, k3_.value AS value_14, k3_.url AS url_15, k3_.description AS description_16, f1_.id AS id_17, f1_.feature_id AS feature_id_18, f1_.feature_id AS feature_id_19, k3_.value_id AS value_id_20, k3_.feature_id AS feature_id_21 FROM Feature_Values_string f1_ INNER JOIN Feature_Value_Settings f2_ ON f1_.id = f2_.value_id AND f1_.feature_id = f2_.feature_id LEFT JOIN kk_features_values_ln k3_ ON f2_.value_id = k3_.value_id AND f2_.feature_id = k3_.feature_id INNER JOIN Feature_Product_Values f0_ ON (f1_.id = f0_.value_id AND f1_.feature_id = f0_.feature_id) WHERE f1_.feature_id = 1 AND f1_.value <> '' AND f0_.product_id IN (207443) GROUP BY f1_.id ORDER BY f2_.weight ASC;

SELECT
  TABLE_NAME
FROM
  information_schema.TABLES
WHERE
  TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY
  TABLE_NAME

SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'kalin'
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME;

SELECT
  c.COLUMN_NAME AS field,
  c.COLUMN_TYPE AS TYPE,
  c.IS_NULLABLE AS `null`,
  c.COLUMN_KEY AS `key`,
  c.COLUMN_DEFAULT AS `default`,
  c.EXTRA,
  c.COLUMN_COMMENT AS COMMENT,
  c.CHARACTER_SET_NAME AS characterset,
  c.COLLATION_NAME AS COLLATION
FROM
  information_schema.COLUMNS c
  INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME
WHERE
  c.TABLE_SCHEMA = ?
  AND t.TABLE_SCHEMA = ?
  AND t.TABLE_TYPE = 'BASE TABLE'
  AND t.TABLE_NAME = ?
ORDER BY
  ORDINAL_POSITION

SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS TYPE,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS COMMENT,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS COLLATION
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = 'kalin' AND t.TABLE_SCHEMA = 'kalin' AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION;

SELECT
  DISTINCT k.CONSTRAINT_NAME,
  k.COLUMN_NAME,
  k.REFERENCED_TABLE_NAME,
  k.REFERENCED_COLUMN_NAME,
  k.ORDINAL_POSITION
  /*!50116,
              c.UPDATE_RULE,
              c.DELETE_RULE */
FROM
  information_schema.key_column_usage k
  /*!50116
  INNER JOIN information_schema.referential_constraints c
  ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
  AND c.TABLE_NAME = k.TABLE_NAME */
WHERE
  k.TABLE_SCHEMA = ?
  AND k.TABLE_NAME = ?
  AND k.REFERENCED_COLUMN_NAME IS NOT NULL
  /*!50116 AND c.CONSTRAINT_SCHEMA = 'kalin' */
ORDER BY
  k.ORDINAL_POSITION

SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = 'kalin' AND k.TABLE_NAME = 'doctrine_migration_versions' AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'kalin' */ ORDER BY k.ORDINAL_POSITION;

SELECT
  DISTINCT f0_.value_id AS value_id_0,
  f1_.feature_id AS feature_id_1,
  f1_.feature_name AS feature_name_2,
  f1_.coment AS coment_3,
  f1_.code AS code_4,
  f1_.in_short_list AS in_short_list_5,
  f1_.in_full_list AS in_full_list_6,
  f1_.in_individual_selection AS in_individual_selection_7,
  f1_.weight AS weight_8,
  f1_.img AS img_9,
  f1_.type AS type_10,
  f1_.format AS format_11,
  f1_.multivalues AS multivalues_12,
  f1_.use_as AS use_as_13,
  k2_.id AS id_14,
  k2_.ln_id AS ln_id_15,
  k2_.feature_name AS feature_name_16,
  k2_.coment AS coment_17,
  k2_.format AS format_18,
  f3_.id AS id_19,
  f3_.name AS name_20,
  f3_.weight AS weight_21,
  f3_.img AS img_22,
  f3_.description AS description_23,
  f3_.code AS code_24,
  k4_.fs_id AS fs_id_25,
  k4_.ln_id AS ln_id_26,
  k4_.name AS name_27,
  k4_.description AS description_28,
  f0_.product_id AS product_id_29,
  f0_.feature_id AS feature_id_30,
  f1_.feature_section_id AS feature_section_id_31,
  k2_.feature_id AS feature_id_32,
  k4_.id AS id_33
FROM
  Feature_Product_Values f0_
  INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id
  LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id
  INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id
  LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id
WHERE
  f0_.product_id IN (?)
  AND f1_.in_full_list = ?
ORDER BY
  f3_.weight ASC,
  f1_.weight ASC

SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (207443) AND f1_.in_full_list = 1 ORDER BY f3_.weight ASC, f1_.weight ASC;

SELECT
  DISTINCT f0_.value_id AS value_id_0,
  f1_.feature_id AS feature_id_1,
  f1_.feature_name AS feature_name_2,
  f1_.coment AS coment_3,
  f1_.code AS code_4,
  f1_.in_short_list AS in_short_list_5,
  f1_.in_full_list AS in_full_list_6,
  f1_.in_individual_selection AS in_individual_selection_7,
  f1_.weight AS weight_8,
  f1_.img AS img_9,
  f1_.type AS type_10,
  f1_.format AS format_11,
  f1_.multivalues AS multivalues_12,
  f1_.use_as AS use_as_13,
  k2_.id AS id_14,
  k2_.ln_id AS ln_id_15,
  k2_.feature_name AS feature_name_16,
  k2_.coment AS coment_17,
  k2_.format AS format_18,
  f3_.id AS id_19,
  f3_.name AS name_20,
  f3_.weight AS weight_21,
  f3_.img AS img_22,
  f3_.description AS description_23,
  f3_.code AS code_24,
  k4_.fs_id AS fs_id_25,
  k4_.ln_id AS ln_id_26,
  k4_.name AS name_27,
  k4_.description AS description_28,
  f0_.product_id AS product_id_29,
  f0_.feature_id AS feature_id_30,
  f1_.feature_section_id AS feature_section_id_31,
  k2_.feature_id AS feature_id_32,
  k4_.id AS id_33
FROM
  Feature_Product_Values f0_
  INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id
  LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id
  INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id
  LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id
WHERE
  f0_.product_id IN (?)
  AND f1_.use_as = ?
ORDER BY
  f3_.weight ASC,
  f1_.weight ASC

SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (207443) AND f1_.use_as = 'unit' ORDER BY f3_.weight ASC, f1_.weight ASC;

SELECT
  DISTINCT f0_.value_id AS value_id_0,
  f1_.feature_id AS feature_id_1,
  f1_.feature_name AS feature_name_2,
  f1_.coment AS coment_3,
  f1_.code AS code_4,
  f1_.in_short_list AS in_short_list_5,
  f1_.in_full_list AS in_full_list_6,
  f1_.in_individual_selection AS in_individual_selection_7,
  f1_.weight AS weight_8,
  f1_.img AS img_9,
  f1_.type AS type_10,
  f1_.format AS format_11,
  f1_.multivalues AS multivalues_12,
  f1_.use_as AS use_as_13,
  k2_.id AS id_14,
  k2_.ln_id AS ln_id_15,
  k2_.feature_name AS feature_name_16,
  k2_.coment AS coment_17,
  k2_.format AS format_18,
  f3_.id AS id_19,
  f3_.name AS name_20,
  f3_.weight AS weight_21,
  f3_.img AS img_22,
  f3_.description AS description_23,
  f3_.code AS code_24,
  k4_.fs_id AS fs_id_25,
  k4_.ln_id AS ln_id_26,
  k4_.name AS name_27,
  k4_.description AS description_28,
  f0_.product_id AS product_id_29,
  f0_.feature_id AS feature_id_30,
  f1_.feature_section_id AS feature_section_id_31,
  k2_.feature_id AS feature_id_32,
  k4_.id AS id_33
FROM
  Feature_Product_Values f0_
  INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id
  LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id
  INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id
  LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id
WHERE
  f0_.product_id IN (?)
  AND f1_.in_short_list = ?
ORDER BY
  f3_.weight ASC,
  f1_.weight ASC

SELECT DISTINCT f0_.value_id AS value_id_0, f1_.feature_id AS feature_id_1, f1_.feature_name AS feature_name_2, f1_.coment AS coment_3, f1_.code AS code_4, f1_.in_short_list AS in_short_list_5, f1_.in_full_list AS in_full_list_6, f1_.in_individual_selection AS in_individual_selection_7, f1_.weight AS weight_8, f1_.img AS img_9, f1_.type AS type_10, f1_.format AS format_11, f1_.multivalues AS multivalues_12, f1_.use_as AS use_as_13, k2_.id AS id_14, k2_.ln_id AS ln_id_15, k2_.feature_name AS feature_name_16, k2_.coment AS coment_17, k2_.format AS format_18, f3_.id AS id_19, f3_.name AS name_20, f3_.weight AS weight_21, f3_.img AS img_22, f3_.description AS description_23, f3_.code AS code_24, k4_.fs_id AS fs_id_25, k4_.ln_id AS ln_id_26, k4_.name AS name_27, k4_.description AS description_28, f0_.product_id AS product_id_29, f0_.feature_id AS feature_id_30, f1_.feature_section_id AS feature_section_id_31, k2_.feature_id AS feature_id_32, k4_.id AS id_33 FROM Feature_Product_Values f0_ INNER JOIN Feature f1_ ON f0_.feature_id = f1_.feature_id LEFT JOIN kk_features_ln k2_ ON f1_.feature_id = k2_.feature_id INNER JOIN Feature_Section f3_ ON f1_.feature_section_id = f3_.id LEFT JOIN kk_features_sections_ln k4_ ON f3_.id = k4_.id WHERE f0_.product_id IN (207443) AND f1_.in_short_list = 1 ORDER BY f3_.weight ASC, f1_.weight ASC;

SELECT
  p0_.product_id AS product_id_0,
  p0_.product AS product_1,
  p0_.pn AS pn_2,
  p0_.model AS model_3,
  p0_.description AS description_4,
  p0_.detail_description AS detail_description_5,
  p0_.deleted AS deleted_6,
  p0_.pic AS pic_7,
  p0_.warranty AS warranty_8,
  p0_.cost_min AS cost_min_9,
  p0_.create_time AS create_time_10,
  s1_.product_id AS product_id_11,
  s1_.group_id AS group_id_12,
  s1_.product_type AS product_type_13,
  s1_.is_show_in_catalog AS is_show_in_catalog_14,
  s1_.presence AS presence_15,
  s1_.presence_str AS presence_str_16,
  s1_.rating AS rating_17,
  p2_.product_id AS product_id_18,
  p2_.url_code AS url_code_19,
  p2_.rating AS rating_20,
  p2_.seo_title AS seo_title_21,
  p2_.seo_description AS seo_description_22,
  p2_.seo_keyword AS seo_keyword_23,
  p3_.id AS id_24,
  p3_.default AS default_25,
  p3_.change_data AS change_data_26,
  p3_.show_img AS show_img_27,
  p3_.show_price AS show_price_28,
  p3_.show_presence AS show_presence_29,
  p3_.features_sharing AS features_sharing_30,
  p3_.manual_sharing AS manual_sharing_31,
  p3_.features AS features_32,
  p0_.category_id AS category_id_33,
  s1_.category_id AS category_id_34,
  s1_.catalog_product_id AS catalog_product_id_35,
  s1_.product_id AS product_id_36,
  p2_.product_id AS product_id_37,
  p3_.product_id AS product_id_38
FROM
  Products p0_
  INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id
  INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id
  LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id
WHERE
  p0_.deleted = 0
  AND p2_.url_code <> ''
  AND p2_.url_code = ?
LIMIT
  1

SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.model AS model_3, p0_.description AS description_4, p0_.detail_description AS detail_description_5, p0_.deleted AS deleted_6, p0_.pic AS pic_7, p0_.warranty AS warranty_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p2_.url_code = 'inversor-solar-hbrido-3-6kw-monofsico-3-aos-de-garanta-ip65' LIMIT 1;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  p0_.product_id AS product_id_0,
  p0_.product AS product_1,
  p0_.pn AS pn_2,
  p0_.model AS model_3,
  p0_.description AS description_4,
  p0_.detail_description AS detail_description_5,
  p0_.deleted AS deleted_6,
  p0_.pic AS pic_7,
  p0_.warranty AS warranty_8,
  p0_.cost_min AS cost_min_9,
  p0_.create_time AS create_time_10,
  s1_.product_id AS product_id_11,
  s1_.group_id AS group_id_12,
  s1_.product_type AS product_type_13,
  s1_.is_show_in_catalog AS is_show_in_catalog_14,
  s1_.presence AS presence_15,
  s1_.presence_str AS presence_str_16,
  s1_.rating AS rating_17,
  p2_.product_id AS product_id_18,
  p2_.url_code AS url_code_19,
  p2_.rating AS rating_20,
  p2_.seo_title AS seo_title_21,
  p2_.seo_description AS seo_description_22,
  p2_.seo_keyword AS seo_keyword_23,
  p3_.id AS id_24,
  p3_.default AS default_25,
  p3_.change_data AS change_data_26,
  p3_.show_img AS show_img_27,
  p3_.show_price AS show_price_28,
  p3_.show_presence AS show_presence_29,
  p3_.features_sharing AS features_sharing_30,
  p3_.manual_sharing AS manual_sharing_31,
  p3_.features AS features_32,
  p0_.category_id AS category_id_33,
  s1_.category_id AS category_id_34,
  s1_.catalog_product_id AS catalog_product_id_35,
  s1_.product_id AS product_id_36,
  p2_.product_id AS product_id_37,
  p3_.product_id AS product_id_38
FROM
  Products p0_
  INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id
  INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id
  LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id
WHERE
  p0_.deleted = 0
  AND p2_.url_code <> ''
  AND (
    p0_.product_id IN (
      SELECT
        DISTINCT s4_.catalog_product_id AS sclr_39
      FROM
        sf_product_index s4_
      WHERE
        s4_.catalog_product_id IN (?)
        OR s4_.product_id IN (?)
    )
  )
ORDER BY
  FIELD(p0_.product_id, ?) ASC
LIMIT
  10

SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.model AS model_3, p0_.description AS description_4, p0_.detail_description AS detail_description_5, p0_.deleted AS deleted_6, p0_.pic AS pic_7, p0_.warranty AS warranty_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND (p0_.product_id IN (SELECT DISTINCT s4_.catalog_product_id AS sclr_39 FROM sf_product_index s4_ WHERE s4_.catalog_product_id IN ('207443') OR s4_.product_id IN ('207443'))) ORDER BY FIELD(p0_.product_id, '207443') ASC LIMIT 10;

SELECT
  p0_.product_id AS product_id_0,
  p0_.product AS product_1,
  p0_.pn AS pn_2,
  p0_.model AS model_3,
  p0_.description AS description_4,
  p0_.detail_description AS detail_description_5,
  p0_.deleted AS deleted_6,
  p0_.pic AS pic_7,
  p0_.warranty AS warranty_8,
  p0_.cost_min AS cost_min_9,
  p0_.create_time AS create_time_10,
  s1_.product_id AS product_id_11,
  s1_.group_id AS group_id_12,
  s1_.product_type AS product_type_13,
  s1_.is_show_in_catalog AS is_show_in_catalog_14,
  s1_.presence AS presence_15,
  s1_.presence_str AS presence_str_16,
  s1_.rating AS rating_17,
  p2_.product_id AS product_id_18,
  p2_.url_code AS url_code_19,
  p2_.rating AS rating_20,
  p2_.seo_title AS seo_title_21,
  p2_.seo_description AS seo_description_22,
  p2_.seo_keyword AS seo_keyword_23,
  p3_.id AS id_24,
  p3_.default AS default_25,
  p3_.change_data AS change_data_26,
  p3_.show_img AS show_img_27,
  p3_.show_price AS show_price_28,
  p3_.show_presence AS show_presence_29,
  p3_.features_sharing AS features_sharing_30,
  p3_.manual_sharing AS manual_sharing_31,
  p3_.features AS features_32,
  p0_.category_id AS category_id_33,
  s1_.category_id AS category_id_34,
  s1_.catalog_product_id AS catalog_product_id_35,
  s1_.product_id AS product_id_36,
  p2_.product_id AS product_id_37,
  p3_.product_id AS product_id_38
FROM
  Products p0_
  INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id
  INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id
  LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id
WHERE
  p0_.deleted = 0
  AND p2_.url_code <> ''
  AND p0_.product_id = ?
LIMIT
  1

SELECT p0_.product_id AS product_id_0, p0_.product AS product_1, p0_.pn AS pn_2, p0_.model AS model_3, p0_.description AS description_4, p0_.detail_description AS detail_description_5, p0_.deleted AS deleted_6, p0_.pic AS pic_7, p0_.warranty AS warranty_8, p0_.cost_min AS cost_min_9, p0_.create_time AS create_time_10, s1_.product_id AS product_id_11, s1_.group_id AS group_id_12, s1_.product_type AS product_type_13, s1_.is_show_in_catalog AS is_show_in_catalog_14, s1_.presence AS presence_15, s1_.presence_str AS presence_str_16, s1_.rating AS rating_17, p2_.product_id AS product_id_18, p2_.url_code AS url_code_19, p2_.rating AS rating_20, p2_.seo_title AS seo_title_21, p2_.seo_description AS seo_description_22, p2_.seo_keyword AS seo_keyword_23, p3_.id AS id_24, p3_.default AS default_25, p3_.change_data AS change_data_26, p3_.show_img AS show_img_27, p3_.show_price AS show_price_28, p3_.show_presence AS show_presence_29, p3_.features_sharing AS features_sharing_30, p3_.manual_sharing AS manual_sharing_31, p3_.features AS features_32, p0_.category_id AS category_id_33, s1_.category_id AS category_id_34, s1_.catalog_product_id AS catalog_product_id_35, s1_.product_id AS product_id_36, p2_.product_id AS product_id_37, p3_.product_id AS product_id_38 FROM Products p0_ INNER JOIN sf_product_index s1_ ON p0_.product_id = s1_.product_id INNER JOIN Products_Data p2_ ON p0_.product_id = p2_.product_id LEFT JOIN products_groups p3_ ON p0_.product_id = p3_.product_id WHERE p0_.deleted = 0 AND p2_.url_code <> '' AND p0_.product_id = 207443 LIMIT 1;

SELECT
  s0_.product_id AS sclr_0
FROM
  stocks s0_
  INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id
  AND (s1_.type_discount = ?)
  INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id
  INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id
  AND (
    s3_.presence > 0
    AND s3_.product_type <> ?
  )
WHERE
  s0_.product_id IN (?)
  AND s1_.active = 1
  AND (
    s0_.date_start IS NULL
    OR s0_.date_start <= ?
  )
  AND (
    s0_.date_end IS NULL
    OR s0_.date_end >= ?
  )
GROUP BY
  s0_.product_id
ORDER BY
  IF(s0_.date_end IS NULL, 1, 0) ASC,
  s0_.date_end ASC

SELECT s0_.product_id AS sclr_0 FROM stocks s0_ INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id AND (s1_.type_discount = 'g') INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id AND (s3_.presence > 0 AND s3_.product_type <> 'group') WHERE s0_.product_id IN (207443) AND s1_.active = 1 AND (s0_.date_start IS NULL OR s0_.date_start <= '2026-01-26 05:11:50') AND (s0_.date_end IS NULL OR s0_.date_end >= '2026-01-26 05:11:50') GROUP BY s0_.product_id ORDER BY IF(s0_.date_end IS NULL, 1, 0) ASC, s0_.date_end ASC;

SELECT
  s0_.stock_id AS stock_id_0,
  s0_.date_start AS date_start_1,
  s0_.date_end AS date_end_2,
  s1_.stock_products_id AS stock_products_id_3,
  s1_.discount AS discount_4,
  s1_.type_discount AS type_discount_5,
  s1_.description AS description_6,
  s1_.active AS active_7,
  p2_.product_id AS product_id_8,
  p2_.product AS product_9,
  p2_.pn AS pn_10,
  p2_.model AS model_11,
  p2_.description AS description_12,
  p2_.detail_description AS detail_description_13,
  p2_.deleted AS deleted_14,
  p2_.pic AS pic_15,
  p2_.warranty AS warranty_16,
  p2_.cost_min AS cost_min_17,
  p2_.create_time AS create_time_18,
  s3_.product_id AS product_id_19,
  s3_.group_id AS group_id_20,
  s3_.product_type AS product_type_21,
  s3_.is_show_in_catalog AS is_show_in_catalog_22,
  s3_.presence AS presence_23,
  s3_.presence_str AS presence_str_24,
  s3_.rating AS rating_25,
  s0_.product_id AS product_id_26,
  s1_.product_id AS product_id_27,
  s1_.stock_id AS stock_id_28,
  p2_.category_id AS category_id_29,
  s3_.category_id AS category_id_30,
  s3_.catalog_product_id AS catalog_product_id_31,
  s3_.product_id AS product_id_32
FROM
  stocks s0_
  INNER JOIN stocks_products s1_ ON s0_.stock_id = s1_.stock_id
  AND (s1_.type_discount = ?)
  INNER JOIN Products p2_ ON s1_.product_id = p2_.product_id
  INNER JOIN sf_product_index s3_ ON p2_.product_id = s3_.product_id
  AND (
    s3_.presence > 0
    AND s3_.product_type <> ?
  )
WHERE
  s0_.product_id = ?
  AND s1_.active = 1
  AND (
    s0_.date_start IS NULL
    OR s0_.date_start <= ?
  )
  AND (
    s0_.date_end IS NULL
    OR s0_.date_end >= ?
  )
ORDER BY
  IF(s0_.date_end IS NULL, 1, 0) ASC,
  s0_.date_end ASC
LIMIT
  1