Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.affiliate_bonus AS affiliate_bonus_5,
  t0.bonus_type AS bonus_type_6,
  t0.discount AS discount_7,
  t0.discount_type AS discount_type_8,
  t0.content AS content_9,
  t0.redirect_url AS redirect_url_10,
  t0.uuid AS uuid_11,
  t0.top_region AS top_region_12,
  t0.top_device AS top_device_13,
  t0.scans AS scans_14,
  t0.type AS type_15,
  t0.cookie_lifetime AS cookie_lifetime_16,
  t0.unique_scans AS unique_scans_17,
  t0.qrcode_attribute AS qrcode_attribute_18,
  t0.locale AS locale_19,
  t0.deleted_at AS deleted_at_20,
  t0.last_scan_at AS last_scan_at_21,
  t0.alias AS alias_22,
  t0.enable_tracking AS enable_tracking_23,
  t0.is_default AS is_default_24,
  t0.user_id AS user_id_25,
  t0.organization_id AS organization_id_26
FROM
  campaign t0
WHERE
  t0.uuid = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.affiliate_bonus AS affiliate_bonus_5, t0.bonus_type AS bonus_type_6, t0.discount AS discount_7, t0.discount_type AS discount_type_8, t0.content AS content_9, t0.redirect_url AS redirect_url_10, t0.uuid AS uuid_11, t0.top_region AS top_region_12, t0.top_device AS top_device_13, t0.scans AS scans_14, t0.type AS type_15, t0.cookie_lifetime AS cookie_lifetime_16, t0.unique_scans AS unique_scans_17, t0.qrcode_attribute AS qrcode_attribute_18, t0.locale AS locale_19, t0.deleted_at AS deleted_at_20, t0.last_scan_at AS last_scan_at_21, t0.alias AS alias_22, t0.enable_tracking AS enable_tracking_23, t0.is_default AS is_default_24, t0.user_id AS user_id_25, t0.organization_id AS organization_id_26 FROM campaign t0 WHERE t0.uuid = '5N8PRL' AND t0.deleted_at IS NULL LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0,
  c0_.device_os AS device_os_1
FROM
  campaign_log c0_
WHERE
  c0_.campaign_id = ?
  AND c0_.device_os IS NOT NULL
GROUP BY
  c0_.device_os
ORDER BY
  sclr_0 DESC
LIMIT
  1

SELECT COUNT(c0_.id) AS sclr_0, c0_.device_os AS device_os_1 FROM campaign_log c0_ WHERE c0_.campaign_id = 389 AND c0_.device_os IS NOT NULL GROUP BY c0_.device_os ORDER BY sclr_0 DESC LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0,
  c0_.region AS region_1
FROM
  campaign_log c0_
WHERE
  c0_.campaign_id = ?
  AND c0_.region IS NOT NULL
GROUP BY
  c0_.region
ORDER BY
  sclr_0 DESC
LIMIT
  1

SELECT COUNT(c0_.id) AS sclr_0, c0_.region AS region_1 FROM campaign_log c0_ WHERE c0_.campaign_id = 389 AND c0_.region IS NOT NULL GROUP BY c0_.region ORDER BY sclr_0 DESC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO campaign_log (
  created_at, updated_at, attribute,
  is_processed, cookie_id, is_unique,
  language, device_os, device_platform,
  country, city, region, zip, country_code,
  source_media, channel, is_bot, campaign_id,
  organization_id, affiliate_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

INSERT INTO campaign_log (created_at, updated_at, attribute, is_processed, cookie_id, is_unique, language, device_os, device_platform, country, city, region, zip, country_code, source_media, channel, is_bot, campaign_id, organization_id, affiliate_id) VALUES ('2025-03-17 03:24:25', '2025-03-17 03:24:25', '{\"geoip\":{\"status\":\"success\",\"country\":\"Germany\",\"countryCode\":\"DE\",\"region\":\"HE\",\"regionName\":\"Hesse\",\"city\":\"Frankfurt am Main\",\"zip\":\"60313\",\"lat\":50.1169,\"lon\":8.6837,\"timezone\":\"Europe\\/Berlin\",\"isp\":\"Powerhouse Management, Inc.\",\"org\":\"Unus, Inc.\",\"as\":\"AS22363 Powerhouse Management, Inc.\",\"query\":\"128.90.128.5\"},\"attr\":{\"uuid\":\"5N8PRL\",\"affiliate\":null,\"ip\":\"128.90.128.5\",\"user_agent\":\"Mozilla\\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\\/605.1.15 (KHTML, like Gecko) Version\\/15.1 Safari\\/605.1.15\",\"http_referrer\":\"http:\\/\\/ateliercreativ.ch\\/c\\/5N8PRL\",\"accept_language\":null},\"device\":{\"client\":{\"type\":\"browser\",\"name\":\"Safari\",\"short_name\":\"SF\",\"version\":\"15.1\",\"engine\":\"WebKit\",\"engine_version\":\"605.1.15\",\"family\":\"Safari\"},\"os\":{\"name\":\"Mac\",\"short_name\":\"MAC\",\"version\":\"10.15\",\"platform\":\"\",\"family\":\"Mac\"},\"device\":\"desktop\",\"brand\":\"Apple\",\"model\":\"\",\"bot\":null}}', 0, '6fb0dd31-5c42-4045-8cdf-1f58a8b592e4', 1, NULL, 'Mac', 'desktop', 'Germany', 'Frankfurt am Main', 'Hesse', '60313', 'DE', 'qr', NULL, 0, 389, 126, NULL);

UPDATE
  campaign
SET
  scans = ?,
  unique_scans = ?,
  last_scan_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE campaign SET scans = 2753, unique_scans = 2337, last_scan_at = '2025-03-17 03:24:24', updated_at = '2025-03-17 03:24:25' WHERE id = 389;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.company AS company_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.affiliate_code AS affiliate_code_9,
  t0.signup_code AS signup_code_10,
  t0.type AS type_11,
  t0.stripe_session AS stripe_session_12,
  t0.stripe_customer AS stripe_customer_13,
  t0.stripe_subscription AS stripe_subscription_14,
  t0.is_paying AS is_paying_15,
  t0.request_cancelled AS request_cancelled_16,
  t0.cancelled_at AS cancelled_at_17,
  t0.next_payment_at AS next_payment_at_18,
  t0.is_verified_at AS is_verified_at_19,
  t0.locale AS locale_20,
  t0.is_super_admin AS is_super_admin_21,
  t0.deleted_at AS deleted_at_22,
  t0.activated_at AS activated_at_23,
  t0.is_first_visit AS is_first_visit_24,
  t0.organization_id AS organization_id_25,
  t0.referee_id AS referee_id_26
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.company AS company_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.affiliate_code AS affiliate_code_9, t0.signup_code AS signup_code_10, t0.type AS type_11, t0.stripe_session AS stripe_session_12, t0.stripe_customer AS stripe_customer_13, t0.stripe_subscription AS stripe_subscription_14, t0.is_paying AS is_paying_15, t0.request_cancelled AS request_cancelled_16, t0.cancelled_at AS cancelled_at_17, t0.next_payment_at AS next_payment_at_18, t0.is_verified_at AS is_verified_at_19, t0.locale AS locale_20, t0.is_super_admin AS is_super_admin_21, t0.deleted_at AS deleted_at_22, t0.activated_at AS activated_at_23, t0.is_first_visit AS is_first_visit_24, t0.organization_id AS organization_id_25, t0.referee_id AS referee_id_26 FROM `user` t0 WHERE t0.id = 126;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.priority AS priority_7,
  t0.clicks AS clicks_8,
  t0.icon AS icon_9,
  t0.icon_color AS icon_color_10,
  t0.format AS format_11,
  t0.campaign_id AS campaign_id_12,
  t0.user_id AS user_id_13
FROM
  campaign_element t0
WHERE
  t0.campaign_id = ?
ORDER BY
  t0.priority DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.priority AS priority_7, t0.clicks AS clicks_8, t0.icon AS icon_9, t0.icon_color AS icon_color_10, t0.format AS format_11, t0.campaign_id AS campaign_id_12, t0.user_id AS user_id_13 FROM campaign_element t0 WHERE t0.campaign_id = 389 ORDER BY t0.priority DESC;