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 = 'blog_id=86' 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.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=259' AND t0.language_id = 1 AND t0.domain_id = 1 LIMIT 1;

SELECT
  DISTINCT r0_.id AS id_0,
  r0_.created AS created_1,
  r0_.updated AS updated_2,
  r0_.updated_by_time AS updated_by_time_3,
  r0_.type AS type_4,
  r0_.name AS name_5,
  r0_.text AS text_6,
  r0_.stars AS stars_7,
  r0_.approved AS approved_8,
  r0_.show_at_homepage AS show_at_homepage_9,
  r0_.created_by AS created_by_10,
  r0_.updated_by AS updated_by_11,
  r0_.language_id AS language_id_12,
  r0_.product_id AS product_id_13,
  r0_.customer_id AS customer_id_14,
  r0_.order_id AS order_id_15
FROM
  reviews r0_
  LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?
  AND r1_.id IS NOT NULL
  AND r1_.approved = 1
ORDER BY
  r0_.created DESC
LIMIT
  5

SELECT DISTINCT r0_.id AS id_0, r0_.created AS created_1, r0_.updated AS updated_2, r0_.updated_by_time AS updated_by_time_3, r0_.type AS type_4, r0_.name AS name_5, r0_.text AS text_6, r0_.stars AS stars_7, r0_.approved AS approved_8, r0_.show_at_homepage AS show_at_homepage_9, r0_.created_by AS created_by_10, r0_.updated_by AS updated_by_11, r0_.language_id AS language_id_12, r0_.product_id AS product_id_13, r0_.customer_id AS customer_id_14, r0_.order_id AS order_id_15 FROM reviews r0_ LEFT JOIN review_survey_media r1_ ON r0_.id = r1_.review_id WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 1 AND r1_.id IS NOT NULL AND r1_.approved = 1 ORDER BY r0_.created DESC LIMIT 5;

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 = 86 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.cover_image AS cover_image_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.domain_id AS domain_id_11,
  t0.category_page_id AS category_page_id_12
FROM
  pages_blog 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.cover_image AS cover_image_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.domain_id AS domain_id_11, t0.category_page_id AS category_page_id_12 FROM pages_blog t0 WHERE t0.id = 8;

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,
          t2_.id AS id_19,
          t2_.created AS created_20,
          t2_.updated AS updated_21,
          t2_.name AS name_22,
          t2_.slug AS slug_23
        FROM
          pages_blog p0_
          LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id
          INNER JOIN pages_blog_tags p3_ ON p0_.id = p3_.blog_page_id
          INNER JOIN tag t2_ ON t2_.id = p3_.tag_id
        WHERE
          p0_.published = ?
          AND p1_.language_id = ?
          AND p0_.domain_id = ?
          AND t2_.slug = ?
        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, t2_.id AS id_19, t2_.created AS created_20, t2_.updated AS updated_21, t2_.name AS name_22, t2_.slug AS slug_23 FROM pages_blog p0_ LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id INNER JOIN pages_blog_tags p3_ ON p0_.id = p3_.blog_page_id INNER JOIN tag t2_ ON t2_.id = p3_.tag_id WHERE p0_.published = 1 AND p1_.language_id = 1 AND p0_.domain_id = 1 AND t2_.slug = 'business-class' ORDER BY p1_.id ASC) dctrn_result_inner ORDER BY created_1 DESC) dctrn_result LIMIT 12;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  reviews r0_
WHERE
  r0_.language_id IN (?, ?)
  AND r0_.type = ?
  AND r0_.approved = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM reviews r0_ WHERE r0_.language_id IN (1, 3) AND r0_.type = 2 AND r0_.approved = 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.status AS status_5,
  t0.payment_status AS payment_status_6,
  t0.invoice_code AS invoice_code_7,
  t0.payment_type AS payment_type_8,
  t0.payment_price AS payment_price_9,
  t0.shipping_type AS shipping_type_10,
  t0.shipping_price AS shipping_price_11,
  t0.billing_first_name AS billing_first_name_12,
  t0.billing_last_name AS billing_last_name_13,
  t0.billing_business_name AS billing_business_name_14,
  t0.billing_street AS billing_street_15,
  t0.billing_city AS billing_city_16,
  t0.billing_zip AS billing_zip_17,
  t0.billing_country AS billing_country_18,
  t0.billing_business_id AS billing_business_id_19,
  t0.billing_tax_id AS billing_tax_id_20,
  t0.billing_vat_id AS billing_vat_id_21,
  t0.billing_email AS billing_email_22,
  t0.billing_phone_number AS billing_phone_number_23,
  t0.shipping_first_name AS shipping_first_name_24,
  t0.shipping_last_name AS shipping_last_name_25,
  t0.shipping_business_name AS shipping_business_name_26,
  t0.shipping_street AS shipping_street_27,
  t0.shipping_city AS shipping_city_28,
  t0.shipping_zip AS shipping_zip_29,
  t0.shipping_country AS shipping_country_30,
  t0.shipping_email AS shipping_email_31,
  t0.shipping_phone_number AS shipping_phone_number_32,
  t0.message AS message_33,
  t0.coupon_code AS coupon_code_34,
  t0.ship_date AS ship_date_35,
  t0.planned_ship_date AS planned_ship_date_36,
  t0.delivery_date AS delivery_date_37,
  t0.box_count AS box_count_38,
  t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39,
  t0.full_price AS full_price_40,
  t0.presta_order_code AS presta_order_code_41,
  t0.external_order_source AS external_order_source_42,
  t0.external_order_code AS external_order_code_43,
  t0.message_done AS message_done_44,
  t0.message_done_time AS message_done_time_45,
  t0.force_free_shipping AS force_free_shipping_46,
  t0.warranty AS warranty_47,
  t0.created_by_type AS created_by_type_48,
  t0.archived AS archived_49,
  t0.discount AS discount_50,
  t0.tracking_url AS tracking_url_51,
  t0.parcelNumber AS parcelNumber_52,
  t0.dhlShipmentNumber AS dhlShipmentNumber_53,
  t0.parcelStatus AS parcelStatus_54,
  t0.priority AS priority_55,
  t0.base_order_id AS base_order_id_56,
  t0.vat AS vat_57,
  t0.created_by AS created_by_58,
  t0.updated_by AS updated_by_59,
  t0.domain_id AS domain_id_60,
  t0.customer_id AS customer_id_61,
  t0.message_done_by AS message_done_by_62
FROM
  orders 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.status AS status_5, t0.payment_status AS payment_status_6, t0.invoice_code AS invoice_code_7, t0.payment_type AS payment_type_8, t0.payment_price AS payment_price_9, t0.shipping_type AS shipping_type_10, t0.shipping_price AS shipping_price_11, t0.billing_first_name AS billing_first_name_12, t0.billing_last_name AS billing_last_name_13, t0.billing_business_name AS billing_business_name_14, t0.billing_street AS billing_street_15, t0.billing_city AS billing_city_16, t0.billing_zip AS billing_zip_17, t0.billing_country AS billing_country_18, t0.billing_business_id AS billing_business_id_19, t0.billing_tax_id AS billing_tax_id_20, t0.billing_vat_id AS billing_vat_id_21, t0.billing_email AS billing_email_22, t0.billing_phone_number AS billing_phone_number_23, t0.shipping_first_name AS shipping_first_name_24, t0.shipping_last_name AS shipping_last_name_25, t0.shipping_business_name AS shipping_business_name_26, t0.shipping_street AS shipping_street_27, t0.shipping_city AS shipping_city_28, t0.shipping_zip AS shipping_zip_29, t0.shipping_country AS shipping_country_30, t0.shipping_email AS shipping_email_31, t0.shipping_phone_number AS shipping_phone_number_32, t0.message AS message_33, t0.coupon_code AS coupon_code_34, t0.ship_date AS ship_date_35, t0.planned_ship_date AS planned_ship_date_36, t0.delivery_date AS delivery_date_37, t0.box_count AS box_count_38, t0.useBillingAddressAsShippingAddress AS useBillingAddressAsShippingAddress_39, t0.full_price AS full_price_40, t0.presta_order_code AS presta_order_code_41, t0.external_order_source AS external_order_source_42, t0.external_order_code AS external_order_code_43, t0.message_done AS message_done_44, t0.message_done_time AS message_done_time_45, t0.force_free_shipping AS force_free_shipping_46, t0.warranty AS warranty_47, t0.created_by_type AS created_by_type_48, t0.archived AS archived_49, t0.discount AS discount_50, t0.tracking_url AS tracking_url_51, t0.parcelNumber AS parcelNumber_52, t0.dhlShipmentNumber AS dhlShipmentNumber_53, t0.parcelStatus AS parcelStatus_54, t0.priority AS priority_55, t0.base_order_id AS base_order_id_56, t0.vat AS vat_57, t0.created_by AS created_by_58, t0.updated_by AS updated_by_59, t0.domain_id AS domain_id_60, t0.customer_id AS customer_id_61, t0.message_done_by AS message_done_by_62 FROM orders t0 WHERE t0.id = 202464144;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.directory AS directory_4,
  t0.filename AS filename_5,
  t0.mime_type AS mime_type_6,
  t0.survey_question_id AS survey_question_id_7,
  t0.order_id AS order_id_8,
  t0.domain_id AS domain_id_9
FROM
  survey_medias t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.directory AS directory_4, t0.filename AS filename_5, t0.mime_type AS mime_type_6, t0.survey_question_id AS survey_question_id_7, t0.order_id AS order_id_8, t0.domain_id AS domain_id_9 FROM survey_medias t0 WHERE t0.id = 3062;

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

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  pages_blog p0_
  LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id
  INNER JOIN pages_blog_tags p3_ ON p0_.id = p3_.blog_page_id
  INNER JOIN tag t2_ ON t2_.id = p3_.tag_id
WHERE
  p0_.published = ?
  AND p1_.language_id = ?
  AND p0_.domain_id = ?
  AND t2_.slug = ?

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM pages_blog p0_ LEFT JOIN pages_meta p1_ ON p0_.id = p1_.blog_category_id INNER JOIN pages_blog_tags p3_ ON p0_.id = p3_.blog_page_id INNER JOIN tag t2_ ON t2_.id = p3_.tag_id WHERE p0_.published = 1 AND p1_.language_id = 1 AND p0_.domain_id = 1 AND t2_.slug = 'business-class';

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.approved AS approved_5,
  t0.cloudflare_id AS cloudflare_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.review_id AS review_id_9,
  t0.survey_media_id AS survey_media_id_10
FROM
  review_survey_media t0
WHERE
  t0.review_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.approved AS approved_5, t0.cloudflare_id AS cloudflare_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.review_id AS review_id_9, t0.survey_media_id AS survey_media_id_10 FROM review_survey_media t0 WHERE t0.review_id = 7949;

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
  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.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 = 56;

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