Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.cover_image AS cover_image_3,
  s0_.url AS url_4,
  s0_.cashback AS cashback_5,
  s0_.featured AS featured_6,
  s0_.offline AS offline_7,
  s0_.status AS status_8,
  s0_.channel AS channel_9,
  s0_.ext_mapping AS ext_mapping_10,
  s0_.insert_date AS insert_date_11,
  COUNT(c1_.id) AS sclr_12,
  MAX(
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_13
FROM
  stores s0_
  INNER JOIN countries_lnk c3_ ON (
    c3_.entity_type = 1
    AND c3_.entity_id = s0_.id
    AND c3_.country = ?
  )
  LEFT JOIN coupons c1_ ON (
    c1_.store_id = s0_.id
    AND c1_.status = 1
  )
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND (
      f2_.user_id = ?
      OR (
        f2_.user_id IS NULL
        AND f2_.client_ip = ?
      )
    )
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?
  AND s0_.cashback IS NOT NULL
GROUP BY
  s0_.id
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.cover_image AS cover_image_3, s0_.url AS url_4, s0_.cashback AS cashback_5, s0_.featured AS featured_6, s0_.offline AS offline_7, s0_.status AS status_8, s0_.channel AS channel_9, s0_.ext_mapping AS ext_mapping_10, s0_.insert_date AS insert_date_11, COUNT(c1_.id) AS sclr_12, MAX(CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_13 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = '1') LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id AND c1_.status = 1) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND (f2_.user_id = NULL OR (f2_.user_id IS NULL AND f2_.client_ip = ''))) WHERE s0_.status = 1 AND s0_.featured = 1 AND s0_.cashback IS NOT NULL GROUP BY s0_.id LIMIT 10;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.trans AS trans_2,
  c0_.translate_id AS translate_id_3,
  c0_.parent AS parent_4,
  c0_.icon AS icon_5,
  c0_.image AS image_6,
  c0_.config AS config_7,
  c0_.visible AS visible_8,
  c0_.insert_date AS insert_date_9
FROM
  categories c0_
WHERE
  c0_.visible = ?
  AND c0_.parent IS NULL
LIMIT
  50

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.trans AS trans_2, c0_.translate_id AS translate_id_3, c0_.parent AS parent_4, c0_.icon AS icon_5, c0_.image AS image_6, c0_.config AS config_7, c0_.visible AS visible_8, c0_.insert_date AS insert_date_9 FROM categories c0_ WHERE c0_.visible = 1 AND c0_.parent IS NULL LIMIT 50;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.user_id AS user_id_2,
  c0_.status AS status_3,
  c0_.code AS code_4,
  c0_.type AS type_5,
  c0_.discount_value AS discount_value_6,
  c0_.currency AS currency_7,
  c0_.start_date AS start_date_8,
  c0_.end_date AS end_date_9,
  c0_.exclusive AS exclusive_10,
  c0_.featured AS featured_11,
  c0_.verified AS verified_12,
  c0_.usage_limit AS usage_limit_13,
  c0_.usage_count AS usage_count_14,
  c0_.clicks AS clicks_15,
  c0_.conversions AS conversions_16,
  c0_.priority_score AS priority_score_17,
  c0_.notes AS notes_18,
  c0_.user_submit AS user_submit_19,
  c0_.insert_date AS insert_date_20,
  s1_.id AS id_21,
  s1_.name AS name_22,
  s1_.logo AS logo_23,
  s1_.cover_image AS cover_image_24,
  s1_.url AS url_25,
  s1_.cashback AS cashback_26,
  s1_.featured AS featured_27,
  s1_.offline AS offline_28,
  s1_.status AS status_29,
  s1_.channel AS channel_30,
  s1_.ext_mapping AS ext_mapping_31,
  s1_.insert_date AS insert_date_32,
  c0_.store_id AS store_id_33
FROM
  coupons c0_
  INNER JOIN stores s1_ ON c0_.store_id = s1_.id
  INNER JOIN countries_lnk c2_ ON (
    c2_.entity_type = ?
    AND c2_.entity_id = s1_.id
    AND c2_.country = ?
  )
WHERE
  c0_.status = ?
ORDER BY
  c0_.priority_score DESC
LIMIT
  8

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.user_id AS user_id_2, c0_.status AS status_3, c0_.code AS code_4, c0_.type AS type_5, c0_.discount_value AS discount_value_6, c0_.currency AS currency_7, c0_.start_date AS start_date_8, c0_.end_date AS end_date_9, c0_.exclusive AS exclusive_10, c0_.featured AS featured_11, c0_.verified AS verified_12, c0_.usage_limit AS usage_limit_13, c0_.usage_count AS usage_count_14, c0_.clicks AS clicks_15, c0_.conversions AS conversions_16, c0_.priority_score AS priority_score_17, c0_.notes AS notes_18, c0_.user_submit AS user_submit_19, c0_.insert_date AS insert_date_20, s1_.id AS id_21, s1_.name AS name_22, s1_.logo AS logo_23, s1_.cover_image AS cover_image_24, s1_.url AS url_25, s1_.cashback AS cashback_26, s1_.featured AS featured_27, s1_.offline AS offline_28, s1_.status AS status_29, s1_.channel AS channel_30, s1_.ext_mapping AS ext_mapping_31, s1_.insert_date AS insert_date_32, c0_.store_id AS store_id_33 FROM coupons c0_ INNER JOIN stores s1_ ON c0_.store_id = s1_.id INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s1_.id AND c2_.country = '1') WHERE c0_.status = 1 ORDER BY c0_.priority_score DESC LIMIT 8;

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.name_id = ?
  AND t0.category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.name_id = 'pref' AND t0.category_id = 'settings' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.image AS image_3,
  t0.controller AS controller_4,
  t0.config AS config_5,
  t0.active AS active_6,
  t0.insert_date AS insert_date_7,
  t0.channel_id AS channel_id_8
FROM
  integrations t0
WHERE
  t0.controller = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.controller AS controller_4, t0.config AS config_5, t0.active AS active_6, t0.insert_date AS insert_date_7, t0.channel_id AS channel_id_8 FROM integrations t0 WHERE t0.controller = 'App\\Controller\\Plugins\\Integrations\\Impact' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label_id AS label_id_2,
  t0.integration AS integration_3,
  t0.config AS config_4,
  t0.last_execution AS last_execution_5,
  t0.every_minutes AS every_minutes_6,
  t0.next_execution AS next_execution_7
FROM
  cron t0
WHERE
  t0.label_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label_id AS label_id_2, t0.integration AS integration_3, t0.config AS config_4, t0.last_execution AS last_execution_5, t0.every_minutes AS every_minutes_6, t0.next_execution AS next_execution_7 FROM cron t0 WHERE t0.label_id = 'impact_fetch_data' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.cover_image AS cover_image_3,
  s0_.url AS url_4,
  s0_.cashback AS cashback_5,
  s0_.featured AS featured_6,
  s0_.offline AS offline_7,
  s0_.status AS status_8,
  s0_.channel AS channel_9,
  s0_.ext_mapping AS ext_mapping_10,
  s0_.insert_date AS insert_date_11,
  COUNT(c1_.id) AS sclr_12,
  MAX(
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_13
FROM
  stores s0_
  INNER JOIN countries_lnk c3_ ON (
    c3_.entity_type = 1
    AND c3_.entity_id = s0_.id
    AND c3_.country = ?
  )
  LEFT JOIN coupons c1_ ON (
    c1_.store_id = s0_.id
    AND c1_.status = 1
  )
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND (
      f2_.user_id = ?
      OR (
        f2_.user_id IS NULL
        AND f2_.client_ip = ?
      )
    )
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?
GROUP BY
  s0_.id
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.cover_image AS cover_image_3, s0_.url AS url_4, s0_.cashback AS cashback_5, s0_.featured AS featured_6, s0_.offline AS offline_7, s0_.status AS status_8, s0_.channel AS channel_9, s0_.ext_mapping AS ext_mapping_10, s0_.insert_date AS insert_date_11, COUNT(c1_.id) AS sclr_12, MAX(CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_13 FROM stores s0_ INNER JOIN countries_lnk c3_ ON (c3_.entity_type = 1 AND c3_.entity_id = s0_.id AND c3_.country = '1') LEFT JOIN coupons c1_ ON (c1_.store_id = s0_.id AND c1_.status = 1) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND (f2_.user_id = NULL OR (f2_.user_id IS NULL AND f2_.client_ip = ''))) WHERE s0_.status = 1 AND s0_.featured = 1 GROUP BY s0_.id LIMIT 10;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  coupons c0_
  INNER JOIN stores s1_ ON c0_.store_id = s1_.id
  INNER JOIN countries_lnk c2_ ON (
    c2_.entity_type = ?
    AND c2_.entity_id = s1_.id
    AND c2_.country = ?
  )
WHERE
  c0_.status = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM coupons c0_ INNER JOIN stores s1_ ON c0_.store_id = s1_.id INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s1_.id AND c2_.country = '1') WHERE c0_.status = 1;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  INNER JOIN countries_lnk c1_ ON (
    c1_.entity_type = 1
    AND c1_.entity_id = s0_.id
    AND c1_.country = ?
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?
  AND s0_.cashback IS NOT NULL

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ INNER JOIN countries_lnk c1_ ON (c1_.entity_type = 1 AND c1_.entity_id = s0_.id AND c1_.country = '1') WHERE s0_.status = 1 AND s0_.featured = 1 AND s0_.cashback IS NOT NULL;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  INNER JOIN countries_lnk c1_ ON (
    c1_.entity_type = 1
    AND c1_.entity_id = s0_.id
    AND c1_.country = ?
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ INNER JOIN countries_lnk c1_ ON (c1_.entity_type = 1 AND c1_.entity_id = s0_.id AND c1_.country = '1') WHERE s0_.status = 1 AND s0_.featured = 1;

SELECT
  t0.id AS id_1,
  t0.name_id AS name_id_2,
  t0.category_id AS category_id_3,
  t0.name AS name_4,
  t0.value AS value_5
FROM
  options t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name_id AS name_id_2, t0.category_id AS category_id_3, t0.name AS name_4, t0.value AS value_5 FROM options t0 WHERE t0.category_id = 'paths';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.icon AS icon_4,
  t0.def_language AS def_language_5,
  t0.visible AS visible_6,
  t0.insert_date AS insert_date_7
FROM
  countries t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.id = '1';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.icon AS icon_4,
  t0.def_language AS def_language_5,
  t0.visible AS visible_6,
  t0.insert_date AS insert_date_7
FROM
  countries t0
WHERE
  t0.iso_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.icon AS icon_4, t0.def_language AS def_language_5, t0.visible AS visible_6, t0.insert_date AS insert_date_7 FROM countries t0 WHERE t0.iso_code = 'US' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.route AS route_3,
  t0.icon AS icon_4,
  t0.parent AS parent_5,
  t0.menu_position AS menu_position_6,
  t0.popup_open AS popup_open_7,
  t0.mandatory AS mandatory_8,
  t0.menu_default AS menu_default_9
FROM
  modules t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.icon AS icon_4, t0.parent AS parent_5, t0.menu_position AS menu_position_6, t0.popup_open AS popup_open_7, t0.mandatory AS mandatory_8, t0.menu_default AS menu_default_9 FROM modules t0 WHERE t0.route = 'main_path' LIMIT 1;