Symfony Profiler

SELECT
  DISTINCT id_0,
  MIN(sclr_207) AS dctrn_minrownum
FROM
  (
    SELECT
      p0_.id AS id_0,
      p0_.name AS name_1,
      p0_.date_entered AS date_entered_2,
      p0_.date_modified AS date_modified_3,
      p0_.description AS description_4,
      p0_.code1c AS code1c_5,
      p0_.barcode AS barcode_6,
      p0_.status AS status_7,
      p0_.price AS price_8,
      p0_.price_income AS price_income_9,
      p0_.mark_up AS mark_up_10,
      p0_.min_mark_up AS min_mark_up_11,
      p0_.packing_type AS packing_type_12,
      p0_.packing_type_count AS packing_type_count_13,
      p0_.discounts AS discounts_14,
      p0_.count_order AS count_order_15,
      p0_.product_to_order AS product_to_order_16,
      p0_.article AS article_17,
      p0_.nds AS nds_18,
      p0_.service AS service_19,
      p0_.transport_service AS transport_service_20,
      p0_.exise AS exise_21,
      p0_.expiration_date AS expiration_date_22,
      p0_.unit_volume AS unit_volume_23,
      p0_.net_weight AS net_weight_24,
      p0_.gross_weight AS gross_weight_25,
      p0_.go_by_weight AS go_by_weight_26,
      p0_.packaging AS packaging_27,
      p0_.old_code AS old_code_28,
      p0_.show AS show_29,
      p0_.balance AS balance_30,
      p0_.deleted AS deleted_31,
      p0_.category_cnt AS category_cnt_32,
      p0_.price_category AS price_category_33,
      p0_.is_salle AS is_salle_34,
      p0_.is_new AS is_new_35,
      p0_.is_top AS is_top_36,
      p0_.old_price AS old_price_37,
      p0_.discount_percent AS discount_percent_38,
      p0_.date_last_price_income AS date_last_price_income_39,
      p0_.video AS video_40,
      p0_.is_video AS is_video_41,
      p0_.is_free_shipping AS is_free_shipping_42,
      p0_.warranty_period AS warranty_period_43,
      p0_.min_balance AS min_balance_44,
      p0_.min_balance_admin AS min_balance_admin_45,
      p0_.main_category_id AS main_category_id_46,
      p0_.discontinued AS discontinued_47,
      p0_.seo_title AS seo_title_48,
      p0_.seo_description AS seo_description_49,
      c1_.id AS id_50,
      c1_.date_entered AS date_entered_51,
      c1_.date_modified AS date_modified_52,
      c1_.created_by AS created_by_53,
      c1_.modified_user_id AS modified_user_id_54,
      c1_.name AS name_55,
      c1_.slug AS slug_56,
      c1_.status AS status_57,
      c1_.description AS description_58,
      c1_.main AS main_59,
      c1_.type AS type_60,
      c1_.product_cnt AS product_cnt_61,
      c1_.site_product_cnt AS site_product_cnt_62,
      c1_.sort AS sort_63,
      c1_.seo_title AS seo_title_64,
      c1_.seo_description AS seo_description_65,
      m2_.id AS id_66,
      m2_.short_name AS short_name_67,
      m2_.name AS name_68,
      m2_.date_entered AS date_entered_69,
      m2_.date_modified AS date_modified_70,
      m2_.created_by AS created_by_71,
      m2_.modified_user_id AS modified_user_id_72,
      m2_.description AS description_73,
      m2_.code1c AS code1c_74,
      p3_.id AS id_75,
      p3_.name AS name_76,
      p3_.date_entered AS date_entered_77,
      p3_.date_modified AS date_modified_78,
      p3_.description AS description_79,
      p3_.code1c AS code1c_80,
      p3_.barcode AS barcode_81,
      p3_.status AS status_82,
      p3_.price AS price_83,
      p3_.price_income AS price_income_84,
      p3_.mark_up AS mark_up_85,
      p3_.min_mark_up AS min_mark_up_86,
      p3_.packing_type AS packing_type_87,
      p3_.packing_type_count AS packing_type_count_88,
      p3_.discounts AS discounts_89,
      p3_.count_order AS count_order_90,
      p3_.product_to_order AS product_to_order_91,
      p3_.article AS article_92,
      p3_.nds AS nds_93,
      p3_.service AS service_94,
      p3_.transport_service AS transport_service_95,
      p3_.exise AS exise_96,
      p3_.expiration_date AS expiration_date_97,
      p3_.unit_volume AS unit_volume_98,
      p3_.net_weight AS net_weight_99,
      p3_.gross_weight AS gross_weight_100,
      p3_.go_by_weight AS go_by_weight_101,
      p3_.packaging AS packaging_102,
      p3_.old_code AS old_code_103,
      p3_.show AS show_104,
      p3_.balance AS balance_105,
      p3_.deleted AS deleted_106,
      p3_.category_cnt AS category_cnt_107,
      p3_.price_category AS price_category_108,
      p3_.is_salle AS is_salle_109,
      p3_.is_new AS is_new_110,
      p3_.is_top AS is_top_111,
      p3_.old_price AS old_price_112,
      p3_.discount_percent AS discount_percent_113,
      p3_.date_last_price_income AS date_last_price_income_114,
      p3_.video AS video_115,
      p3_.is_video AS is_video_116,
      p3_.is_free_shipping AS is_free_shipping_117,
      p3_.warranty_period AS warranty_period_118,
      p3_.min_balance AS min_balance_119,
      p3_.min_balance_admin AS min_balance_admin_120,
      p3_.main_category_id AS main_category_id_121,
      p3_.discontinued AS discontinued_122,
      p3_.seo_title AS seo_title_123,
      p3_.seo_description AS seo_description_124,
      p4_.id AS id_125,
      p4_.name AS name_126,
      p4_.date_entered AS date_entered_127,
      p4_.date_modified AS date_modified_128,
      p4_.description AS description_129,
      p4_.code1c AS code1c_130,
      p4_.barcode AS barcode_131,
      p4_.status AS status_132,
      p4_.price AS price_133,
      p4_.price_income AS price_income_134,
      p4_.mark_up AS mark_up_135,
      p4_.min_mark_up AS min_mark_up_136,
      p4_.packing_type AS packing_type_137,
      p4_.packing_type_count AS packing_type_count_138,
      p4_.discounts AS discounts_139,
      p4_.count_order AS count_order_140,
      p4_.product_to_order AS product_to_order_141,
      p4_.article AS article_142,
      p4_.nds AS nds_143,
      p4_.service AS service_144,
      p4_.transport_service AS transport_service_145,
      p4_.exise AS exise_146,
      p4_.expiration_date AS expiration_date_147,
      p4_.unit_volume AS unit_volume_148,
      p4_.net_weight AS net_weight_149,
      p4_.gross_weight AS gross_weight_150,
      p4_.go_by_weight AS go_by_weight_151,
      p4_.packaging AS packaging_152,
      p4_.old_code AS old_code_153,
      p4_.show AS show_154,
      p4_.balance AS balance_155,
      p4_.deleted AS deleted_156,
      p4_.category_cnt AS category_cnt_157,
      p4_.price_category AS price_category_158,
      p4_.is_salle AS is_salle_159,
      p4_.is_new AS is_new_160,
      p4_.is_top AS is_top_161,
      p4_.old_price AS old_price_162,
      p4_.discount_percent AS discount_percent_163,
      p4_.date_last_price_income AS date_last_price_income_164,
      p4_.video AS video_165,
      p4_.is_video AS is_video_166,
      p4_.is_free_shipping AS is_free_shipping_167,
      p4_.warranty_period AS warranty_period_168,
      p4_.min_balance AS min_balance_169,
      p4_.min_balance_admin AS min_balance_admin_170,
      p4_.main_category_id AS main_category_id_171,
      p4_.discontinued AS discontinued_172,
      p4_.seo_title AS seo_title_173,
      p4_.seo_description AS seo_description_174,
      m5_.id AS id_175,
      m5_.upload_timestamp AS upload_timestamp_176,
      m5_.main AS main_177,
      m5_.file_path AS file_path_178,
      m5_.type AS type_179,
      m5_.name AS name_180,
      m5_.size AS size_181,
      m5_.sort AS sort_182,
      m6_.id AS id_183,
      m6_.upload_timestamp AS upload_timestamp_184,
      m6_.main AS main_185,
      m6_.file_path AS file_path_186,
      m6_.type AS type_187,
      m6_.name AS name_188,
      m6_.size AS size_189,
      m6_.sort AS sort_190,
      m7_.id AS id_191,
      m7_.upload_timestamp AS upload_timestamp_192,
      m7_.main AS main_193,
      m7_.file_path AS file_path_194,
      m7_.type AS type_195,
      m7_.name AS name_196,
      m7_.size AS size_197,
      m7_.sort AS sort_198,
      m8_.id AS id_199,
      m8_.upload_timestamp AS upload_timestamp_200,
      m8_.main AS main_201,
      m8_.file_path AS file_path_202,
      m8_.type AS type_203,
      m8_.name AS name_204,
      m8_.size AS size_205,
      m8_.sort AS sort_206,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.name ASC,
          m9_.sort DESC,
          p0_.discontinued DESC
      ) AS sclr_207
    FROM
      products p0_
      INNER JOIN products_category p10_ ON p0_.id = p10_.products_id
      INNER JOIN category c1_ ON c1_.id = p10_.category_id
      LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id
      LEFT JOIN products p3_ ON p0_.translation_id = p3_.id
      LEFT JOIN products p4_ ON p0_.id = p4_.translation_id
      LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id
      LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id
      LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id
      LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id
      LEFT JOIN media_object m9_ ON p0_.id = m9_.product_id
    WHERE
      p0_.id IN (
        SELECT
          p11_.id
        FROM
          products p11_
          INNER JOIN products_category p13_ ON p11_.id = p13_.products_id
          INNER JOIN category c12_ ON c12_.id = p13_.category_id
        WHERE
          p11_.deleted = ?
          AND p11_.deleted = ?
          AND p11_.deleted = ?
          AND p11_.deleted = ?
          AND c12_.slug = ?
          AND p11_.show = ?
          AND p11_.discontinued = ?
      )
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  30

SELECT DISTINCT id_0, MIN(sclr_207) AS dctrn_minrownum FROM (SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.date_entered AS date_entered_2, p0_.date_modified AS date_modified_3, p0_.description AS description_4, p0_.code1c AS code1c_5, p0_.barcode AS barcode_6, p0_.status AS status_7, p0_.price AS price_8, p0_.price_income AS price_income_9, p0_.mark_up AS mark_up_10, p0_.min_mark_up AS min_mark_up_11, p0_.packing_type AS packing_type_12, p0_.packing_type_count AS packing_type_count_13, p0_.discounts AS discounts_14, p0_.count_order AS count_order_15, p0_.product_to_order AS product_to_order_16, p0_.article AS article_17, p0_.nds AS nds_18, p0_.service AS service_19, p0_.transport_service AS transport_service_20, p0_.exise AS exise_21, p0_.expiration_date AS expiration_date_22, p0_.unit_volume AS unit_volume_23, p0_.net_weight AS net_weight_24, p0_.gross_weight AS gross_weight_25, p0_.go_by_weight AS go_by_weight_26, p0_.packaging AS packaging_27, p0_.old_code AS old_code_28, p0_.show AS show_29, p0_.balance AS balance_30, p0_.deleted AS deleted_31, p0_.category_cnt AS category_cnt_32, p0_.price_category AS price_category_33, p0_.is_salle AS is_salle_34, p0_.is_new AS is_new_35, p0_.is_top AS is_top_36, p0_.old_price AS old_price_37, p0_.discount_percent AS discount_percent_38, p0_.date_last_price_income AS date_last_price_income_39, p0_.video AS video_40, p0_.is_video AS is_video_41, p0_.is_free_shipping AS is_free_shipping_42, p0_.warranty_period AS warranty_period_43, p0_.min_balance AS min_balance_44, p0_.min_balance_admin AS min_balance_admin_45, p0_.main_category_id AS main_category_id_46, p0_.discontinued AS discontinued_47, p0_.seo_title AS seo_title_48, p0_.seo_description AS seo_description_49, c1_.id AS id_50, c1_.date_entered AS date_entered_51, c1_.date_modified AS date_modified_52, c1_.created_by AS created_by_53, c1_.modified_user_id AS modified_user_id_54, c1_.name AS name_55, c1_.slug AS slug_56, c1_.status AS status_57, c1_.description AS description_58, c1_.main AS main_59, c1_.type AS type_60, c1_.product_cnt AS product_cnt_61, c1_.site_product_cnt AS site_product_cnt_62, c1_.sort AS sort_63, c1_.seo_title AS seo_title_64, c1_.seo_description AS seo_description_65, m2_.id AS id_66, m2_.short_name AS short_name_67, m2_.name AS name_68, m2_.date_entered AS date_entered_69, m2_.date_modified AS date_modified_70, m2_.created_by AS created_by_71, m2_.modified_user_id AS modified_user_id_72, m2_.description AS description_73, m2_.code1c AS code1c_74, p3_.id AS id_75, p3_.name AS name_76, p3_.date_entered AS date_entered_77, p3_.date_modified AS date_modified_78, p3_.description AS description_79, p3_.code1c AS code1c_80, p3_.barcode AS barcode_81, p3_.status AS status_82, p3_.price AS price_83, p3_.price_income AS price_income_84, p3_.mark_up AS mark_up_85, p3_.min_mark_up AS min_mark_up_86, p3_.packing_type AS packing_type_87, p3_.packing_type_count AS packing_type_count_88, p3_.discounts AS discounts_89, p3_.count_order AS count_order_90, p3_.product_to_order AS product_to_order_91, p3_.article AS article_92, p3_.nds AS nds_93, p3_.service AS service_94, p3_.transport_service AS transport_service_95, p3_.exise AS exise_96, p3_.expiration_date AS expiration_date_97, p3_.unit_volume AS unit_volume_98, p3_.net_weight AS net_weight_99, p3_.gross_weight AS gross_weight_100, p3_.go_by_weight AS go_by_weight_101, p3_.packaging AS packaging_102, p3_.old_code AS old_code_103, p3_.show AS show_104, p3_.balance AS balance_105, p3_.deleted AS deleted_106, p3_.category_cnt AS category_cnt_107, p3_.price_category AS price_category_108, p3_.is_salle AS is_salle_109, p3_.is_new AS is_new_110, p3_.is_top AS is_top_111, p3_.old_price AS old_price_112, p3_.discount_percent AS discount_percent_113, p3_.date_last_price_income AS date_last_price_income_114, p3_.video AS video_115, p3_.is_video AS is_video_116, p3_.is_free_shipping AS is_free_shipping_117, p3_.warranty_period AS warranty_period_118, p3_.min_balance AS min_balance_119, p3_.min_balance_admin AS min_balance_admin_120, p3_.main_category_id AS main_category_id_121, p3_.discontinued AS discontinued_122, p3_.seo_title AS seo_title_123, p3_.seo_description AS seo_description_124, p4_.id AS id_125, p4_.name AS name_126, p4_.date_entered AS date_entered_127, p4_.date_modified AS date_modified_128, p4_.description AS description_129, p4_.code1c AS code1c_130, p4_.barcode AS barcode_131, p4_.status AS status_132, p4_.price AS price_133, p4_.price_income AS price_income_134, p4_.mark_up AS mark_up_135, p4_.min_mark_up AS min_mark_up_136, p4_.packing_type AS packing_type_137, p4_.packing_type_count AS packing_type_count_138, p4_.discounts AS discounts_139, p4_.count_order AS count_order_140, p4_.product_to_order AS product_to_order_141, p4_.article AS article_142, p4_.nds AS nds_143, p4_.service AS service_144, p4_.transport_service AS transport_service_145, p4_.exise AS exise_146, p4_.expiration_date AS expiration_date_147, p4_.unit_volume AS unit_volume_148, p4_.net_weight AS net_weight_149, p4_.gross_weight AS gross_weight_150, p4_.go_by_weight AS go_by_weight_151, p4_.packaging AS packaging_152, p4_.old_code AS old_code_153, p4_.show AS show_154, p4_.balance AS balance_155, p4_.deleted AS deleted_156, p4_.category_cnt AS category_cnt_157, p4_.price_category AS price_category_158, p4_.is_salle AS is_salle_159, p4_.is_new AS is_new_160, p4_.is_top AS is_top_161, p4_.old_price AS old_price_162, p4_.discount_percent AS discount_percent_163, p4_.date_last_price_income AS date_last_price_income_164, p4_.video AS video_165, p4_.is_video AS is_video_166, p4_.is_free_shipping AS is_free_shipping_167, p4_.warranty_period AS warranty_period_168, p4_.min_balance AS min_balance_169, p4_.min_balance_admin AS min_balance_admin_170, p4_.main_category_id AS main_category_id_171, p4_.discontinued AS discontinued_172, p4_.seo_title AS seo_title_173, p4_.seo_description AS seo_description_174, m5_.id AS id_175, m5_.upload_timestamp AS upload_timestamp_176, m5_.main AS main_177, m5_.file_path AS file_path_178, m5_.type AS type_179, m5_.name AS name_180, m5_.size AS size_181, m5_.sort AS sort_182, m6_.id AS id_183, m6_.upload_timestamp AS upload_timestamp_184, m6_.main AS main_185, m6_.file_path AS file_path_186, m6_.type AS type_187, m6_.name AS name_188, m6_.size AS size_189, m6_.sort AS sort_190, m7_.id AS id_191, m7_.upload_timestamp AS upload_timestamp_192, m7_.main AS main_193, m7_.file_path AS file_path_194, m7_.type AS type_195, m7_.name AS name_196, m7_.size AS size_197, m7_.sort AS sort_198, m8_.id AS id_199, m8_.upload_timestamp AS upload_timestamp_200, m8_.main AS main_201, m8_.file_path AS file_path_202, m8_.type AS type_203, m8_.name AS name_204, m8_.size AS size_205, m8_.sort AS sort_206, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_207 FROM products p0_ INNER JOIN products_category p10_ ON p0_.id = p10_.products_id INNER JOIN category c1_ ON c1_.id = p10_.category_id LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id LEFT JOIN products p3_ ON p0_.translation_id = p3_.id LEFT JOIN products p4_ ON p0_.id = p4_.translation_id LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id LEFT JOIN media_object m9_ ON p0_.id = m9_.product_id WHERE p0_.id IN (SELECT p11_.id FROM products p11_ INNER JOIN products_category p13_ ON p11_.id = p13_.products_id INNER JOIN category c12_ ON c12_.id = p13_.category_id WHERE p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND p11_.deleted = 0 AND c12_.slug = 'novinki' AND p11_.show = 'true' AND p11_.discontinued = 'false')) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 30;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.date_entered AS date_entered_2,
  p0_.date_modified AS date_modified_3,
  p0_.description AS description_4,
  p0_.code1c AS code1c_5,
  p0_.barcode AS barcode_6,
  p0_.status AS status_7,
  p0_.price AS price_8,
  p0_.price_income AS price_income_9,
  p0_.mark_up AS mark_up_10,
  p0_.min_mark_up AS min_mark_up_11,
  p0_.packing_type AS packing_type_12,
  p0_.packing_type_count AS packing_type_count_13,
  p0_.discounts AS discounts_14,
  p0_.count_order AS count_order_15,
  p0_.product_to_order AS product_to_order_16,
  p0_.article AS article_17,
  p0_.nds AS nds_18,
  p0_.service AS service_19,
  p0_.transport_service AS transport_service_20,
  p0_.exise AS exise_21,
  p0_.expiration_date AS expiration_date_22,
  p0_.unit_volume AS unit_volume_23,
  p0_.net_weight AS net_weight_24,
  p0_.gross_weight AS gross_weight_25,
  p0_.go_by_weight AS go_by_weight_26,
  p0_.packaging AS packaging_27,
  p0_.old_code AS old_code_28,
  p0_.show AS show_29,
  p0_.balance AS balance_30,
  p0_.deleted AS deleted_31,
  p0_.category_cnt AS category_cnt_32,
  p0_.price_category AS price_category_33,
  p0_.is_salle AS is_salle_34,
  p0_.is_new AS is_new_35,
  p0_.is_top AS is_top_36,
  p0_.old_price AS old_price_37,
  p0_.discount_percent AS discount_percent_38,
  p0_.date_last_price_income AS date_last_price_income_39,
  p0_.video AS video_40,
  p0_.is_video AS is_video_41,
  p0_.is_free_shipping AS is_free_shipping_42,
  p0_.warranty_period AS warranty_period_43,
  p0_.min_balance AS min_balance_44,
  p0_.min_balance_admin AS min_balance_admin_45,
  p0_.main_category_id AS main_category_id_46,
  p0_.discontinued AS discontinued_47,
  p0_.seo_title AS seo_title_48,
  p0_.seo_description AS seo_description_49,
  c1_.id AS id_50,
  c1_.date_entered AS date_entered_51,
  c1_.date_modified AS date_modified_52,
  c1_.created_by AS created_by_53,
  c1_.modified_user_id AS modified_user_id_54,
  c1_.name AS name_55,
  c1_.slug AS slug_56,
  c1_.status AS status_57,
  c1_.description AS description_58,
  c1_.main AS main_59,
  c1_.type AS type_60,
  c1_.product_cnt AS product_cnt_61,
  c1_.site_product_cnt AS site_product_cnt_62,
  c1_.sort AS sort_63,
  c1_.seo_title AS seo_title_64,
  c1_.seo_description AS seo_description_65,
  m2_.id AS id_66,
  m2_.short_name AS short_name_67,
  m2_.name AS name_68,
  m2_.date_entered AS date_entered_69,
  m2_.date_modified AS date_modified_70,
  m2_.created_by AS created_by_71,
  m2_.modified_user_id AS modified_user_id_72,
  m2_.description AS description_73,
  m2_.code1c AS code1c_74,
  p3_.id AS id_75,
  p3_.name AS name_76,
  p3_.date_entered AS date_entered_77,
  p3_.date_modified AS date_modified_78,
  p3_.description AS description_79,
  p3_.code1c AS code1c_80,
  p3_.barcode AS barcode_81,
  p3_.status AS status_82,
  p3_.price AS price_83,
  p3_.price_income AS price_income_84,
  p3_.mark_up AS mark_up_85,
  p3_.min_mark_up AS min_mark_up_86,
  p3_.packing_type AS packing_type_87,
  p3_.packing_type_count AS packing_type_count_88,
  p3_.discounts AS discounts_89,
  p3_.count_order AS count_order_90,
  p3_.product_to_order AS product_to_order_91,
  p3_.article AS article_92,
  p3_.nds AS nds_93,
  p3_.service AS service_94,
  p3_.transport_service AS transport_service_95,
  p3_.exise AS exise_96,
  p3_.expiration_date AS expiration_date_97,
  p3_.unit_volume AS unit_volume_98,
  p3_.net_weight AS net_weight_99,
  p3_.gross_weight AS gross_weight_100,
  p3_.go_by_weight AS go_by_weight_101,
  p3_.packaging AS packaging_102,
  p3_.old_code AS old_code_103,
  p3_.show AS show_104,
  p3_.balance AS balance_105,
  p3_.deleted AS deleted_106,
  p3_.category_cnt AS category_cnt_107,
  p3_.price_category AS price_category_108,
  p3_.is_salle AS is_salle_109,
  p3_.is_new AS is_new_110,
  p3_.is_top AS is_top_111,
  p3_.old_price AS old_price_112,
  p3_.discount_percent AS discount_percent_113,
  p3_.date_last_price_income AS date_last_price_income_114,
  p3_.video AS video_115,
  p3_.is_video AS is_video_116,
  p3_.is_free_shipping AS is_free_shipping_117,
  p3_.warranty_period AS warranty_period_118,
  p3_.min_balance AS min_balance_119,
  p3_.min_balance_admin AS min_balance_admin_120,
  p3_.main_category_id AS main_category_id_121,
  p3_.discontinued AS discontinued_122,
  p3_.seo_title AS seo_title_123,
  p3_.seo_description AS seo_description_124,
  p4_.id AS id_125,
  p4_.name AS name_126,
  p4_.date_entered AS date_entered_127,
  p4_.date_modified AS date_modified_128,
  p4_.description AS description_129,
  p4_.code1c AS code1c_130,
  p4_.barcode AS barcode_131,
  p4_.status AS status_132,
  p4_.price AS price_133,
  p4_.price_income AS price_income_134,
  p4_.mark_up AS mark_up_135,
  p4_.min_mark_up AS min_mark_up_136,
  p4_.packing_type AS packing_type_137,
  p4_.packing_type_count AS packing_type_count_138,
  p4_.discounts AS discounts_139,
  p4_.count_order AS count_order_140,
  p4_.product_to_order AS product_to_order_141,
  p4_.article AS article_142,
  p4_.nds AS nds_143,
  p4_.service AS service_144,
  p4_.transport_service AS transport_service_145,
  p4_.exise AS exise_146,
  p4_.expiration_date AS expiration_date_147,
  p4_.unit_volume AS unit_volume_148,
  p4_.net_weight AS net_weight_149,
  p4_.gross_weight AS gross_weight_150,
  p4_.go_by_weight AS go_by_weight_151,
  p4_.packaging AS packaging_152,
  p4_.old_code AS old_code_153,
  p4_.show AS show_154,
  p4_.balance AS balance_155,
  p4_.deleted AS deleted_156,
  p4_.category_cnt AS category_cnt_157,
  p4_.price_category AS price_category_158,
  p4_.is_salle AS is_salle_159,
  p4_.is_new AS is_new_160,
  p4_.is_top AS is_top_161,
  p4_.old_price AS old_price_162,
  p4_.discount_percent AS discount_percent_163,
  p4_.date_last_price_income AS date_last_price_income_164,
  p4_.video AS video_165,
  p4_.is_video AS is_video_166,
  p4_.is_free_shipping AS is_free_shipping_167,
  p4_.warranty_period AS warranty_period_168,
  p4_.min_balance AS min_balance_169,
  p4_.min_balance_admin AS min_balance_admin_170,
  p4_.main_category_id AS main_category_id_171,
  p4_.discontinued AS discontinued_172,
  p4_.seo_title AS seo_title_173,
  p4_.seo_description AS seo_description_174,
  m5_.id AS id_175,
  m5_.upload_timestamp AS upload_timestamp_176,
  m5_.main AS main_177,
  m5_.file_path AS file_path_178,
  m5_.type AS type_179,
  m5_.name AS name_180,
  m5_.size AS size_181,
  m5_.sort AS sort_182,
  m6_.id AS id_183,
  m6_.upload_timestamp AS upload_timestamp_184,
  m6_.main AS main_185,
  m6_.file_path AS file_path_186,
  m6_.type AS type_187,
  m6_.name AS name_188,
  m6_.size AS size_189,
  m6_.sort AS sort_190,
  m7_.id AS id_191,
  m7_.upload_timestamp AS upload_timestamp_192,
  m7_.main AS main_193,
  m7_.file_path AS file_path_194,
  m7_.type AS type_195,
  m7_.name AS name_196,
  m7_.size AS size_197,
  m7_.sort AS sort_198,
  m8_.id AS id_199,
  m8_.upload_timestamp AS upload_timestamp_200,
  m8_.main AS main_201,
  m8_.file_path AS file_path_202,
  m8_.type AS type_203,
  m8_.name AS name_204,
  m8_.size AS size_205,
  m8_.sort AS sort_206,
  p0_.modified_user_id AS modified_user_id_207,
  p0_.created_by_id AS created_by_id_208,
  p0_.measurement_unit_id AS measurement_unit_id_209,
  p0_.site_product_id AS site_product_id_210,
  p0_.storage_id AS storage_id_211,
  p0_.storage_element_id AS storage_element_id_212,
  p0_.language_id AS language_id_213,
  p0_.translation_id AS translation_id_214,
  p0_.main_media_id AS main_media_id_215,
  p0_.main_media_hover_id AS main_media_hover_id_216,
  c1_.parent_id AS parent_id_217,
  c1_.media_id AS media_id_218,
  c1_.language_id AS language_id_219,
  c1_.translation_id AS translation_id_220,
  p3_.modified_user_id AS modified_user_id_221,
  p3_.created_by_id AS created_by_id_222,
  p3_.measurement_unit_id AS measurement_unit_id_223,
  p3_.site_product_id AS site_product_id_224,
  p3_.storage_id AS storage_id_225,
  p3_.storage_element_id AS storage_element_id_226,
  p3_.language_id AS language_id_227,
  p3_.translation_id AS translation_id_228,
  p3_.main_media_id AS main_media_id_229,
  p3_.main_media_hover_id AS main_media_hover_id_230,
  p4_.modified_user_id AS modified_user_id_231,
  p4_.created_by_id AS created_by_id_232,
  p4_.measurement_unit_id AS measurement_unit_id_233,
  p4_.site_product_id AS site_product_id_234,
  p4_.storage_id AS storage_id_235,
  p4_.storage_element_id AS storage_element_id_236,
  p4_.language_id AS language_id_237,
  p4_.translation_id AS translation_id_238,
  p4_.main_media_id AS main_media_id_239,
  p4_.main_media_hover_id AS main_media_hover_id_240,
  m5_.product_id AS product_id_241,
  m5_.orders_id AS orders_id_242,
  m5_.users_id AS users_id_243,
  m5_.account_worker_id AS account_worker_id_244,
  m5_.form_answer_id AS form_answer_id_245,
  m5_.job_id AS job_id_246,
  m5_.resize_img_parent_id AS resize_img_parent_id_247,
  m6_.product_id AS product_id_248,
  m6_.orders_id AS orders_id_249,
  m6_.users_id AS users_id_250,
  m6_.account_worker_id AS account_worker_id_251,
  m6_.form_answer_id AS form_answer_id_252,
  m6_.job_id AS job_id_253,
  m6_.resize_img_parent_id AS resize_img_parent_id_254,
  m7_.product_id AS product_id_255,
  m7_.orders_id AS orders_id_256,
  m7_.users_id AS users_id_257,
  m7_.account_worker_id AS account_worker_id_258,
  m7_.form_answer_id AS form_answer_id_259,
  m7_.job_id AS job_id_260,
  m7_.resize_img_parent_id AS resize_img_parent_id_261,
  m8_.product_id AS product_id_262,
  m8_.orders_id AS orders_id_263,
  m8_.users_id AS users_id_264,
  m8_.account_worker_id AS account_worker_id_265,
  m8_.form_answer_id AS form_answer_id_266,
  m8_.job_id AS job_id_267,
  m8_.resize_img_parent_id AS resize_img_parent_id_268
FROM
  products p0_
  INNER JOIN products_category p9_ ON p0_.id = p9_.products_id
  INNER JOIN category c1_ ON c1_.id = p9_.category_id
  LEFT JOIN measurment_unit m2_ ON p0_.measurement_unit_id = m2_.id
  LEFT JOIN products p3_ ON p0_.translation_id = p3_.id
  LEFT JOIN products p4_ ON p0_.id = p4_.translation_id
  LEFT JOIN media_object m5_ ON p0_.main_media_id = m5_.id
  LEFT JOIN media_object m6_ ON m5_.id = m6_.resize_img_parent_id
  LEFT JOIN media_object m7_ ON p0_.main_media_hover_id = m7_.id
  LEFT JOIN media_object m8_ ON m7_.id = m8_.resize_img_parent_id
  LEFT JOIN media_object m10_ ON p0_.id = m10_.product_id
WHERE
  p0_.id IN (
    SELECT
      p11_.id
    FROM
      products p11_
      INNER JOIN products_category p13_ ON p11_.id = p13_.products_id
      INNER JOIN category c12_ ON c12_.id = p13_.category_id
    WHERE
      p11_.deleted = ?
      AND p11_.deleted = ?
      AND p11_.deleted = ?
      AND p11_.deleted = ?
      AND c12_.slug = ?
      AND p11_.show = ?
      AND p11_.discontinued = ?
  )
  AND p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.name ASC,
  m10_.sort DESC,
  p0_.discontinued DESC