Symfony Profiler

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.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.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
  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\\Skimlinks' 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
  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\\CJ' 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 = 'cj_fetch_data' 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\\Awin' 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 = 'awin_fetch_data' 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 = 'go_link' LIMIT 1;

SELECT
  cou.id,
  c.id AS channelId,
  COALESCE(ec.url, ec_s.url) AS url,
  c.params,
  s.id AS storeId
FROM
  coupons cou
  INNER JOIN stores s ON s.id = cou.store_id
  INNER JOIN store_channels ec_s ON ec_s.store = s.id
  AND ec_s.channel = s.channel
  INNER JOIN channels c ON c.id = s.channel
  LEFT JOIN coupon_channels ec ON ec.coupon = cou.id
  AND ec.channel = s.channel
WHERE
  cou.id = ?

SELECT
                cou.id,
                c.id AS channelId,
                COALESCE(ec.url, ec_s.url) AS url, 
                c.params,
                s.id AS storeId
            FROM coupons cou
            INNER JOIN stores s 
                ON s.id = cou.store_id
            INNER JOIN store_channels ec_s
                ON ec_s.store = s.id AND ec_s.channel = s.channel
			INNER JOIN channels c
				ON c.id = s.channel
            LEFT JOIN coupon_channels ec
                ON ec.coupon = cou.id AND ec.channel = s.channel
            WHERE cou.id = 197;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO clicks (
  entity_type, entity_id, ip_addr, user,
  channel, cashback, source, insert_date
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO clicks (entity_type, entity_id, ip_addr, user, channel, cashback, source, insert_date) VALUES (1, 197, '104.23.243.25', NULL, 2, 1, NULL, '2026-03-23 12:58:54');

"COMMIT"

"COMMIT";