Symfony Profiler

SELECT
  DISTINCT id_0,
  MIN(sclr_213) 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,
      p0_.salle_price AS salle_price_50,
      p0_.normal_price AS normal_price_51,
      c1_.id AS id_52,
      c1_.date_entered AS date_entered_53,
      c1_.date_modified AS date_modified_54,
      c1_.created_by AS created_by_55,
      c1_.modified_user_id AS modified_user_id_56,
      c1_.name AS name_57,
      c1_.slug AS slug_58,
      c1_.status AS status_59,
      c1_.description AS description_60,
      c1_.main AS main_61,
      c1_.type AS type_62,
      c1_.product_cnt AS product_cnt_63,
      c1_.site_product_cnt AS site_product_cnt_64,
      c1_.sort AS sort_65,
      c1_.seo_title AS seo_title_66,
      c1_.seo_description AS seo_description_67,
      m2_.id AS id_68,
      m2_.short_name AS short_name_69,
      m2_.name AS name_70,
      m2_.date_entered AS date_entered_71,
      m2_.date_modified AS date_modified_72,
      m2_.created_by AS created_by_73,
      m2_.modified_user_id AS modified_user_id_74,
      m2_.description AS description_75,
      m2_.code1c AS code1c_76,
      p3_.id AS id_77,
      p3_.name AS name_78,
      p3_.date_entered AS date_entered_79,
      p3_.date_modified AS date_modified_80,
      p3_.description AS description_81,
      p3_.code1c AS code1c_82,
      p3_.barcode AS barcode_83,
      p3_.status AS status_84,
      p3_.price AS price_85,
      p3_.price_income AS price_income_86,
      p3_.mark_up AS mark_up_87,
      p3_.min_mark_up AS min_mark_up_88,
      p3_.packing_type AS packing_type_89,
      p3_.packing_type_count AS packing_type_count_90,
      p3_.discounts AS discounts_91,
      p3_.count_order AS count_order_92,
      p3_.product_to_order AS product_to_order_93,
      p3_.article AS article_94,
      p3_.nds AS nds_95,
      p3_.service AS service_96,
      p3_.transport_service AS transport_service_97,
      p3_.exise AS exise_98,
      p3_.expiration_date AS expiration_date_99,
      p3_.unit_volume AS unit_volume_100,
      p3_.net_weight AS net_weight_101,
      p3_.gross_weight AS gross_weight_102,
      p3_.go_by_weight AS go_by_weight_103,
      p3_.packaging AS packaging_104,
      p3_.old_code AS old_code_105,
      p3_.show AS show_106,
      p3_.balance AS balance_107,
      p3_.deleted AS deleted_108,
      p3_.category_cnt AS category_cnt_109,
      p3_.price_category AS price_category_110,
      p3_.is_salle AS is_salle_111,
      p3_.is_new AS is_new_112,
      p3_.is_top AS is_top_113,
      p3_.old_price AS old_price_114,
      p3_.discount_percent AS discount_percent_115,
      p3_.date_last_price_income AS date_last_price_income_116,
      p3_.video AS video_117,
      p3_.is_video AS is_video_118,
      p3_.is_free_shipping AS is_free_shipping_119,
      p3_.warranty_period AS warranty_period_120,
      p3_.min_balance AS min_balance_121,
      p3_.min_balance_admin AS min_balance_admin_122,
      p3_.main_category_id AS main_category_id_123,
      p3_.discontinued AS discontinued_124,
      p3_.seo_title AS seo_title_125,
      p3_.seo_description AS seo_description_126,
      p3_.salle_price AS salle_price_127,
      p3_.normal_price AS normal_price_128,
      p4_.id AS id_129,
      p4_.name AS name_130,
      p4_.date_entered AS date_entered_131,
      p4_.date_modified AS date_modified_132,
      p4_.description AS description_133,
      p4_.code1c AS code1c_134,
      p4_.barcode AS barcode_135,
      p4_.status AS status_136,
      p4_.price AS price_137,
      p4_.price_income AS price_income_138,
      p4_.mark_up AS mark_up_139,
      p4_.min_mark_up AS min_mark_up_140,
      p4_.packing_type AS packing_type_141,
      p4_.packing_type_count AS packing_type_count_142,
      p4_.discounts AS discounts_143,
      p4_.count_order AS count_order_144,
      p4_.product_to_order AS product_to_order_145,
      p4_.article AS article_146,
      p4_.nds AS nds_147,
      p4_.service AS service_148,
      p4_.transport_service AS transport_service_149,
      p4_.exise AS exise_150,
      p4_.expiration_date AS expiration_date_151,
      p4_.unit_volume AS unit_volume_152,
      p4_.net_weight AS net_weight_153,
      p4_.gross_weight AS gross_weight_154,
      p4_.go_by_weight AS go_by_weight_155,
      p4_.packaging AS packaging_156,
      p4_.old_code AS old_code_157,
      p4_.show AS show_158,
      p4_.balance AS balance_159,
      p4_.deleted AS deleted_160,
      p4_.category_cnt AS category_cnt_161,
      p4_.price_category AS price_category_162,
      p4_.is_salle AS is_salle_163,
      p4_.is_new AS is_new_164,
      p4_.is_top AS is_top_165,
      p4_.old_price AS old_price_166,
      p4_.discount_percent AS discount_percent_167,
      p4_.date_last_price_income AS date_last_price_income_168,
      p4_.video AS video_169,
      p4_.is_video AS is_video_170,
      p4_.is_free_shipping AS is_free_shipping_171,
      p4_.warranty_period AS warranty_period_172,
      p4_.min_balance AS min_balance_173,
      p4_.min_balance_admin AS min_balance_admin_174,
      p4_.main_category_id AS main_category_id_175,
      p4_.discontinued AS discontinued_176,
      p4_.seo_title AS seo_title_177,
      p4_.seo_description AS seo_description_178,
      p4_.salle_price AS salle_price_179,
      p4_.normal_price AS normal_price_180,
      m5_.id AS id_181,
      m5_.upload_timestamp AS upload_timestamp_182,
      m5_.main AS main_183,
      m5_.file_path AS file_path_184,
      m5_.type AS type_185,
      m5_.name AS name_186,
      m5_.size AS size_187,
      m5_.sort AS sort_188,
      m6_.id AS id_189,
      m6_.upload_timestamp AS upload_timestamp_190,
      m6_.main AS main_191,
      m6_.file_path AS file_path_192,
      m6_.type AS type_193,
      m6_.name AS name_194,
      m6_.size AS size_195,
      m6_.sort AS sort_196,
      m7_.id AS id_197,
      m7_.upload_timestamp AS upload_timestamp_198,
      m7_.main AS main_199,
      m7_.file_path AS file_path_200,
      m7_.type AS type_201,
      m7_.name AS name_202,
      m7_.size AS size_203,
      m7_.sort AS sort_204,
      m8_.id AS id_205,
      m8_.upload_timestamp AS upload_timestamp_206,
      m8_.main AS main_207,
      m8_.file_path AS file_path_208,
      m8_.type AS type_209,
      m8_.name AS name_210,
      m8_.size AS size_211,
      m8_.sort AS sort_212,
      ROW_NUMBER() OVER(
        ORDER BY
          p0_.name ASC,
          m9_.sort DESC,
          p0_.discontinued DESC
      ) AS sclr_213
    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_213) 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, p0_.salle_price AS salle_price_50, p0_.normal_price AS normal_price_51, c1_.id AS id_52, c1_.date_entered AS date_entered_53, c1_.date_modified AS date_modified_54, c1_.created_by AS created_by_55, c1_.modified_user_id AS modified_user_id_56, c1_.name AS name_57, c1_.slug AS slug_58, c1_.status AS status_59, c1_.description AS description_60, c1_.main AS main_61, c1_.type AS type_62, c1_.product_cnt AS product_cnt_63, c1_.site_product_cnt AS site_product_cnt_64, c1_.sort AS sort_65, c1_.seo_title AS seo_title_66, c1_.seo_description AS seo_description_67, m2_.id AS id_68, m2_.short_name AS short_name_69, m2_.name AS name_70, m2_.date_entered AS date_entered_71, m2_.date_modified AS date_modified_72, m2_.created_by AS created_by_73, m2_.modified_user_id AS modified_user_id_74, m2_.description AS description_75, m2_.code1c AS code1c_76, p3_.id AS id_77, p3_.name AS name_78, p3_.date_entered AS date_entered_79, p3_.date_modified AS date_modified_80, p3_.description AS description_81, p3_.code1c AS code1c_82, p3_.barcode AS barcode_83, p3_.status AS status_84, p3_.price AS price_85, p3_.price_income AS price_income_86, p3_.mark_up AS mark_up_87, p3_.min_mark_up AS min_mark_up_88, p3_.packing_type AS packing_type_89, p3_.packing_type_count AS packing_type_count_90, p3_.discounts AS discounts_91, p3_.count_order AS count_order_92, p3_.product_to_order AS product_to_order_93, p3_.article AS article_94, p3_.nds AS nds_95, p3_.service AS service_96, p3_.transport_service AS transport_service_97, p3_.exise AS exise_98, p3_.expiration_date AS expiration_date_99, p3_.unit_volume AS unit_volume_100, p3_.net_weight AS net_weight_101, p3_.gross_weight AS gross_weight_102, p3_.go_by_weight AS go_by_weight_103, p3_.packaging AS packaging_104, p3_.old_code AS old_code_105, p3_.show AS show_106, p3_.balance AS balance_107, p3_.deleted AS deleted_108, p3_.category_cnt AS category_cnt_109, p3_.price_category AS price_category_110, p3_.is_salle AS is_salle_111, p3_.is_new AS is_new_112, p3_.is_top AS is_top_113, p3_.old_price AS old_price_114, p3_.discount_percent AS discount_percent_115, p3_.date_last_price_income AS date_last_price_income_116, p3_.video AS video_117, p3_.is_video AS is_video_118, p3_.is_free_shipping AS is_free_shipping_119, p3_.warranty_period AS warranty_period_120, p3_.min_balance AS min_balance_121, p3_.min_balance_admin AS min_balance_admin_122, p3_.main_category_id AS main_category_id_123, p3_.discontinued AS discontinued_124, p3_.seo_title AS seo_title_125, p3_.seo_description AS seo_description_126, p3_.salle_price AS salle_price_127, p3_.normal_price AS normal_price_128, p4_.id AS id_129, p4_.name AS name_130, p4_.date_entered AS date_entered_131, p4_.date_modified AS date_modified_132, p4_.description AS description_133, p4_.code1c AS code1c_134, p4_.barcode AS barcode_135, p4_.status AS status_136, p4_.price AS price_137, p4_.price_income AS price_income_138, p4_.mark_up AS mark_up_139, p4_.min_mark_up AS min_mark_up_140, p4_.packing_type AS packing_type_141, p4_.packing_type_count AS packing_type_count_142, p4_.discounts AS discounts_143, p4_.count_order AS count_order_144, p4_.product_to_order AS product_to_order_145, p4_.article AS article_146, p4_.nds AS nds_147, p4_.service AS service_148, p4_.transport_service AS transport_service_149, p4_.exise AS exise_150, p4_.expiration_date AS expiration_date_151, p4_.unit_volume AS unit_volume_152, p4_.net_weight AS net_weight_153, p4_.gross_weight AS gross_weight_154, p4_.go_by_weight AS go_by_weight_155, p4_.packaging AS packaging_156, p4_.old_code AS old_code_157, p4_.show AS show_158, p4_.balance AS balance_159, p4_.deleted AS deleted_160, p4_.category_cnt AS category_cnt_161, p4_.price_category AS price_category_162, p4_.is_salle AS is_salle_163, p4_.is_new AS is_new_164, p4_.is_top AS is_top_165, p4_.old_price AS old_price_166, p4_.discount_percent AS discount_percent_167, p4_.date_last_price_income AS date_last_price_income_168, p4_.video AS video_169, p4_.is_video AS is_video_170, p4_.is_free_shipping AS is_free_shipping_171, p4_.warranty_period AS warranty_period_172, p4_.min_balance AS min_balance_173, p4_.min_balance_admin AS min_balance_admin_174, p4_.main_category_id AS main_category_id_175, p4_.discontinued AS discontinued_176, p4_.seo_title AS seo_title_177, p4_.seo_description AS seo_description_178, p4_.salle_price AS salle_price_179, p4_.normal_price AS normal_price_180, m5_.id AS id_181, m5_.upload_timestamp AS upload_timestamp_182, m5_.main AS main_183, m5_.file_path AS file_path_184, m5_.type AS type_185, m5_.name AS name_186, m5_.size AS size_187, m5_.sort AS sort_188, m6_.id AS id_189, m6_.upload_timestamp AS upload_timestamp_190, m6_.main AS main_191, m6_.file_path AS file_path_192, m6_.type AS type_193, m6_.name AS name_194, m6_.size AS size_195, m6_.sort AS sort_196, m7_.id AS id_197, m7_.upload_timestamp AS upload_timestamp_198, m7_.main AS main_199, m7_.file_path AS file_path_200, m7_.type AS type_201, m7_.name AS name_202, m7_.size AS size_203, m7_.sort AS sort_204, m8_.id AS id_205, m8_.upload_timestamp AS upload_timestamp_206, m8_.main AS main_207, m8_.file_path AS file_path_208, m8_.type AS type_209, m8_.name AS name_210, m8_.size AS size_211, m8_.sort AS sort_212, ROW_NUMBER() OVER(ORDER BY p0_.name ASC, m9_.sort DESC, p0_.discontinued DESC) AS sclr_213 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 = 'populyarnitovari' 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,
  p0_.salle_price AS salle_price_50,
  p0_.normal_price AS normal_price_51,
  c1_.id AS id_52,
  c1_.date_entered AS date_entered_53,
  c1_.date_modified AS date_modified_54,
  c1_.created_by AS created_by_55,
  c1_.modified_user_id AS modified_user_id_56,
  c1_.name AS name_57,
  c1_.slug AS slug_58,
  c1_.status AS status_59,
  c1_.description AS description_60,
  c1_.main AS main_61,
  c1_.type AS type_62,
  c1_.product_cnt AS product_cnt_63,
  c1_.site_product_cnt AS site_product_cnt_64,
  c1_.sort AS sort_65,
  c1_.seo_title AS seo_title_66,
  c1_.seo_description AS seo_description_67,
  m2_.id AS id_68,
  m2_.short_name AS short_name_69,
  m2_.name AS name_70,
  m2_.date_entered AS date_entered_71,
  m2_.date_modified AS date_modified_72,
  m2_.created_by AS created_by_73,
  m2_.modified_user_id AS modified_user_id_74,
  m2_.description AS description_75,
  m2_.code1c AS code1c_76,
  p3_.id AS id_77,
  p3_.name AS name_78,
  p3_.date_entered AS date_entered_79,
  p3_.date_modified AS date_modified_80,
  p3_.description AS description_81,
  p3_.code1c AS code1c_82,
  p3_.barcode AS barcode_83,
  p3_.status AS status_84,
  p3_.price AS price_85,
  p3_.price_income AS price_income_86,
  p3_.mark_up AS mark_up_87,
  p3_.min_mark_up AS min_mark_up_88,
  p3_.packing_type AS packing_type_89,
  p3_.packing_type_count AS packing_type_count_90,
  p3_.discounts AS discounts_91,
  p3_.count_order AS count_order_92,
  p3_.product_to_order AS product_to_order_93,
  p3_.article AS article_94,
  p3_.nds AS nds_95,
  p3_.service AS service_96,
  p3_.transport_service AS transport_service_97,
  p3_.exise AS exise_98,
  p3_.expiration_date AS expiration_date_99,
  p3_.unit_volume AS unit_volume_100,
  p3_.net_weight AS net_weight_101,
  p3_.gross_weight AS gross_weight_102,
  p3_.go_by_weight AS go_by_weight_103,
  p3_.packaging AS packaging_104,
  p3_.old_code AS old_code_105,
  p3_.show AS show_106,
  p3_.balance AS balance_107,
  p3_.deleted AS deleted_108,
  p3_.category_cnt AS category_cnt_109,
  p3_.price_category AS price_category_110,
  p3_.is_salle AS is_salle_111,
  p3_.is_new AS is_new_112,
  p3_.is_top AS is_top_113,
  p3_.old_price AS old_price_114,
  p3_.discount_percent AS discount_percent_115,
  p3_.date_last_price_income AS date_last_price_income_116,
  p3_.video AS video_117,
  p3_.is_video AS is_video_118,
  p3_.is_free_shipping AS is_free_shipping_119,
  p3_.warranty_period AS warranty_period_120,
  p3_.min_balance AS min_balance_121,
  p3_.min_balance_admin AS min_balance_admin_122,
  p3_.main_category_id AS main_category_id_123,
  p3_.discontinued AS discontinued_124,
  p3_.seo_title AS seo_title_125,
  p3_.seo_description AS seo_description_126,
  p3_.salle_price AS salle_price_127,
  p3_.normal_price AS normal_price_128,
  p4_.id AS id_129,
  p4_.name AS name_130,
  p4_.date_entered AS date_entered_131,
  p4_.date_modified AS date_modified_132,
  p4_.description AS description_133,
  p4_.code1c AS code1c_134,
  p4_.barcode AS barcode_135,
  p4_.status AS status_136,
  p4_.price AS price_137,
  p4_.price_income AS price_income_138,
  p4_.mark_up AS mark_up_139,
  p4_.min_mark_up AS min_mark_up_140,
  p4_.packing_type AS packing_type_141,
  p4_.packing_type_count AS packing_type_count_142,
  p4_.discounts AS discounts_143,
  p4_.count_order AS count_order_144,
  p4_.product_to_order AS product_to_order_145,
  p4_.article AS article_146,
  p4_.nds AS nds_147,
  p4_.service AS service_148,
  p4_.transport_service AS transport_service_149,
  p4_.exise AS exise_150,
  p4_.expiration_date AS expiration_date_151,
  p4_.unit_volume AS unit_volume_152,
  p4_.net_weight AS net_weight_153,
  p4_.gross_weight AS gross_weight_154,
  p4_.go_by_weight AS go_by_weight_155,
  p4_.packaging AS packaging_156,
  p4_.old_code AS old_code_157,
  p4_.show AS show_158,
  p4_.balance AS balance_159,
  p4_.deleted AS deleted_160,
  p4_.category_cnt AS category_cnt_161,
  p4_.price_category AS price_category_162,
  p4_.is_salle AS is_salle_163,
  p4_.is_new AS is_new_164,
  p4_.is_top AS is_top_165,
  p4_.old_price AS old_price_166,
  p4_.discount_percent AS discount_percent_167,
  p4_.date_last_price_income AS date_last_price_income_168,
  p4_.video AS video_169,
  p4_.is_video AS is_video_170,
  p4_.is_free_shipping AS is_free_shipping_171,
  p4_.warranty_period AS warranty_period_172,
  p4_.min_balance AS min_balance_173,
  p4_.min_balance_admin AS min_balance_admin_174,
  p4_.main_category_id AS main_category_id_175,
  p4_.discontinued AS discontinued_176,
  p4_.seo_title AS seo_title_177,
  p4_.seo_description AS seo_description_178,
  p4_.salle_price AS salle_price_179,
  p4_.normal_price AS normal_price_180,
  m5_.id AS id_181,
  m5_.upload_timestamp AS upload_timestamp_182,
  m5_.main AS main_183,
  m5_.file_path AS file_path_184,
  m5_.type AS type_185,
  m5_.name AS name_186,
  m5_.size AS size_187,
  m5_.sort AS sort_188,
  m6_.id AS id_189,
  m6_.upload_timestamp AS upload_timestamp_190,
  m6_.main AS main_191,
  m6_.file_path AS file_path_192,
  m6_.type AS type_193,
  m6_.name AS name_194,
  m6_.size AS size_195,
  m6_.sort AS sort_196,
  m7_.id AS id_197,
  m7_.upload_timestamp AS upload_timestamp_198,
  m7_.main AS main_199,
  m7_.file_path AS file_path_200,
  m7_.type AS type_201,
  m7_.name AS name_202,
  m7_.size AS size_203,
  m7_.sort AS sort_204,
  m8_.id AS id_205,
  m8_.upload_timestamp AS upload_timestamp_206,
  m8_.main AS main_207,
  m8_.file_path AS file_path_208,
  m8_.type AS type_209,
  m8_.name AS name_210,
  m8_.size AS size_211,
  m8_.sort AS sort_212,
  p0_.modified_user_id AS modified_user_id_213,
  p0_.created_by_id AS created_by_id_214,
  p0_.measurement_unit_id AS measurement_unit_id_215,
  p0_.site_product_id AS site_product_id_216,
  p0_.storage_id AS storage_id_217,
  p0_.storage_element_id AS storage_element_id_218,
  p0_.language_id AS language_id_219,
  p0_.translation_id AS translation_id_220,
  p0_.main_media_id AS main_media_id_221,
  p0_.main_media_hover_id AS main_media_hover_id_222,
  c1_.parent_id AS parent_id_223,
  c1_.media_id AS media_id_224,
  c1_.language_id AS language_id_225,
  c1_.translation_id AS translation_id_226,
  p3_.modified_user_id AS modified_user_id_227,
  p3_.created_by_id AS created_by_id_228,
  p3_.measurement_unit_id AS measurement_unit_id_229,
  p3_.site_product_id AS site_product_id_230,
  p3_.storage_id AS storage_id_231,
  p3_.storage_element_id AS storage_element_id_232,
  p3_.language_id AS language_id_233,
  p3_.translation_id AS translation_id_234,
  p3_.main_media_id AS main_media_id_235,
  p3_.main_media_hover_id AS main_media_hover_id_236,
  p4_.modified_user_id AS modified_user_id_237,
  p4_.created_by_id AS created_by_id_238,
  p4_.measurement_unit_id AS measurement_unit_id_239,
  p4_.site_product_id AS site_product_id_240,
  p4_.storage_id AS storage_id_241,
  p4_.storage_element_id AS storage_element_id_242,
  p4_.language_id AS language_id_243,
  p4_.translation_id AS translation_id_244,
  p4_.main_media_id AS main_media_id_245,
  p4_.main_media_hover_id AS main_media_hover_id_246,
  m5_.product_id AS product_id_247,
  m5_.orders_id AS orders_id_248,
  m5_.users_id AS users_id_249,
  m5_.account_worker_id AS account_worker_id_250,
  m5_.form_answer_id AS form_answer_id_251,
  m5_.job_id AS job_id_252,
  m5_.resize_img_parent_id AS resize_img_parent_id_253,
  m6_.product_id AS product_id_254,
  m6_.orders_id AS orders_id_255,
  m6_.users_id AS users_id_256,
  m6_.account_worker_id AS account_worker_id_257,
  m6_.form_answer_id AS form_answer_id_258,
  m6_.job_id AS job_id_259,
  m6_.resize_img_parent_id AS resize_img_parent_id_260,
  m7_.product_id AS product_id_261,
  m7_.orders_id AS orders_id_262,
  m7_.users_id AS users_id_263,
  m7_.account_worker_id AS account_worker_id_264,
  m7_.form_answer_id AS form_answer_id_265,
  m7_.job_id AS job_id_266,
  m7_.resize_img_parent_id AS resize_img_parent_id_267,
  m8_.product_id AS product_id_268,
  m8_.orders_id AS orders_id_269,
  m8_.users_id AS users_id_270,
  m8_.account_worker_id AS account_worker_id_271,
  m8_.form_answer_id AS form_answer_id_272,
  m8_.job_id AS job_id_273,
  m8_.resize_img_parent_id AS resize_img_parent_id_274
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