Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      available_25
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.created AS created_1,
          p0_.updated AS updated_2,
          p0_.updated_by_time AS updated_by_time_3,
          p0_.omega_plu AS omega_plu_4,
          p0_.code AS code_5,
          p0_.name AS name_6,
          p0_.warranty AS warranty_7,
          p0_.part_number AS part_number_8,
          p0_.ean AS ean_9,
          p0_.gtin AS gtin_10,
          p0_.amazon_code AS amazon_code_11,
          p0_.length AS length_12,
          p0_.width AS width_13,
          p0_.height AS height_14,
          p0_.weight AS weight_15,
          p0_.unit AS unit_16,
          p0_.badges AS badges_17,
          p0_.detail AS detail_18,
          p0_.stock_position AS stock_position_19,
          p0_.out_of_stock_status AS out_of_stock_status_20,
          p0_.quality_status AS quality_status_21,
          p0_.sold_out_date AS sold_out_date_22,
          p0_.cache_description AS cache_description_23,
          p0_.cache_item_last_updated AS cache_item_last_updated_24,
          p0_.available AS available_25,
          p0_.in_stock AS in_stock_26,
          p0_.archived AS archived_27,
          p0_.scannable AS scannable_28,
          p0_.last_price AS last_price_29,
          p0_.avg_price AS avg_price_30,
          p0_.container AS container_31,
          p0_.last_sale AS last_sale_32,
          p0_.cpu_mark AS cpu_mark_33,
          p0_.spare_part_card AS spare_part_card_34,
          p0_.spare_part_price AS spare_part_price_35,
          p0_.sold_during_time_frame AS sold_during_time_frame_36,
          p0_.spare_part_created AS spare_part_created_37,
          p0_.spare_part_updated AS spare_part_updated_38,
          p0_.margin_level AS margin_level_39,
          p0_.quantity_limit AS quantity_limit_40,
          p0_.availability_paused_for_product_model AS availability_paused_for_product_model_41,
          p0_.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_42,
          p0_.calculated_qty_grade_new AS calculated_qty_grade_new_43,
          p0_.calculated_qty_grade_a AS calculated_qty_grade_a_44,
          p0_.calculated_qty_grade_b AS calculated_qty_grade_b_45,
          p0_.calculated_qty_grade_c AS calculated_qty_grade_c_46,
          p0_.calculated_qty_grade_d AS calculated_qty_grade_d_47,
          p0_.calculated_qty_date AS calculated_qty_date_48,
          p1_.id AS id_49,
          p1_.created AS created_50,
          p1_.updated AS updated_51,
          p1_.updated_by_time AS updated_by_time_52,
          p1_.published AS published_53,
          p1_.indexable AS indexable_54,
          p1_.social_share_image AS social_share_image_55,
          p1_.type AS type_56,
          p1_.badges AS badges_57,
          p1_.show_only_discounted AS show_only_discounted_58,
          p1_.show_only_flash_sales AS show_only_flash_sales_59,
          p1_.show_only_bazaar AS show_only_bazaar_60,
          p1_.include_bazaar AS include_bazaar_61,
          p1_.show_popular_products AS show_popular_products_62,
          p2_.id AS id_63,
          p2_.created AS created_64,
          p2_.updated AS updated_65,
          p2_.price AS price_66,
          p2_.suggested_price AS suggested_price_67,
          p2_.current_vat_price AS current_vat_price_68,
          p2_.discount AS discount_69,
          p2_.discounted AS discounted_70,
          p2_.active AS active_71,
          p2_.listed AS listed_72,
          p2_.orderable AS orderable_73,
          p2_.vat AS vat_74,
          p2_.warranty AS warranty_75,
          p2_.bazaar AS bazaar_76,
          p2_.best_seller AS best_seller_77,
          p2_.re_lenovo AS re_lenovo_78,
          p2_.hp_renew AS hp_renew_79,
          p2_.special_promotion AS special_promotion_80,
          p2_.detail AS detail_81,
          p2_.sale_start AS sale_start_82,
          p2_.sale_end AS sale_end_83,
          p2_.activation_date AS activation_date_84,
          p2_.discounted_date AS discounted_date_85,
          p2_.flash_sale_date AS flash_sale_date_86
        FROM
          products p0_
          LEFT JOIN products__metas p2_ ON p0_.id = p2_.product_id
          LEFT JOIN vendors v3_ ON p0_.vendor_id = v3_.id
          LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id
          LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id
          LEFT JOIN pages_category p1_ ON p1_.id = c5_.category_page_id
          AND (p1_.id = ?)
        WHERE
          p0_.badges LIKE '%\"Notebook bundle\"%'
          AND p0_.quality_status <> ?
          AND p2_.domain_id = ?
          AND p2_.price > 0
          AND p0_.archived = 0
          AND p2_.active = ?
          AND p2_.listed = ?
          AND (
            p0_.available > 0
            AND NOT (p0_.out_of_stock_status = 4)
          )
          AND p2_.orderable = ?
        ORDER BY
          p1_.id DESC
      ) dctrn_result_inner
    ORDER BY
      available_25 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, available_25 FROM (SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.updated_by_time AS updated_by_time_3, p0_.omega_plu AS omega_plu_4, p0_.code AS code_5, p0_.name AS name_6, p0_.warranty AS warranty_7, p0_.part_number AS part_number_8, p0_.ean AS ean_9, p0_.gtin AS gtin_10, p0_.amazon_code AS amazon_code_11, p0_.length AS length_12, p0_.width AS width_13, p0_.height AS height_14, p0_.weight AS weight_15, p0_.unit AS unit_16, p0_.badges AS badges_17, p0_.detail AS detail_18, p0_.stock_position AS stock_position_19, p0_.out_of_stock_status AS out_of_stock_status_20, p0_.quality_status AS quality_status_21, p0_.sold_out_date AS sold_out_date_22, p0_.cache_description AS cache_description_23, p0_.cache_item_last_updated AS cache_item_last_updated_24, p0_.available AS available_25, p0_.in_stock AS in_stock_26, p0_.archived AS archived_27, p0_.scannable AS scannable_28, p0_.last_price AS last_price_29, p0_.avg_price AS avg_price_30, p0_.container AS container_31, p0_.last_sale AS last_sale_32, p0_.cpu_mark AS cpu_mark_33, p0_.spare_part_card AS spare_part_card_34, p0_.spare_part_price AS spare_part_price_35, p0_.sold_during_time_frame AS sold_during_time_frame_36, p0_.spare_part_created AS spare_part_created_37, p0_.spare_part_updated AS spare_part_updated_38, p0_.margin_level AS margin_level_39, p0_.quantity_limit AS quantity_limit_40, p0_.availability_paused_for_product_model AS availability_paused_for_product_model_41, p0_.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_42, p0_.calculated_qty_grade_new AS calculated_qty_grade_new_43, p0_.calculated_qty_grade_a AS calculated_qty_grade_a_44, p0_.calculated_qty_grade_b AS calculated_qty_grade_b_45, p0_.calculated_qty_grade_c AS calculated_qty_grade_c_46, p0_.calculated_qty_grade_d AS calculated_qty_grade_d_47, p0_.calculated_qty_date AS calculated_qty_date_48, p1_.id AS id_49, p1_.created AS created_50, p1_.updated AS updated_51, p1_.updated_by_time AS updated_by_time_52, p1_.published AS published_53, p1_.indexable AS indexable_54, p1_.social_share_image AS social_share_image_55, p1_.type AS type_56, p1_.badges AS badges_57, p1_.show_only_discounted AS show_only_discounted_58, p1_.show_only_flash_sales AS show_only_flash_sales_59, p1_.show_only_bazaar AS show_only_bazaar_60, p1_.include_bazaar AS include_bazaar_61, p1_.show_popular_products AS show_popular_products_62, p2_.id AS id_63, p2_.created AS created_64, p2_.updated AS updated_65, p2_.price AS price_66, p2_.suggested_price AS suggested_price_67, p2_.current_vat_price AS current_vat_price_68, p2_.discount AS discount_69, p2_.discounted AS discounted_70, p2_.active AS active_71, p2_.listed AS listed_72, p2_.orderable AS orderable_73, p2_.vat AS vat_74, p2_.warranty AS warranty_75, p2_.bazaar AS bazaar_76, p2_.best_seller AS best_seller_77, p2_.re_lenovo AS re_lenovo_78, p2_.hp_renew AS hp_renew_79, p2_.special_promotion AS special_promotion_80, p2_.detail AS detail_81, p2_.sale_start AS sale_start_82, p2_.sale_end AS sale_end_83, p2_.activation_date AS activation_date_84, p2_.discounted_date AS discounted_date_85, p2_.flash_sale_date AS flash_sale_date_86 FROM products p0_ LEFT JOIN products__metas p2_ ON p0_.id = p2_.product_id LEFT JOIN vendors v3_ ON p0_.vendor_id = v3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id LEFT JOIN pages_category p1_ ON p1_.id = c5_.category_page_id AND (p1_.id = 455) WHERE p0_.badges LIKE '%\"Notebook bundle\"%' AND p0_.quality_status <> 9 AND p2_.domain_id = 1 AND p2_.price > 0 AND p0_.archived = 0 AND p2_.active = 1 AND p2_.listed = 1 AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4)) AND p2_.orderable = 1 ORDER BY p1_.id DESC) dctrn_result_inner ORDER BY available_25 DESC) dctrn_result LIMIT 3;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  products p0_
  LEFT JOIN products__metas p1_ ON p0_.id = p1_.product_id
  LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id
  LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id
  LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id
  LEFT JOIN pages_category p4_ ON p4_.id = c5_.category_page_id
  AND (p4_.id = ?)
WHERE
  p0_.badges LIKE '%\"Notebook bundle\"%'
  AND p0_.quality_status <> ?
  AND p1_.domain_id = ?
  AND p1_.price > 0
  AND p0_.archived = 0
  AND p1_.active = ?
  AND p1_.listed = ?
  AND (
    p0_.available > 0
    AND NOT (p0_.out_of_stock_status = 4)
  )

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM products p0_ LEFT JOIN products__metas p1_ ON p0_.id = p1_.product_id LEFT JOIN vendors v2_ ON p0_.vendor_id = v2_.id LEFT JOIN product_types p3_ ON p0_.type_id = p3_.id LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id LEFT JOIN pages_category p4_ ON p4_.id = c5_.category_page_id AND (p4_.id = 455) WHERE p0_.badges LIKE '%\"Notebook bundle\"%' AND p0_.quality_status <> 9 AND p1_.domain_id = 1 AND p1_.price > 0 AND p0_.archived = 0 AND p1_.active = 1 AND p1_.listed = 1 AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4));

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      available_25
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.created AS created_1,
          p0_.updated AS updated_2,
          p0_.updated_by_time AS updated_by_time_3,
          p0_.omega_plu AS omega_plu_4,
          p0_.code AS code_5,
          p0_.name AS name_6,
          p0_.warranty AS warranty_7,
          p0_.part_number AS part_number_8,
          p0_.ean AS ean_9,
          p0_.gtin AS gtin_10,
          p0_.amazon_code AS amazon_code_11,
          p0_.length AS length_12,
          p0_.width AS width_13,
          p0_.height AS height_14,
          p0_.weight AS weight_15,
          p0_.unit AS unit_16,
          p0_.badges AS badges_17,
          p0_.detail AS detail_18,
          p0_.stock_position AS stock_position_19,
          p0_.out_of_stock_status AS out_of_stock_status_20,
          p0_.quality_status AS quality_status_21,
          p0_.sold_out_date AS sold_out_date_22,
          p0_.cache_description AS cache_description_23,
          p0_.cache_item_last_updated AS cache_item_last_updated_24,
          p0_.available AS available_25,
          p0_.in_stock AS in_stock_26,
          p0_.archived AS archived_27,
          p0_.scannable AS scannable_28,
          p0_.last_price AS last_price_29,
          p0_.avg_price AS avg_price_30,
          p0_.container AS container_31,
          p0_.last_sale AS last_sale_32,
          p0_.cpu_mark AS cpu_mark_33,
          p0_.spare_part_card AS spare_part_card_34,
          p0_.spare_part_price AS spare_part_price_35,
          p0_.sold_during_time_frame AS sold_during_time_frame_36,
          p0_.spare_part_created AS spare_part_created_37,
          p0_.spare_part_updated AS spare_part_updated_38,
          p0_.margin_level AS margin_level_39,
          p0_.quantity_limit AS quantity_limit_40,
          p0_.availability_paused_for_product_model AS availability_paused_for_product_model_41,
          p0_.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_42,
          p0_.calculated_qty_grade_new AS calculated_qty_grade_new_43,
          p0_.calculated_qty_grade_a AS calculated_qty_grade_a_44,
          p0_.calculated_qty_grade_b AS calculated_qty_grade_b_45,
          p0_.calculated_qty_grade_c AS calculated_qty_grade_c_46,
          p0_.calculated_qty_grade_d AS calculated_qty_grade_d_47,
          p0_.calculated_qty_date AS calculated_qty_date_48,
          p1_.id AS id_49,
          p1_.created AS created_50,
          p1_.updated AS updated_51,
          p1_.updated_by_time AS updated_by_time_52,
          p1_.published AS published_53,
          p1_.indexable AS indexable_54,
          p1_.social_share_image AS social_share_image_55,
          p1_.type AS type_56,
          p1_.badges AS badges_57,
          p1_.show_only_discounted AS show_only_discounted_58,
          p1_.show_only_flash_sales AS show_only_flash_sales_59,
          p1_.show_only_bazaar AS show_only_bazaar_60,
          p1_.include_bazaar AS include_bazaar_61,
          p1_.show_popular_products AS show_popular_products_62,
          p2_.id AS id_63,
          p2_.created AS created_64,
          p2_.updated AS updated_65,
          p2_.price AS price_66,
          p2_.suggested_price AS suggested_price_67,
          p2_.current_vat_price AS current_vat_price_68,
          p2_.discount AS discount_69,
          p2_.discounted AS discounted_70,
          p2_.active AS active_71,
          p2_.listed AS listed_72,
          p2_.orderable AS orderable_73,
          p2_.vat AS vat_74,
          p2_.warranty AS warranty_75,
          p2_.bazaar AS bazaar_76,
          p2_.best_seller AS best_seller_77,
          p2_.re_lenovo AS re_lenovo_78,
          p2_.hp_renew AS hp_renew_79,
          p2_.special_promotion AS special_promotion_80,
          p2_.detail AS detail_81,
          p2_.sale_start AS sale_start_82,
          p2_.sale_end AS sale_end_83,
          p2_.activation_date AS activation_date_84,
          p2_.discounted_date AS discounted_date_85,
          p2_.flash_sale_date AS flash_sale_date_86
        FROM
          products p0_
          LEFT JOIN products__metas p2_ ON p0_.id = p2_.product_id
          LEFT JOIN vendors v3_ ON p0_.vendor_id = v3_.id
          LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id
          LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id
          LEFT JOIN pages_category p1_ ON p1_.id = c5_.category_page_id
          AND (p1_.id = ?)
        WHERE
          p0_.badges LIKE '%\"Notebook bundle\"%'
          AND p2_.discounted = ?
          AND p0_.quality_status <> ?
          AND p2_.domain_id = ?
          AND p2_.price > 0
          AND p0_.archived = 0
          AND p2_.active = ?
          AND p2_.listed = ?
          AND (
            p0_.available > 0
            AND NOT (p0_.out_of_stock_status = 4)
          )
          AND p2_.orderable = ?
        ORDER BY
          p1_.id DESC
      ) dctrn_result_inner
    ORDER BY
      available_25 DESC
  ) dctrn_result
LIMIT
  3

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, available_25 FROM (SELECT p0_.id AS id_0, p0_.created AS created_1, p0_.updated AS updated_2, p0_.updated_by_time AS updated_by_time_3, p0_.omega_plu AS omega_plu_4, p0_.code AS code_5, p0_.name AS name_6, p0_.warranty AS warranty_7, p0_.part_number AS part_number_8, p0_.ean AS ean_9, p0_.gtin AS gtin_10, p0_.amazon_code AS amazon_code_11, p0_.length AS length_12, p0_.width AS width_13, p0_.height AS height_14, p0_.weight AS weight_15, p0_.unit AS unit_16, p0_.badges AS badges_17, p0_.detail AS detail_18, p0_.stock_position AS stock_position_19, p0_.out_of_stock_status AS out_of_stock_status_20, p0_.quality_status AS quality_status_21, p0_.sold_out_date AS sold_out_date_22, p0_.cache_description AS cache_description_23, p0_.cache_item_last_updated AS cache_item_last_updated_24, p0_.available AS available_25, p0_.in_stock AS in_stock_26, p0_.archived AS archived_27, p0_.scannable AS scannable_28, p0_.last_price AS last_price_29, p0_.avg_price AS avg_price_30, p0_.container AS container_31, p0_.last_sale AS last_sale_32, p0_.cpu_mark AS cpu_mark_33, p0_.spare_part_card AS spare_part_card_34, p0_.spare_part_price AS spare_part_price_35, p0_.sold_during_time_frame AS sold_during_time_frame_36, p0_.spare_part_created AS spare_part_created_37, p0_.spare_part_updated AS spare_part_updated_38, p0_.margin_level AS margin_level_39, p0_.quantity_limit AS quantity_limit_40, p0_.availability_paused_for_product_model AS availability_paused_for_product_model_41, p0_.last_qty_calculated_for_marketplaces AS last_qty_calculated_for_marketplaces_42, p0_.calculated_qty_grade_new AS calculated_qty_grade_new_43, p0_.calculated_qty_grade_a AS calculated_qty_grade_a_44, p0_.calculated_qty_grade_b AS calculated_qty_grade_b_45, p0_.calculated_qty_grade_c AS calculated_qty_grade_c_46, p0_.calculated_qty_grade_d AS calculated_qty_grade_d_47, p0_.calculated_qty_date AS calculated_qty_date_48, p1_.id AS id_49, p1_.created AS created_50, p1_.updated AS updated_51, p1_.updated_by_time AS updated_by_time_52, p1_.published AS published_53, p1_.indexable AS indexable_54, p1_.social_share_image AS social_share_image_55, p1_.type AS type_56, p1_.badges AS badges_57, p1_.show_only_discounted AS show_only_discounted_58, p1_.show_only_flash_sales AS show_only_flash_sales_59, p1_.show_only_bazaar AS show_only_bazaar_60, p1_.include_bazaar AS include_bazaar_61, p1_.show_popular_products AS show_popular_products_62, p2_.id AS id_63, p2_.created AS created_64, p2_.updated AS updated_65, p2_.price AS price_66, p2_.suggested_price AS suggested_price_67, p2_.current_vat_price AS current_vat_price_68, p2_.discount AS discount_69, p2_.discounted AS discounted_70, p2_.active AS active_71, p2_.listed AS listed_72, p2_.orderable AS orderable_73, p2_.vat AS vat_74, p2_.warranty AS warranty_75, p2_.bazaar AS bazaar_76, p2_.best_seller AS best_seller_77, p2_.re_lenovo AS re_lenovo_78, p2_.hp_renew AS hp_renew_79, p2_.special_promotion AS special_promotion_80, p2_.detail AS detail_81, p2_.sale_start AS sale_start_82, p2_.sale_end AS sale_end_83, p2_.activation_date AS activation_date_84, p2_.discounted_date AS discounted_date_85, p2_.flash_sale_date AS flash_sale_date_86 FROM products p0_ LEFT JOIN products__metas p2_ ON p0_.id = p2_.product_id LEFT JOIN vendors v3_ ON p0_.vendor_id = v3_.id LEFT JOIN product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_products c5_ ON p0_.id = c5_.product_id LEFT JOIN pages_category p1_ ON p1_.id = c5_.category_page_id AND (p1_.id = 455) WHERE p0_.badges LIKE '%\"Notebook bundle\"%' AND p2_.discounted = 1 AND p0_.quality_status <> 9 AND p2_.domain_id = 1 AND p2_.price > 0 AND p0_.archived = 0 AND p2_.active = 1 AND p2_.listed = 1 AND (p0_.available > 0 AND NOT (p0_.out_of_stock_status = 4)) AND p2_.orderable = 1 ORDER BY p1_.id DESC) dctrn_result_inner ORDER BY available_25 DESC) dctrn_result LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.query AS query_4,
  t0.keyword AS keyword_5,
  t0.archived AS archived_6,
  t0.language_id AS language_id_7,
  t0.domain_id AS domain_id_8
FROM
  seo_url t0
WHERE
  t0.query = ?
  AND t0.language_id = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = 'category_id=' AND t0.language_id = 1 AND t0.archived = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.query AS query_4,
  t0.keyword AS keyword_5,
  t0.archived AS archived_6,
  t0.language_id AS language_id_7,
  t0.domain_id AS domain_id_8
FROM
  seo_url t0
WHERE
  t0.keyword = ?
  AND t0.language_id = ?
  AND t0.archived = ?
  AND (
    t0.domain_id IN (?, ?)
    OR t0.domain_id IS NULL
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.keyword = 'repasovane-notebooky' AND t0.language_id = 1 AND t0.archived = 0 AND (t0.domain_id IN (1, NULL) OR t0.domain_id IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.sort_index AS sort_index_4,
  t0.type AS type_5,
  t0.name AS name_6,
  t0.currency AS currency_7,
  t0.price_factor AS price_factor_8,
  t0.price_precision AS price_precision_9,
  t0.price_end AS price_end_10,
  t0.price_end2 AS price_end2_11,
  t0.price_end2_under AS price_end2_under_12,
  t0.vat AS vat_13,
  t0.warranty AS warranty_14,
  t0.url AS url_15,
  t0.title AS title_16,
  t0.short_title AS short_title_17,
  t0.ga_id AS ga_id_18,
  t0.blog_url AS blog_url_19,
  t0.facebook_url AS facebook_url_20,
  t0.twitter_url AS twitter_url_21,
  t0.youtube_url AS youtube_url_22,
  t0.gplus_url AS gplus_url_23,
  t0.livechat_username AS livechat_username_24,
  t0.javascripts AS javascripts_25,
  t0.language_id AS language_id_26,
  t0.company_id AS company_id_27,
  t0.default_sales_manager_id AS default_sales_manager_id_28
FROM
  domains t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.type AS type_5, t0.name AS name_6, t0.currency AS currency_7, t0.price_factor AS price_factor_8, t0.price_precision AS price_precision_9, t0.price_end AS price_end_10, t0.price_end2 AS price_end2_11, t0.price_end2_under AS price_end2_under_12, t0.vat AS vat_13, t0.warranty AS warranty_14, t0.url AS url_15, t0.title AS title_16, t0.short_title AS short_title_17, t0.ga_id AS ga_id_18, t0.blog_url AS blog_url_19, t0.facebook_url AS facebook_url_20, t0.twitter_url AS twitter_url_21, t0.youtube_url AS youtube_url_22, t0.gplus_url AS gplus_url_23, t0.livechat_username AS livechat_username_24, t0.javascripts AS javascripts_25, t0.language_id AS language_id_26, t0.company_id AS company_id_27, t0.default_sales_manager_id AS default_sales_manager_id_28 FROM domains t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.created AS created_1,
  d0_.updated AS updated_2,
  d0_.sort_index AS sort_index_3,
  d0_.type AS type_4,
  d0_.name AS name_5,
  d0_.currency AS currency_6,
  d0_.price_factor AS price_factor_7,
  d0_.price_precision AS price_precision_8,
  d0_.price_end AS price_end_9,
  d0_.price_end2 AS price_end2_10,
  d0_.price_end2_under AS price_end2_under_11,
  d0_.vat AS vat_12,
  d0_.warranty AS warranty_13,
  d0_.url AS url_14,
  d0_.title AS title_15,
  d0_.short_title AS short_title_16,
  d0_.ga_id AS ga_id_17,
  d0_.blog_url AS blog_url_18,
  d0_.facebook_url AS facebook_url_19,
  d0_.twitter_url AS twitter_url_20,
  d0_.youtube_url AS youtube_url_21,
  d0_.gplus_url AS gplus_url_22,
  d0_.livechat_username AS livechat_username_23,
  d0_.javascripts AS javascripts_24,
  l1_.id AS id_25,
  l1_.created AS created_26,
  l1_.updated AS updated_27,
  l1_.sort_index AS sort_index_28,
  l1_.code AS code_29,
  l1_.name AS name_30,
  t2_.id AS id_31,
  t2_.created AS created_32,
  t2_.updated AS updated_33,
  t2_.tr_key AS tr_key_34,
  t2_.value AS value_35,
  d0_.language_id AS language_id_36,
  d0_.company_id AS company_id_37,
  d0_.default_sales_manager_id AS default_sales_manager_id_38,
  t2_.language_id AS language_id_39
FROM
  domains d0_
  LEFT JOIN languages l1_ ON d0_.language_id = l1_.id
  LEFT JOIN translations t2_ ON l1_.id = t2_.language_id
WHERE
  d0_.id = ?

SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.sort_index AS sort_index_3, d0_.type AS type_4, d0_.name AS name_5, d0_.currency AS currency_6, d0_.price_factor AS price_factor_7, d0_.price_precision AS price_precision_8, d0_.price_end AS price_end_9, d0_.price_end2 AS price_end2_10, d0_.price_end2_under AS price_end2_under_11, d0_.vat AS vat_12, d0_.warranty AS warranty_13, d0_.url AS url_14, d0_.title AS title_15, d0_.short_title AS short_title_16, d0_.ga_id AS ga_id_17, d0_.blog_url AS blog_url_18, d0_.facebook_url AS facebook_url_19, d0_.twitter_url AS twitter_url_20, d0_.youtube_url AS youtube_url_21, d0_.gplus_url AS gplus_url_22, d0_.livechat_username AS livechat_username_23, d0_.javascripts AS javascripts_24, l1_.id AS id_25, l1_.created AS created_26, l1_.updated AS updated_27, l1_.sort_index AS sort_index_28, l1_.code AS code_29, l1_.name AS name_30, t2_.id AS id_31, t2_.created AS created_32, t2_.updated AS updated_33, t2_.tr_key AS tr_key_34, t2_.value AS value_35, d0_.language_id AS language_id_36, d0_.company_id AS company_id_37, d0_.default_sales_manager_id AS default_sales_manager_id_38, t2_.language_id AS language_id_39 FROM domains d0_ LEFT JOIN languages l1_ ON d0_.language_id = l1_.id LEFT JOIN translations t2_ ON l1_.id = t2_.language_id WHERE d0_.id = 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.query AS query_4,
  t0.keyword AS keyword_5,
  t0.archived AS archived_6,
  t0.language_id AS language_id_7,
  t0.domain_id AS domain_id_8
FROM
  seo_url t0
WHERE
  t0.query = ?
  AND t0.language_id = ?
  AND t0.domain_id = ?
  AND t0.archived = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.query AS query_4, t0.keyword AS keyword_5, t0.archived AS archived_6, t0.language_id AS language_id_7, t0.domain_id AS domain_id_8 FROM seo_url t0 WHERE t0.query = 'category_id=455' AND t0.language_id = 1 AND t0.domain_id = 1 AND t0.archived = 0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.published AS published_5,
  t0.indexable AS indexable_6,
  t0.social_share_image AS social_share_image_7,
  t0.type AS type_8,
  t0.badges AS badges_9,
  t0.show_only_discounted AS show_only_discounted_10,
  t0.show_only_flash_sales AS show_only_flash_sales_11,
  t0.show_only_bazaar AS show_only_bazaar_12,
  t0.include_bazaar AS include_bazaar_13,
  t0.show_popular_products AS show_popular_products_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.domain_id AS domain_id_17,
  t0.parent_category_id AS parent_category_id_18
FROM
  pages_category t0
WHERE
  t0.type = ?
  AND t0.published = ?
  AND t0.show_only_discounted = ?
  AND t0.show_only_flash_sales = ?
  AND t0.show_only_bazaar = ?
  AND t0.include_bazaar = ?
ORDER BY
  t0.updated DESC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.type = 1 AND t0.published = 1 AND t0.show_only_discounted = 0 AND t0.show_only_flash_sales = 0 AND t0.show_only_bazaar = 0 AND t0.include_bazaar = 0 ORDER BY t0.updated DESC;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.updated_by_time AS updated_by_time_4,
  t0.published AS published_5,
  t0.indexable AS indexable_6,
  t0.social_share_image AS social_share_image_7,
  t0.type AS type_8,
  t0.badges AS badges_9,
  t0.show_only_discounted AS show_only_discounted_10,
  t0.show_only_flash_sales AS show_only_flash_sales_11,
  t0.show_only_bazaar AS show_only_bazaar_12,
  t0.include_bazaar AS include_bazaar_13,
  t0.show_popular_products AS show_popular_products_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.domain_id AS domain_id_17,
  t0.parent_category_id AS parent_category_id_18
FROM
  pages_category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.updated_by_time AS updated_by_time_4, t0.published AS published_5, t0.indexable AS indexable_6, t0.social_share_image AS social_share_image_7, t0.type AS type_8, t0.badges AS badges_9, t0.show_only_discounted AS show_only_discounted_10, t0.show_only_flash_sales AS show_only_flash_sales_11, t0.show_only_bazaar AS show_only_bazaar_12, t0.include_bazaar AS include_bazaar_13, t0.show_popular_products AS show_popular_products_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.domain_id AS domain_id_17, t0.parent_category_id AS parent_category_id_18 FROM pages_category t0 WHERE t0.id = 455 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.sort_index AS sort_index_4,
  t0.name AS name_5,
  t0.priority AS priority_6,
  t0.base_manufacturer_id AS base_manufacturer_id_7
FROM
  vendors t0
  INNER JOIN category_pages_vendors ON t0.id = category_pages_vendors.vendor_id
WHERE
  category_pages_vendors.category_page_id = ?
ORDER BY
  t0.id DESC