Symfony Profiler

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 product_types p4_ ON p0_.type_id = p4_.id
  LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id
  LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id
  AND (p5_.id = ?)
  LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id
  LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id
  AND (p7_.id = ?)
WHERE
  (
    p7_.id = ?
    OR p5_.id IS NOT NULL
  )
  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 product_types p4_ ON p0_.type_id = p4_.id LEFT JOIN category_pages_product_types c6_ ON p4_.id = c6_.product_type_id LEFT JOIN pages_category p5_ ON p5_.id = c6_.category_page_id AND (p5_.id = 419) LEFT JOIN category_pages_products c8_ ON p0_.id = c8_.product_id LEFT JOIN pages_category p7_ ON p7_.id = c8_.category_page_id AND (p7_.id = 419) WHERE (p7_.id = 419 OR p5_.id IS NOT NULL) 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
  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 = 'komponenty' 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.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=447' 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.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=419' AND t0.language_id = 1 AND t0.domain_id = 1 AND t0.archived = 0 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.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
  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.sort_index AS sort_index_4,
  t0.code AS code_5,
  t0.name AS name_6
FROM
  languages 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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.id = 1 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.title AS title_5,
  t0.link AS link_6,
  t0.content AS content_7,
  t0.short_desc AS short_desc_8,
  t0.seo_title AS seo_title_9,
  t0.seo_desc AS seo_desc_10,
  t0.extra_seo_desc AS extra_seo_desc_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.language_id AS language_id_14,
  t0.category_page_id AS category_page_id_15,
  t0.blog_category_id AS blog_category_id_16,
  t0.static_page_id AS static_page_id_17
FROM
  pages_meta t0
WHERE
  t0.category_page_id = ?
ORDER BY
  t0.id ASC

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.title AS title_5, t0.link AS link_6, t0.content AS content_7, t0.short_desc AS short_desc_8, t0.seo_title AS seo_title_9, t0.seo_desc AS seo_desc_10, t0.extra_seo_desc AS extra_seo_desc_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.language_id AS language_id_14, t0.category_page_id AS category_page_id_15, t0.blog_category_id AS blog_category_id_16, t0.static_page_id AS static_page_id_17 FROM pages_meta t0 WHERE t0.category_page_id = 419 ORDER BY t0.id ASC;

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 = 419 LIMIT 1;

SELECT
  updated
FROM
  domain_navigation
WHERE
  domain_id = 1
ORDER BY
  updated DESC
LIMIT
  1

SELECT updated FROM domain_navigation WHERE domain_id = 1 ORDER BY updated DESC 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.code AS code_5,
  t0.name AS name_6
FROM
  languages t0
WHERE
  t0.code = ?
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.code AS code_5, t0.name AS name_6 FROM languages t0 WHERE t0.code = 'komponenty' 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 = ?
  AND t0.published = ?
  AND t0.type = ?
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 = 419 AND t0.published = 1 AND t0.type = 1 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.username AS username_5,
  t0.password AS password_6,
  t0.salt AS salt_7,
  t0.email AS email_8,
  t0.roles AS roles_9,
  t0.is_active AS is_active_10,
  t0.first_name AS first_name_11,
  t0.last_name AS last_name_12,
  t0.nick_name AS nick_name_13,
  t0.locale AS locale_14,
  t0.work_since AS work_since_15,
  t0.work_until AS work_until_16,
  t0.birthday AS birthday_17,
  t0.allowedDaysOff AS allowedDaysOff_18,
  t0.phone AS phone_19,
  t0.sales_manager AS sales_manager_20,
  t0.permissions AS permissions_21,
  t0.birthday_visibility AS birthday_visibility_22,
  t0.avatar AS avatar_23,
  t0.fingera_id AS fingera_id_24,
  t0.created_by AS created_by_25,
  t0.updated_by AS updated_by_26,
  t27.id AS id_28,
  t27.created AS created_29,
  t27.updated AS updated_30,
  t27.updated_by_time AS updated_by_time_31,
  t27.created_by AS created_by_32,
  t27.updated_by AS updated_by_33,
  t27.user_id AS user_id_34,
  t27.stock_position_id AS stock_position_id_35
FROM
  users t0
  LEFT JOIN users_stock_position t27 ON t27.user_id = t0.id
WHERE
  t0.id = ?

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.username AS username_5, t0.password AS password_6, t0.salt AS salt_7, t0.email AS email_8, t0.roles AS roles_9, t0.is_active AS is_active_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.nick_name AS nick_name_13, t0.locale AS locale_14, t0.work_since AS work_since_15, t0.work_until AS work_until_16, t0.birthday AS birthday_17, t0.allowedDaysOff AS allowedDaysOff_18, t0.phone AS phone_19, t0.sales_manager AS sales_manager_20, t0.permissions AS permissions_21, t0.birthday_visibility AS birthday_visibility_22, t0.avatar AS avatar_23, t0.fingera_id AS fingera_id_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26, t27.id AS id_28, t27.created AS created_29, t27.updated AS updated_30, t27.updated_by_time AS updated_by_time_31, t27.created_by AS created_by_32, t27.updated_by AS updated_by_33, t27.user_id AS user_id_34, t27.stock_position_id AS stock_position_id_35 FROM users t0 LEFT JOIN users_stock_position t27 ON t27.user_id = t0.id WHERE t0.id = 68;

SELECT
  d0_.id AS id_0,
  d0_.created AS created_1,
  d0_.updated AS updated_2,
  d0_.updated_by_time AS updated_by_time_3,
  d0_.type AS type_4,
  d0_.price AS price_5,
  d0_.free_ship_limit AS free_ship_limit_6,
  d0_.active_on_web AS active_on_web_7,
  d0_.sort_index AS sort_index_8,
  d0_.shipping_days AS shipping_days_9,
  d0_.free_shipping_product_types AS free_shipping_product_types_10,
  d0_.free_shipping_start_date AS free_shipping_start_date_11,
  d0_.free_shipping_end_date AS free_shipping_end_date_12,
  d0_.created_by AS created_by_13,
  d0_.updated_by AS updated_by_14,
  d0_.domain_id AS domain_id_15
FROM
  domain_shipping_types d0_
WHERE
  d0_.domain_id = ?
  AND d0_.active_on_web = 1
  AND d0_.price > 0

SELECT d0_.id AS id_0, d0_.created AS created_1, d0_.updated AS updated_2, d0_.updated_by_time AS updated_by_time_3, d0_.type AS type_4, d0_.price AS price_5, d0_.free_ship_limit AS free_ship_limit_6, d0_.active_on_web AS active_on_web_7, d0_.sort_index AS sort_index_8, d0_.shipping_days AS shipping_days_9, d0_.free_shipping_product_types AS free_shipping_product_types_10, d0_.free_shipping_start_date AS free_shipping_start_date_11, d0_.free_shipping_end_date AS free_shipping_end_date_12, d0_.created_by AS created_by_13, d0_.updated_by AS updated_by_14, d0_.domain_id AS domain_id_15 FROM domain_shipping_types d0_ WHERE d0_.domain_id = 1 AND d0_.active_on_web = 1 AND d0_.price > 0;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.sort_index AS sort_index_4,
  t0.title AS title_5,
  t0.code AS code_6,
  t0.scannable AS scannable_7,
  t0.priority AS priority_8,
  t0.average_weight AS average_weight_9,
  t0.archived AS archived_10
FROM
  product_types t0
  INNER JOIN category_pages_product_types ON t0.id = category_pages_product_types.product_type_id
WHERE
  category_pages_product_types.category_page_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.sort_index AS sort_index_4, t0.title AS title_5, t0.code AS code_6, t0.scannable AS scannable_7, t0.priority AS priority_8, t0.average_weight AS average_weight_9, t0.archived AS archived_10 FROM product_types t0 INNER JOIN category_pages_product_types ON t0.id = category_pages_product_types.product_type_id WHERE category_pages_product_types.category_page_id = 419 ORDER BY t0.id DESC;

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

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 = 419 ORDER BY t0.id 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 = ?

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 = 447;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.payment_method AS payment_method_4,
  t0.shipping_method AS shipping_method_5,
  t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_6,
  t0.message AS message_7,
  t0.coupon_code AS coupon_code_8,
  t0.active AS active_9,
  t0.abandoned_cart_email AS abandoned_cart_email_10,
  t0.domain_id AS domain_id_11,
  t0.customer_id AS customer_id_12,
  t0.billing_address_id AS billing_address_id_13,
  t0.shipping_address_id AS shipping_address_id_14
FROM
  baskets t0
WHERE
  t0.id IS NULL
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.payment_method AS payment_method_4, t0.shipping_method AS shipping_method_5, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_6, t0.message AS message_7, t0.coupon_code AS coupon_code_8, t0.active AS active_9, t0.abandoned_cart_email AS abandoned_cart_email_10, t0.domain_id AS domain_id_11, t0.customer_id AS customer_id_12, t0.billing_address_id AS billing_address_id_13, t0.shipping_address_id AS shipping_address_id_14 FROM baskets t0 WHERE t0.id IS NULL AND t0.active = 1 LIMIT 1;