Symfony Profiler

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=261' 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.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 = ?
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 = 'recenzie' AND t0.language_id = 1 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 = ?
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=261' AND t0.language_id = 1 AND t0.domain_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.blog_category_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.blog_category_id = 307 ORDER BY t0.id ASC;

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.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.domain_id = ?
  AND t0.published = ?
  AND t0.type = ?

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.domain_id = 1 AND t0.published = 1 AND t0.type = 2;

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 = 261 ORDER BY t0.id ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_1
    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_.published AS published_4,
          p0_.indexable AS indexable_5,
          p0_.social_share_image AS social_share_image_6,
          p0_.cover_image AS cover_image_7,
          p1_.id AS id_8,
          p1_.created AS created_9,
          p1_.updated AS updated_10,
          p1_.updated_by_time AS updated_by_time_11,
          p1_.title AS title_12,
          p1_.link AS link_13,
          p1_.content AS content_14,
          p1_.short_desc AS short_desc_15,
          p1_.seo_title AS seo_title_16,
          p1_.seo_desc AS seo_desc_17,
          p1_.extra_seo_desc AS extra_seo_desc_18
        FROM
          pages_blog p0_
          LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id
        WHERE
          p0_.published = ?
          AND p1_.language_id = ?
          AND p0_.category_page_id = ?
          AND p0_.domain_id = ?
        ORDER BY
          p1_.id ASC
      ) dctrn_result_inner
    ORDER BY
      created_1 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_1 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_.published AS published_4, p0_.indexable AS indexable_5, p0_.social_share_image AS social_share_image_6, p0_.cover_image AS cover_image_7, p1_.id AS id_8, p1_.created AS created_9, p1_.updated AS updated_10, p1_.updated_by_time AS updated_by_time_11, p1_.title AS title_12, p1_.link AS link_13, p1_.content AS content_14, p1_.short_desc AS short_desc_15, p1_.seo_title AS seo_title_16, p1_.seo_desc AS seo_desc_17, p1_.extra_seo_desc AS extra_seo_desc_18 FROM pages_blog p0_ LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id WHERE p0_.published = 1 AND p1_.language_id = 1 AND p0_.category_page_id = 261 AND p0_.domain_id = 1 ORDER BY p1_.id ASC) dctrn_result_inner ORDER BY created_1 DESC) dctrn_result LIMIT 12;

SELECT
  t.name,
  t.slug,
  COUNT(DISTINCT bp.blog_page_id) AS total
FROM
  pages_blog_tags AS bp
  JOIN tag AS t ON t.id = bp.tag_id
WHERE
  t.language_id = ?
GROUP BY
  t.name

SELECT t.name, t.slug, COUNT(DISTINCT bp.blog_page_id ) AS total FROM pages_blog_tags AS bp JOIN tag AS t ON t.id = bp.tag_id WHERE t.language_id = 1 GROUP BY t.name;

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

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
  COUNT(*)
FROM
  pages_blog t0
WHERE
  t0.category_page_id = ?

SELECT COUNT(*) FROM pages_blog t0 WHERE t0.category_page_id = 3;

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;

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 = '261' AND t0.published = 1 AND t0.type = 2 LIMIT 1;

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
  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_.published AS published_4,
  p0_.indexable AS indexable_5,
  p0_.social_share_image AS social_share_image_6,
  p0_.cover_image AS cover_image_7,
  p0_.created_by AS created_by_8,
  p0_.updated_by AS updated_by_9,
  p0_.domain_id AS domain_id_10,
  p0_.category_page_id AS category_page_id_11
FROM
  pages_blog p0_
  LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id
WHERE
  p0_.published = ?
  AND p1_.language_id = ?
  AND p0_.category_page_id = ?
  AND p0_.domain_id = ?
  AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  p0_.created DESC

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_.published AS published_4, p0_.indexable AS indexable_5, p0_.social_share_image AS social_share_image_6, p0_.cover_image AS cover_image_7, p0_.created_by AS created_by_8, p0_.updated_by AS updated_by_9, p0_.domain_id AS domain_id_10, p0_.category_page_id AS category_page_id_11 FROM pages_blog p0_ LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id WHERE p0_.published = 1 AND p1_.language_id = 1 AND p0_.category_page_id = 261 AND p0_.domain_id = 1 AND p0_.id IN (307, 299, 298, 297, 285, 273, 271, 266, 262, 258, 255, 246) ORDER BY p0_.created 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.color AS color_5,
  t0.message AS message_6,
  t0.startDate AS startDate_7,
  t0.endDate AS endDate_8,
  t0.enabled AS enabled_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.domain_id AS domain_id_12,
  t0.domain_navigation_id AS domain_navigation_id_13
FROM
  nanobar t0
WHERE
  t0.domain_id = ?
  AND t0.domain_navigation_id IS NULL
  AND t0.enabled = ?

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.color AS color_5, t0.message AS message_6, t0.startDate AS startDate_7, t0.endDate AS endDate_8, t0.enabled AS enabled_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.domain_id AS domain_id_12, t0.domain_navigation_id AS domain_navigation_id_13 FROM nanobar t0 WHERE t0.domain_id = 1 AND t0.domain_navigation_id IS NULL AND t0.enabled = 1;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  pages_blog p0_
  LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id
WHERE
  p0_.published = ?
  AND p1_.language_id = ?
  AND p0_.category_page_id = ?
  AND p0_.domain_id = ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM pages_blog p0_ LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id WHERE p0_.published = 1 AND p1_.language_id = 1 AND p0_.category_page_id = 261 AND p0_.domain_id = 1;