Symfony Profiler

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.value_text AS value_text_4,
  t0.ord AS ord_5,
  t0.u_value AS u_value_6,
  t0.insert_date AS insert_date_7,
  t0.store_id AS store_id_8
FROM
  store_meta t0
WHERE
  t0.store_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.value_text AS value_text_4, t0.ord AS ord_5, t0.u_value AS u_value_6, t0.insert_date AS insert_date_7, t0.store_id AS store_id_8 FROM store_meta t0 WHERE t0.store_id = 4 AND t0.name = 'description' 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.entity_type AS entity_type_2,
  t0.entity_id AS entity_id_3,
  t0.category AS category_4,
  t0.insert_date AS insert_date_5
FROM
  categories_lnk t0
WHERE
  t0.entity_type = ?
  AND t0.entity_id = ?

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.category AS category_4, t0.insert_date AS insert_date_5 FROM categories_lnk t0 WHERE t0.entity_type = 1 AND t0.entity_id = 4;

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
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.url AS url_3,
  s0_.cashback AS cashback_4,
  s0_.featured AS featured_5,
  s0_.offline AS offline_6,
  s0_.status AS status_7,
  s0_.channel AS channel_8,
  s0_.ext_mapping AS ext_mapping_9,
  s0_.insert_date AS insert_date_10,
  COUNT(c1_.id) AS sclr_11,
  (
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_12
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)
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND f2_.user_id = ?
  )
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_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 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) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = 0) WHERE s0_.status = 1 AND s0_.featured = 1 GROUP BY s0_.id LIMIT 10;

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_.url AS url_24,
  s1_.cashback AS cashback_25,
  s1_.featured AS featured_26,
  s1_.offline AS offline_27,
  s1_.status AS status_28,
  s1_.channel AS channel_29,
  s1_.ext_mapping AS ext_mapping_30,
  s1_.insert_date AS insert_date_31,
  c0_.store_id AS store_id_32
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 = ?
  AND c0_.store_id = ?
ORDER BY
  c0_.priority_score DESC
LIMIT
  10

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_.url AS url_24, s1_.cashback AS cashback_25, s1_.featured AS featured_26, s1_.offline AS offline_27, s1_.status AS status_28, s1_.channel AS channel_29, s1_.ext_mapping AS ext_mapping_30, s1_.insert_date AS insert_date_31, c0_.store_id AS store_id_32 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 AND c0_.store_id = 4 ORDER BY c0_.priority_score DESC LIMIT 10;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.url AS url_3,
  s0_.cashback AS cashback_4,
  s0_.featured AS featured_5,
  s0_.offline AS offline_6,
  s0_.status AS status_7,
  s0_.channel AS channel_8,
  s0_.ext_mapping AS ext_mapping_9,
  s0_.insert_date AS insert_date_10,
  COUNT(c1_.id) AS sclr_11,
  (
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_12
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)
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND f2_.user_id = ?
  )
WHERE
  s0_.status = ?
GROUP BY
  s0_.id
LIMIT
  10

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 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) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = 0) WHERE s0_.status = 1 GROUP BY s0_.id LIMIT 10;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.logo AS logo_2,
  s0_.url AS url_3,
  s0_.cashback AS cashback_4,
  s0_.featured AS featured_5,
  s0_.offline AS offline_6,
  s0_.status AS status_7,
  s0_.channel AS channel_8,
  s0_.ext_mapping AS ext_mapping_9,
  s0_.insert_date AS insert_date_10,
  COUNT(c1_.id) AS sclr_11,
  (
    CASE WHEN f2_.id IS NOT NULL THEN
      1
    ELSE
      0
    END
  ) AS sclr_12
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)
  LEFT JOIN favorites_lnk f2_ ON (
    f2_.store_id = s0_.id
    AND f2_.user_id = ?
  )
WHERE
  s0_.status = ?
  AND s0_.name LIKE ?
GROUP BY
  s0_.id
LIMIT
  50

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.logo AS logo_2, s0_.url AS url_3, s0_.cashback AS cashback_4, s0_.featured AS featured_5, s0_.offline AS offline_6, s0_.status AS status_7, s0_.channel AS channel_8, s0_.ext_mapping AS ext_mapping_9, s0_.insert_date AS insert_date_10, COUNT(c1_.id) AS sclr_11, (CASE WHEN f2_.id IS NOT NULL THEN 1 ELSE 0 END) AS sclr_12 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) LEFT JOIN favorites_lnk f2_ ON (f2_.store_id = s0_.id AND f2_.user_id = 0) WHERE s0_.status = 1 AND s0_.name LIKE '%GEVI%' GROUP BY s0_.id LIMIT 50;

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  LEFT JOIN favorites_lnk f1_ ON (
    f1_.store_id = s0_.id
    AND f1_.user_id = ?
  )
  INNER JOIN countries_lnk c2_ ON (
    c2_.entity_type = 1
    AND c2_.entity_id = s0_.id
    AND c2_.country = ?
  )
WHERE
  s0_.status = ?
  AND s0_.name LIKE ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = 0) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = '1') WHERE s0_.status = 1 AND s0_.name LIKE '%GEVI%';

SELECT
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  LEFT JOIN favorites_lnk f1_ ON (
    f1_.store_id = s0_.id
    AND f1_.user_id = ?
  )
  INNER JOIN countries_lnk c2_ ON (
    c2_.entity_type = 1
    AND c2_.entity_id = s0_.id
    AND c2_.country = ?
  )
WHERE
  s0_.status = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = 0) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = '1') WHERE s0_.status = 1;

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 = ?
  AND c0_.store_id = ?

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 AND c0_.store_id = 4;

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
  COUNT(DISTINCT s0_.id) AS sclr_0
FROM
  stores s0_
  LEFT JOIN favorites_lnk f1_ ON (
    f1_.store_id = s0_.id
    AND f1_.user_id = ?
  )
  INNER JOIN countries_lnk c2_ ON (
    c2_.entity_type = 1
    AND c2_.entity_id = s0_.id
    AND c2_.country = ?
  )
WHERE
  s0_.status = ?
  AND s0_.featured = ?

SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM stores s0_ LEFT JOIN favorites_lnk f1_ ON (f1_.store_id = s0_.id AND f1_.user_id = 0) INNER JOIN countries_lnk c2_ ON (c2_.entity_type = 1 AND c2_.entity_id = s0_.id AND c2_.country = '1') WHERE s0_.status = 1 AND s0_.featured = 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.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.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;