Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.url AS url_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.show_deals AS show_deals_8,
  t0.sticky_spots AS sticky_spots_9,
  t0.report_emails AS report_emails_10,
  t0.tag_deal AS tag_deal_11,
  t0.tag_store AS tag_store_12,
  t0.color AS color_13,
  t0.code AS code_14,
  t0.hide_paid_placement AS hide_paid_placement_15,
  t0.hide_paid_placement_sticky AS hide_paid_placement_sticky_16,
  t0.token AS token_17,
  t0.weight AS weight_18,
  t0.image_cdn AS image_cdn_19,
  t0.fields AS fields_20,
  t0.append_price_newsletter_title AS append_price_newsletter_title_21,
  t0.custom_html AS custom_html_22,
  t0.use_default AS use_default_23
FROM
  site t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.url AS url_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.show_deals AS show_deals_8, t0.sticky_spots AS sticky_spots_9, t0.report_emails AS report_emails_10, t0.tag_deal AS tag_deal_11, t0.tag_store AS tag_store_12, t0.color AS color_13, t0.code AS code_14, t0.hide_paid_placement AS hide_paid_placement_15, t0.hide_paid_placement_sticky AS hide_paid_placement_sticky_16, t0.token AS token_17, t0.weight AS weight_18, t0.image_cdn AS image_cdn_19, t0.fields AS fields_20, t0.append_price_newsletter_title AS append_price_newsletter_title_21, t0.custom_html AS custom_html_22, t0.use_default AS use_default_23 FROM site t0 WHERE t0.token = 'QEJU*Yua_Ki9jEC7_Zbg4PnCpfRgKYvrnRhzqhvy_bnuac9-u8' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.all_direct_link AS all_direct_link_7,
  t0.coupon_text AS coupon_text_8,
  t0.recommend AS recommend_9,
  t0.did_you_know AS did_you_know_10,
  t0.website AS website_11,
  t0.phone AS phone_12,
  t0.email AS email_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.youtube AS youtube_16,
  t0.instagram AS instagram_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.status AS status_20,
  t0.shipping_costs AS shipping_costs_21,
  t0.return_policy AS return_policy_22,
  t0.network_id AS network_id_23
FROM
  store t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.description AS description_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.all_direct_link AS all_direct_link_7, t0.coupon_text AS coupon_text_8, t0.recommend AS recommend_9, t0.did_you_know AS did_you_know_10, t0.website AS website_11, t0.phone AS phone_12, t0.email AS email_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.youtube AS youtube_16, t0.instagram AS instagram_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.status AS status_20, t0.shipping_costs AS shipping_costs_21, t0.return_policy AS return_policy_22, t0.network_id AS network_id_23 FROM store t0 WHERE t0.slug = 'proozy' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.status AS status_6
FROM
  network t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6 FROM network t0 WHERE t0.id = 13;

SELECT
  count(r0_.id) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status IN (?)
  AND r0_.store_id = ?
ORDER BY
  r0_.id DESC

SELECT count(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.status IN ('Published') AND r0_.store_id = 1508 ORDER BY r0_.id DESC;

SELECT
  ROUND(
    AVG(r0_.rate),
    2
  ) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status IN (?)
  AND r0_.store_id = ?
ORDER BY
  r0_.id DESC

SELECT ROUND(AVG(r0_.rate), 2) AS sclr_0 FROM review r0_ WHERE r0_.status IN ('Published') AND r0_.store_id = 1508 ORDER BY r0_.id DESC;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.email AS email_2,
  r0_.comment AS comment_3,
  r0_.rate AS rate_4,
  r0_.rate_deals AS rate_deals_5,
  r0_.rate_other AS rate_other_6,
  r0_.status AS status_7,
  r0_.ip AS ip_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  r0_.store_id AS store_id_11
FROM
  review r0_
WHERE
  r0_.status IN (?)
  AND r0_.store_id = ?
  AND r0_.rate <> 0
  AND r0_.comment IS NOT NULL
  AND r0_.title <> ?
ORDER BY
  r0_.id DESC
LIMIT
  15

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.email AS email_2, r0_.comment AS comment_3, r0_.rate AS rate_4, r0_.rate_deals AS rate_deals_5, r0_.rate_other AS rate_other_6, r0_.status AS status_7, r0_.ip AS ip_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.store_id AS store_id_11 FROM review r0_ WHERE r0_.status IN ('Published') AND r0_.store_id = 1508 AND r0_.rate <> 0 AND r0_.comment IS NOT NULL AND r0_.title <> 'Anonymous' ORDER BY r0_.id DESC LIMIT 15;

SELECT
  count(r0_.id) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status IN (?, ?, ?, ?)
  AND r0_.store_id = ?
ORDER BY
  r0_.id DESC

SELECT count(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.status IN ('Published', 'Draft', 'Pending', 'Disabled') AND r0_.store_id = 1508 ORDER BY r0_.id DESC;

SELECT
  ROUND(
    AVG(r0_.rate),
    2
  ) AS sclr_0
FROM
  review r0_
WHERE
  r0_.status IN (?, ?, ?, ?)
  AND r0_.store_id = ?
ORDER BY
  r0_.id DESC

SELECT ROUND(AVG(r0_.rate), 2) AS sclr_0 FROM review r0_ WHERE r0_.status IN ('Published', 'Draft', 'Pending', 'Disabled') AND r0_.store_id = 1508 ORDER BY r0_.id DESC;

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.email AS email_2,
  r0_.comment AS comment_3,
  r0_.rate AS rate_4,
  r0_.rate_deals AS rate_deals_5,
  r0_.rate_other AS rate_other_6,
  r0_.status AS status_7,
  r0_.ip AS ip_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  r0_.store_id AS store_id_11
FROM
  review r0_
WHERE
  r0_.status IN (?, ?, ?, ?)
  AND r0_.store_id = ?
  AND r0_.rate <> 0
  AND r0_.comment IS NOT NULL
  AND r0_.title <> ?
ORDER BY
  r0_.id DESC
LIMIT
  15

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.email AS email_2, r0_.comment AS comment_3, r0_.rate AS rate_4, r0_.rate_deals AS rate_deals_5, r0_.rate_other AS rate_other_6, r0_.status AS status_7, r0_.ip AS ip_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.store_id AS store_id_11 FROM review r0_ WHERE r0_.status IN ('Published', 'Draft', 'Pending', 'Disabled') AND r0_.store_id = 1508 AND r0_.rate <> 0 AND r0_.comment IS NOT NULL AND r0_.title <> 'Anonymous' ORDER BY r0_.id DESC LIMIT 15;

SELECT
  count(d0_.id) AS sclr_0
FROM
  deal d0_
  INNER JOIN deal d1_ ON d0_.parent_id = d1_.id
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND d0_.sid_id = ?
  AND (
    d0_.skip_homepage <> 1
    OR d0_.skip_homepage IS NULL
  )
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC

SELECT count(d0_.id) AS sclr_0 FROM deal d0_ INNER JOIN deal d1_ ON d0_.parent_id = d1_.id WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND d0_.sid_id = 2 AND (d0_.skip_homepage <> 1 OR d0_.skip_homepage IS NULL) ORDER BY d0_.mark DESC, d0_.created_at DESC;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.slug AS slug_2,
  d0_.price AS price_3,
  d0_.price_old AS price_old_4,
  d0_.price_additional AS price_additional_5,
  d0_.merchant_revenue AS merchant_revenue_6,
  d0_.commission_earned AS commission_earned_7,
  d0_.description AS description_8,
  d0_.updates AS updates_9,
  d0_.features_list AS features_list_10,
  d0_.details AS details_11,
  d0_.coupon AS coupon_12,
  d0_.link AS link_13,
  d0_.sticky_from_at AS sticky_from_at_14,
  d0_.sticky_to_at AS sticky_to_at_15,
  d0_.newsletter_title AS newsletter_title_16,
  d0_.remove_button AS remove_button_17,
  d0_.disabled_report_deal AS disabled_report_deal_18,
  d0_.exclude_top_deals AS exclude_top_deals_19,
  d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20,
  d0_.sponsored AS sponsored_21,
  d0_.disabled_at AS disabled_at_22,
  d0_.status AS status_23,
  d0_.created_at AS created_at_24,
  d0_.updated_at AS updated_at_25,
  d0_.image AS image_26,
  d0_.expired AS expired_27,
  d0_.customer_enabled AS customer_enabled_28,
  d0_.old_id AS old_id_29,
  d0_.uid AS uid_30,
  d0_.mark AS mark_31,
  d0_.display AS display_32,
  d0_.hide_paid_placement AS hide_paid_placement_33,
  d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34,
  d0_.click AS click_35,
  d0_.view AS view_36,
  d0_.commission_total AS commission_total_37,
  d0_.weight AS weight_38,
  d0_.author_custom AS author_custom_39,
  d0_.brand AS brand_40,
  d0_.attachment_main AS attachment_main_41,
  d0_.email_only AS email_only_42,
  d0_.sponsored_from_at AS sponsored_from_at_43,
  d0_.sponsored_to_at AS sponsored_to_at_44,
  d0_.fields AS fields_45,
  d0_.api_price AS api_price_46,
  d0_.api_price_change_date AS api_price_change_date_47,
  d0_.api_stock_status AS api_stock_status_48,
  d0_.api_stock_status_change_date AS api_stock_status_change_date_49,
  d0_.api_ignore AS api_ignore_50,
  d0_.api_updated_at AS api_updated_at_51,
  d0_.paid_placement_type AS paid_placement_type_52,
  d0_.commission_type AS commission_type_53,
  d0_.append_price_newsletter_title AS append_price_newsletter_title_54,
  d0_.why_is_this_a_deal AS why_is_this_a_deal_55,
  d0_.how_to_redeem AS how_to_redeem_56,
  d0_.helpful_tips AS helpful_tips_57,
  d0_.skip_homepage AS skip_homepage_58,
  d0_.use_default AS use_default_59,
  d0_.qc AS qc_60,
  d0_.priority AS priority_61,
  d0_.qc_errors AS qc_errors_62,
  d0_.expired_check AS expired_check_63,
  d0_.expired_data AS expired_data_64,
  d0_.expired_count AS expired_count_65,
  d0_.note AS note_66,
  d0_.source_link AS source_link_67,
  d0_.info AS info_68,
  d0_.upc AS upc_69,
  d0_.shipping_costs AS shipping_costs_70,
  d0_.process_time AS process_time_71,
  d0_.store_id AS store_id_72,
  d0_.parent_id AS parent_id_73,
  d0_.author_id AS author_id_74,
  d0_.customer_id AS customer_id_75,
  d0_.sid_id AS sid_id_76,
  d0_.publisher_id AS publisher_id_77,
  d0_.attachment_email_id AS attachment_email_id_78,
  d0_.wiki_id AS wiki_id_79
FROM
  deal d0_
  INNER JOIN deal d1_ ON d0_.parent_id = d1_.id
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND d0_.sid_id = ?
  AND (
    d0_.skip_homepage <> 1
    OR d0_.skip_homepage IS NULL
  )
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC
LIMIT
  15 OFFSET 570

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.slug AS slug_2, d0_.price AS price_3, d0_.price_old AS price_old_4, d0_.price_additional AS price_additional_5, d0_.merchant_revenue AS merchant_revenue_6, d0_.commission_earned AS commission_earned_7, d0_.description AS description_8, d0_.updates AS updates_9, d0_.features_list AS features_list_10, d0_.details AS details_11, d0_.coupon AS coupon_12, d0_.link AS link_13, d0_.sticky_from_at AS sticky_from_at_14, d0_.sticky_to_at AS sticky_to_at_15, d0_.newsletter_title AS newsletter_title_16, d0_.remove_button AS remove_button_17, d0_.disabled_report_deal AS disabled_report_deal_18, d0_.exclude_top_deals AS exclude_top_deals_19, d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20, d0_.sponsored AS sponsored_21, d0_.disabled_at AS disabled_at_22, d0_.status AS status_23, d0_.created_at AS created_at_24, d0_.updated_at AS updated_at_25, d0_.image AS image_26, d0_.expired AS expired_27, d0_.customer_enabled AS customer_enabled_28, d0_.old_id AS old_id_29, d0_.uid AS uid_30, d0_.mark AS mark_31, d0_.display AS display_32, d0_.hide_paid_placement AS hide_paid_placement_33, d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34, d0_.click AS click_35, d0_.view AS view_36, d0_.commission_total AS commission_total_37, d0_.weight AS weight_38, d0_.author_custom AS author_custom_39, d0_.brand AS brand_40, d0_.attachment_main AS attachment_main_41, d0_.email_only AS email_only_42, d0_.sponsored_from_at AS sponsored_from_at_43, d0_.sponsored_to_at AS sponsored_to_at_44, d0_.fields AS fields_45, d0_.api_price AS api_price_46, d0_.api_price_change_date AS api_price_change_date_47, d0_.api_stock_status AS api_stock_status_48, d0_.api_stock_status_change_date AS api_stock_status_change_date_49, d0_.api_ignore AS api_ignore_50, d0_.api_updated_at AS api_updated_at_51, d0_.paid_placement_type AS paid_placement_type_52, d0_.commission_type AS commission_type_53, d0_.append_price_newsletter_title AS append_price_newsletter_title_54, d0_.why_is_this_a_deal AS why_is_this_a_deal_55, d0_.how_to_redeem AS how_to_redeem_56, d0_.helpful_tips AS helpful_tips_57, d0_.skip_homepage AS skip_homepage_58, d0_.use_default AS use_default_59, d0_.qc AS qc_60, d0_.priority AS priority_61, d0_.qc_errors AS qc_errors_62, d0_.expired_check AS expired_check_63, d0_.expired_data AS expired_data_64, d0_.expired_count AS expired_count_65, d0_.note AS note_66, d0_.source_link AS source_link_67, d0_.info AS info_68, d0_.upc AS upc_69, d0_.shipping_costs AS shipping_costs_70, d0_.process_time AS process_time_71, d0_.store_id AS store_id_72, d0_.parent_id AS parent_id_73, d0_.author_id AS author_id_74, d0_.customer_id AS customer_id_75, d0_.sid_id AS sid_id_76, d0_.publisher_id AS publisher_id_77, d0_.attachment_email_id AS attachment_email_id_78, d0_.wiki_id AS wiki_id_79 FROM deal d0_ INNER JOIN deal d1_ ON d0_.parent_id = d1_.id WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND d0_.sid_id = 2 AND (d0_.skip_homepage <> 1 OR d0_.skip_homepage IS NULL) ORDER BY d0_.mark DESC, d0_.created_at DESC LIMIT 15 OFFSET 570;

SELECT
  count(d0_.id) AS sclr_0
FROM
  deal d0_
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND (
    d0_.coupon IS NULL
    OR d0_.coupon = ?
  )
  AND d0_.sid_id = ?
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC

SELECT count(d0_.id) AS sclr_0 FROM deal d0_ WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND (d0_.coupon IS NULL OR d0_.coupon = '') AND d0_.sid_id = 2 ORDER BY d0_.mark DESC, d0_.created_at DESC;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.slug AS slug_2,
  d0_.price AS price_3,
  d0_.price_old AS price_old_4,
  d0_.price_additional AS price_additional_5,
  d0_.merchant_revenue AS merchant_revenue_6,
  d0_.commission_earned AS commission_earned_7,
  d0_.description AS description_8,
  d0_.updates AS updates_9,
  d0_.features_list AS features_list_10,
  d0_.details AS details_11,
  d0_.coupon AS coupon_12,
  d0_.link AS link_13,
  d0_.sticky_from_at AS sticky_from_at_14,
  d0_.sticky_to_at AS sticky_to_at_15,
  d0_.newsletter_title AS newsletter_title_16,
  d0_.remove_button AS remove_button_17,
  d0_.disabled_report_deal AS disabled_report_deal_18,
  d0_.exclude_top_deals AS exclude_top_deals_19,
  d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20,
  d0_.sponsored AS sponsored_21,
  d0_.disabled_at AS disabled_at_22,
  d0_.status AS status_23,
  d0_.created_at AS created_at_24,
  d0_.updated_at AS updated_at_25,
  d0_.image AS image_26,
  d0_.expired AS expired_27,
  d0_.customer_enabled AS customer_enabled_28,
  d0_.old_id AS old_id_29,
  d0_.uid AS uid_30,
  d0_.mark AS mark_31,
  d0_.display AS display_32,
  d0_.hide_paid_placement AS hide_paid_placement_33,
  d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34,
  d0_.click AS click_35,
  d0_.view AS view_36,
  d0_.commission_total AS commission_total_37,
  d0_.weight AS weight_38,
  d0_.author_custom AS author_custom_39,
  d0_.brand AS brand_40,
  d0_.attachment_main AS attachment_main_41,
  d0_.email_only AS email_only_42,
  d0_.sponsored_from_at AS sponsored_from_at_43,
  d0_.sponsored_to_at AS sponsored_to_at_44,
  d0_.fields AS fields_45,
  d0_.api_price AS api_price_46,
  d0_.api_price_change_date AS api_price_change_date_47,
  d0_.api_stock_status AS api_stock_status_48,
  d0_.api_stock_status_change_date AS api_stock_status_change_date_49,
  d0_.api_ignore AS api_ignore_50,
  d0_.api_updated_at AS api_updated_at_51,
  d0_.paid_placement_type AS paid_placement_type_52,
  d0_.commission_type AS commission_type_53,
  d0_.append_price_newsletter_title AS append_price_newsletter_title_54,
  d0_.why_is_this_a_deal AS why_is_this_a_deal_55,
  d0_.how_to_redeem AS how_to_redeem_56,
  d0_.helpful_tips AS helpful_tips_57,
  d0_.skip_homepage AS skip_homepage_58,
  d0_.use_default AS use_default_59,
  d0_.qc AS qc_60,
  d0_.priority AS priority_61,
  d0_.qc_errors AS qc_errors_62,
  d0_.expired_check AS expired_check_63,
  d0_.expired_data AS expired_data_64,
  d0_.expired_count AS expired_count_65,
  d0_.note AS note_66,
  d0_.source_link AS source_link_67,
  d0_.info AS info_68,
  d0_.upc AS upc_69,
  d0_.shipping_costs AS shipping_costs_70,
  d0_.process_time AS process_time_71,
  d0_.store_id AS store_id_72,
  d0_.parent_id AS parent_id_73,
  d0_.author_id AS author_id_74,
  d0_.customer_id AS customer_id_75,
  d0_.sid_id AS sid_id_76,
  d0_.publisher_id AS publisher_id_77,
  d0_.attachment_email_id AS attachment_email_id_78,
  d0_.wiki_id AS wiki_id_79
FROM
  deal d0_
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND (
    d0_.coupon IS NULL
    OR d0_.coupon = ?
  )
  AND d0_.sid_id = ?
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC
LIMIT
  15 OFFSET 570

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.slug AS slug_2, d0_.price AS price_3, d0_.price_old AS price_old_4, d0_.price_additional AS price_additional_5, d0_.merchant_revenue AS merchant_revenue_6, d0_.commission_earned AS commission_earned_7, d0_.description AS description_8, d0_.updates AS updates_9, d0_.features_list AS features_list_10, d0_.details AS details_11, d0_.coupon AS coupon_12, d0_.link AS link_13, d0_.sticky_from_at AS sticky_from_at_14, d0_.sticky_to_at AS sticky_to_at_15, d0_.newsletter_title AS newsletter_title_16, d0_.remove_button AS remove_button_17, d0_.disabled_report_deal AS disabled_report_deal_18, d0_.exclude_top_deals AS exclude_top_deals_19, d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20, d0_.sponsored AS sponsored_21, d0_.disabled_at AS disabled_at_22, d0_.status AS status_23, d0_.created_at AS created_at_24, d0_.updated_at AS updated_at_25, d0_.image AS image_26, d0_.expired AS expired_27, d0_.customer_enabled AS customer_enabled_28, d0_.old_id AS old_id_29, d0_.uid AS uid_30, d0_.mark AS mark_31, d0_.display AS display_32, d0_.hide_paid_placement AS hide_paid_placement_33, d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34, d0_.click AS click_35, d0_.view AS view_36, d0_.commission_total AS commission_total_37, d0_.weight AS weight_38, d0_.author_custom AS author_custom_39, d0_.brand AS brand_40, d0_.attachment_main AS attachment_main_41, d0_.email_only AS email_only_42, d0_.sponsored_from_at AS sponsored_from_at_43, d0_.sponsored_to_at AS sponsored_to_at_44, d0_.fields AS fields_45, d0_.api_price AS api_price_46, d0_.api_price_change_date AS api_price_change_date_47, d0_.api_stock_status AS api_stock_status_48, d0_.api_stock_status_change_date AS api_stock_status_change_date_49, d0_.api_ignore AS api_ignore_50, d0_.api_updated_at AS api_updated_at_51, d0_.paid_placement_type AS paid_placement_type_52, d0_.commission_type AS commission_type_53, d0_.append_price_newsletter_title AS append_price_newsletter_title_54, d0_.why_is_this_a_deal AS why_is_this_a_deal_55, d0_.how_to_redeem AS how_to_redeem_56, d0_.helpful_tips AS helpful_tips_57, d0_.skip_homepage AS skip_homepage_58, d0_.use_default AS use_default_59, d0_.qc AS qc_60, d0_.priority AS priority_61, d0_.qc_errors AS qc_errors_62, d0_.expired_check AS expired_check_63, d0_.expired_data AS expired_data_64, d0_.expired_count AS expired_count_65, d0_.note AS note_66, d0_.source_link AS source_link_67, d0_.info AS info_68, d0_.upc AS upc_69, d0_.shipping_costs AS shipping_costs_70, d0_.process_time AS process_time_71, d0_.store_id AS store_id_72, d0_.parent_id AS parent_id_73, d0_.author_id AS author_id_74, d0_.customer_id AS customer_id_75, d0_.sid_id AS sid_id_76, d0_.publisher_id AS publisher_id_77, d0_.attachment_email_id AS attachment_email_id_78, d0_.wiki_id AS wiki_id_79 FROM deal d0_ WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND (d0_.coupon IS NULL OR d0_.coupon = '') AND d0_.sid_id = 2 ORDER BY d0_.mark DESC, d0_.created_at DESC LIMIT 15 OFFSET 570;

SELECT
  count(d0_.id) AS sclr_0
FROM
  deal d0_
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND (
    d0_.coupon IS NOT NULL
    AND d0_.coupon <> ?
  )
  AND d0_.sid_id = ?
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC

SELECT count(d0_.id) AS sclr_0 FROM deal d0_ WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND (d0_.coupon IS NOT NULL AND d0_.coupon <> '') AND d0_.sid_id = 2 ORDER BY d0_.mark DESC, d0_.created_at DESC;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.slug AS slug_2,
  d0_.price AS price_3,
  d0_.price_old AS price_old_4,
  d0_.price_additional AS price_additional_5,
  d0_.merchant_revenue AS merchant_revenue_6,
  d0_.commission_earned AS commission_earned_7,
  d0_.description AS description_8,
  d0_.updates AS updates_9,
  d0_.features_list AS features_list_10,
  d0_.details AS details_11,
  d0_.coupon AS coupon_12,
  d0_.link AS link_13,
  d0_.sticky_from_at AS sticky_from_at_14,
  d0_.sticky_to_at AS sticky_to_at_15,
  d0_.newsletter_title AS newsletter_title_16,
  d0_.remove_button AS remove_button_17,
  d0_.disabled_report_deal AS disabled_report_deal_18,
  d0_.exclude_top_deals AS exclude_top_deals_19,
  d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20,
  d0_.sponsored AS sponsored_21,
  d0_.disabled_at AS disabled_at_22,
  d0_.status AS status_23,
  d0_.created_at AS created_at_24,
  d0_.updated_at AS updated_at_25,
  d0_.image AS image_26,
  d0_.expired AS expired_27,
  d0_.customer_enabled AS customer_enabled_28,
  d0_.old_id AS old_id_29,
  d0_.uid AS uid_30,
  d0_.mark AS mark_31,
  d0_.display AS display_32,
  d0_.hide_paid_placement AS hide_paid_placement_33,
  d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34,
  d0_.click AS click_35,
  d0_.view AS view_36,
  d0_.commission_total AS commission_total_37,
  d0_.weight AS weight_38,
  d0_.author_custom AS author_custom_39,
  d0_.brand AS brand_40,
  d0_.attachment_main AS attachment_main_41,
  d0_.email_only AS email_only_42,
  d0_.sponsored_from_at AS sponsored_from_at_43,
  d0_.sponsored_to_at AS sponsored_to_at_44,
  d0_.fields AS fields_45,
  d0_.api_price AS api_price_46,
  d0_.api_price_change_date AS api_price_change_date_47,
  d0_.api_stock_status AS api_stock_status_48,
  d0_.api_stock_status_change_date AS api_stock_status_change_date_49,
  d0_.api_ignore AS api_ignore_50,
  d0_.api_updated_at AS api_updated_at_51,
  d0_.paid_placement_type AS paid_placement_type_52,
  d0_.commission_type AS commission_type_53,
  d0_.append_price_newsletter_title AS append_price_newsletter_title_54,
  d0_.why_is_this_a_deal AS why_is_this_a_deal_55,
  d0_.how_to_redeem AS how_to_redeem_56,
  d0_.helpful_tips AS helpful_tips_57,
  d0_.skip_homepage AS skip_homepage_58,
  d0_.use_default AS use_default_59,
  d0_.qc AS qc_60,
  d0_.priority AS priority_61,
  d0_.qc_errors AS qc_errors_62,
  d0_.expired_check AS expired_check_63,
  d0_.expired_data AS expired_data_64,
  d0_.expired_count AS expired_count_65,
  d0_.note AS note_66,
  d0_.source_link AS source_link_67,
  d0_.info AS info_68,
  d0_.upc AS upc_69,
  d0_.shipping_costs AS shipping_costs_70,
  d0_.process_time AS process_time_71,
  d0_.store_id AS store_id_72,
  d0_.parent_id AS parent_id_73,
  d0_.author_id AS author_id_74,
  d0_.customer_id AS customer_id_75,
  d0_.sid_id AS sid_id_76,
  d0_.publisher_id AS publisher_id_77,
  d0_.attachment_email_id AS attachment_email_id_78,
  d0_.wiki_id AS wiki_id_79
FROM
  deal d0_
WHERE
  d0_.status IN (?)
  AND d0_.parent_id IS NOT NULL
  AND d0_.store_id = ?
  AND (
    d0_.coupon IS NOT NULL
    AND d0_.coupon <> ?
  )
  AND d0_.sid_id = ?
ORDER BY
  d0_.mark DESC,
  d0_.created_at DESC
LIMIT
  15

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.slug AS slug_2, d0_.price AS price_3, d0_.price_old AS price_old_4, d0_.price_additional AS price_additional_5, d0_.merchant_revenue AS merchant_revenue_6, d0_.commission_earned AS commission_earned_7, d0_.description AS description_8, d0_.updates AS updates_9, d0_.features_list AS features_list_10, d0_.details AS details_11, d0_.coupon AS coupon_12, d0_.link AS link_13, d0_.sticky_from_at AS sticky_from_at_14, d0_.sticky_to_at AS sticky_to_at_15, d0_.newsletter_title AS newsletter_title_16, d0_.remove_button AS remove_button_17, d0_.disabled_report_deal AS disabled_report_deal_18, d0_.exclude_top_deals AS exclude_top_deals_19, d0_.enable_direct_link_newsletter AS enable_direct_link_newsletter_20, d0_.sponsored AS sponsored_21, d0_.disabled_at AS disabled_at_22, d0_.status AS status_23, d0_.created_at AS created_at_24, d0_.updated_at AS updated_at_25, d0_.image AS image_26, d0_.expired AS expired_27, d0_.customer_enabled AS customer_enabled_28, d0_.old_id AS old_id_29, d0_.uid AS uid_30, d0_.mark AS mark_31, d0_.display AS display_32, d0_.hide_paid_placement AS hide_paid_placement_33, d0_.hide_paid_placement_sticky AS hide_paid_placement_sticky_34, d0_.click AS click_35, d0_.view AS view_36, d0_.commission_total AS commission_total_37, d0_.weight AS weight_38, d0_.author_custom AS author_custom_39, d0_.brand AS brand_40, d0_.attachment_main AS attachment_main_41, d0_.email_only AS email_only_42, d0_.sponsored_from_at AS sponsored_from_at_43, d0_.sponsored_to_at AS sponsored_to_at_44, d0_.fields AS fields_45, d0_.api_price AS api_price_46, d0_.api_price_change_date AS api_price_change_date_47, d0_.api_stock_status AS api_stock_status_48, d0_.api_stock_status_change_date AS api_stock_status_change_date_49, d0_.api_ignore AS api_ignore_50, d0_.api_updated_at AS api_updated_at_51, d0_.paid_placement_type AS paid_placement_type_52, d0_.commission_type AS commission_type_53, d0_.append_price_newsletter_title AS append_price_newsletter_title_54, d0_.why_is_this_a_deal AS why_is_this_a_deal_55, d0_.how_to_redeem AS how_to_redeem_56, d0_.helpful_tips AS helpful_tips_57, d0_.skip_homepage AS skip_homepage_58, d0_.use_default AS use_default_59, d0_.qc AS qc_60, d0_.priority AS priority_61, d0_.qc_errors AS qc_errors_62, d0_.expired_check AS expired_check_63, d0_.expired_data AS expired_data_64, d0_.expired_count AS expired_count_65, d0_.note AS note_66, d0_.source_link AS source_link_67, d0_.info AS info_68, d0_.upc AS upc_69, d0_.shipping_costs AS shipping_costs_70, d0_.process_time AS process_time_71, d0_.store_id AS store_id_72, d0_.parent_id AS parent_id_73, d0_.author_id AS author_id_74, d0_.customer_id AS customer_id_75, d0_.sid_id AS sid_id_76, d0_.publisher_id AS publisher_id_77, d0_.attachment_email_id AS attachment_email_id_78, d0_.wiki_id AS wiki_id_79 FROM deal d0_ WHERE d0_.status IN ('published') AND d0_.parent_id IS NOT NULL AND d0_.store_id = 1508 AND (d0_.coupon IS NOT NULL AND d0_.coupon <> '') AND d0_.sid_id = 2 ORDER BY d0_.mark DESC, d0_.created_at DESC LIMIT 15;