Symfony Profiler

SELECT
  codes_by_period.offer_id,
  sum (
    case when codes_by_period.subscription_period_start_at is null then codes_by_period.codes_count when codes_by_period.previous_period_codes_count > :codesFromSameSubscription then 0 when (
      codes_by_period.previous_period_codes_count + codes_by_period.codes_count
    ) <= :codesFromSameSubscription then codes_by_period.codes_count when (
      codes_by_period.codes_count - codes_by_period.previous_period_codes_count
    ) > :codesFromSameSubscription then (
      :codesFromSameSubscription - codes_by_period.previous_period_codes_count
    ) else codes_by_period.codes_count - codes_by_period.previous_period_codes_count end
  ) as codes_count
FROM
  (
    SELECT
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      coalesce(
        previous_count.count_by_subscription,
        0
      ) as previous_period_codes_count,
      count(*) as codes_count
    FROM
      offer_code
      INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
      LEFT JOIN (
        SELECT
          offer_order.offer_id,
          offer_order.user_id,
          offer_order.subscription_period_start_at,
          count(*) as count_by_subscription
        FROM
          offer_code
          INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
        WHERE
          (
            offer_order.created_on < :dateFrom
          )
          AND (
            (
              offer_order.user_id, subscription_period_start_at
            ) IN (
              SELECT
                DISTINCT offer_order.user_id,
                offer_order.subscription_period_start_at
              FROM
                offer_code
                INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id
              WHERE
                (
                  offer_order.created_on between :dateFrom
                  and :dateTo
                )
                AND (
                  offer_order.subscription_period_start_at IS NOT NULL
                )
            )
          )
        GROUP BY
          offer_order.offer_id,
          offer_order.user_id,
          offer_order.subscription_period_start_at
      ) previous_count ON (
        previous_count.offer_id = offer_order.offer_id
      )
      AND (
        previous_count.user_id = offer_order.user_id
      )
      AND (
        previous_count.subscription_period_start_at = offer_order.subscription_period_start_at
      )
    WHERE
      offer_order.created_on between :dateFrom
      and :dateTo
    GROUP BY
      offer_order.offer_id,
      offer_order.user_id,
      offer_order.subscription_period_start_at,
      coalesce(
        previous_count.count_by_subscription,
        0
      )
  ) codes_by_period
WHERE
  codes_by_period.offer_id = :offerId
GROUP BY
  codes_by_period.offer_id

SELECT codes_by_period.offer_id, sum (case when codes_by_period.subscription_period_start_at is null then codes_by_period.codes_count when codes_by_period.previous_period_codes_count > 0 then 0 when (codes_by_period.previous_period_codes_count + codes_by_period.codes_count) <= 0 then codes_by_period.codes_count when (codes_by_period.codes_count - codes_by_period.previous_period_codes_count) > 0 then (0 - codes_by_period.previous_period_codes_count) else codes_by_period.codes_count - codes_by_period.previous_period_codes_count end) as codes_count FROM (SELECT offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, coalesce(previous_count.count_by_subscription, 0) as previous_period_codes_count, count(*) as codes_count FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id LEFT JOIN (SELECT offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, count(*) as count_by_subscription FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id WHERE (offer_order.created_on < '2025-09-11 14:45:24') AND ((offer_order.user_id, subscription_period_start_at) IN (SELECT DISTINCT offer_order.user_id, offer_order.subscription_period_start_at FROM offer_code INNER JOIN offer_order offer_order ON offer_code.offer_order_id = offer_order.id WHERE (offer_order.created_on between '2025-09-11 14:45:24' and '2025-09-12 14:45:24') AND (offer_order.subscription_period_start_at IS NOT NULL))) GROUP BY offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at) previous_count ON (previous_count.offer_id = offer_order.offer_id) AND (previous_count.user_id = offer_order.user_id) AND (previous_count.subscription_period_start_at = offer_order.subscription_period_start_at) WHERE offer_order.created_on between '2025-09-11 14:45:24' and '2025-09-12 14:45:24' GROUP BY offer_order.offer_id, offer_order.user_id, offer_order.subscription_period_start_at, coalesce(previous_count.count_by_subscription, 0)) codes_by_period WHERE codes_by_period.offer_id = 300143 GROUP BY codes_by_period.offer_id;

select
  offer_order_details.created_on
from
  offer_order_details
  inner join offer_order on offer_order_details.offer_order_id = offer_order.id
where
  offer_order.offer_id = 300143
  and status > 0
  and offer_order_details.created_on > now() + '-12 hours'
order by
  offer_order_details.id desc
limit
  1

select offer_order_details.created_on from offer_order_details inner join offer_order on offer_order_details.offer_order_id = offer_order.id
          where offer_order.offer_id = 300143 and status > 0 and offer_order_details.created_on > now() + '-12 hours' order by offer_order_details.id desc limit 1;

SELECT
  s0_.eligibility_rule AS eligibility_rule_0,
  s0_.id AS id_1
FROM
  server_feature_state s0_

SELECT s0_.eligibility_rule AS eligibility_rule_0, s0_.id AS id_1 FROM server_feature_state s0_;

SELECT
  c0_.type_id AS type_id_0,
  c0_.entity_id AS entity_id_1,
  c0_.parent_id AS parent_id_2,
  c0_.user_id AS user_id_3,
  c0_.created_on AS created_on_4,
  c0_.user_ip AS user_ip_5,
  c0_.hidden AS hidden_6,
  c0_.checked AS checked_7,
  c0_.deleted AS deleted_8,
  c0_.confirmed_phone AS confirmed_phone_9,
  c0_.seen_by_supplier AS seen_by_supplier_10,
  c0_.comment AS comment_11,
  c0_.admin_comment AS admin_comment_12,
  c0_.rating AS rating_13,
  c0_.taken_by_operator_on AS taken_by_operator_on_14,
  c0_.processed_by_operator_on AS processed_by_operator_on_15,
  c0_.telegram_notify_sent AS telegram_notify_sent_16,
  c0_.allow_to_contact AS allow_to_contact_17,
  c0_.mobile_version AS mobile_version_18,
  c0_.hidden_entity AS hidden_entity_19,
  c0_.id AS id_20,
  c1_.external_id AS external_id_21,
  c1_.created_on AS created_on_22,
  c1_.city_id AS city_id_23,
  c1_.email AS email_24,
  c1_.password AS password_25,
  c1_.accept_newsletter AS accept_newsletter_26,
  c1_.transition_id AS transition_id_27,
  c1_.first_name AS first_name_28,
  c1_.last_name AS last_name_29,
  c1_.phone AS phone_30,
  c1_.status AS status_31,
  c1_.balance AS balance_32,
  c1_.registered_from_utm_source AS registered_from_utm_source_33,
  c1_.token AS token_34,
  c1_.totally_unsubscribed AS totally_unsubscribed_35,
  c1_.seen_microphone_tooltip AS seen_microphone_tooltip_36,
  c1_.not_show_rate_popup_till AS not_show_rate_popup_till_37,
  c1_.geo_location_accepted AS geo_location_accepted_38,
  c1_.geo_location AS geo_location_39,
  c1_.telegram_id AS telegram_id_40,
  c1_.site_id AS site_id_41,
  c1_.manager_name AS manager_name_42,
  c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_43,
  c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_44,
  c1_.batch_codes_count AS batch_codes_count_45,
  c1_.money_balance AS money_balance_46,
  c1_.id AS id_47,
  c0_.parent_id AS parent_id_48,
  c0_.user_id AS user_id_49,
  c0_.operator_id AS operator_id_50,
  c1_.city_id AS city_id_51
FROM
  comment c0_
  INNER JOIN customer c1_ ON c0_.user_id = c1_.id
WHERE
  c0_.entity_id = ?
  AND c0_.hidden <> true
  AND c0_.parent_id IS NULL
  AND c0_.id < ?
  AND c0_.confirmed_phone = true
ORDER BY
  c0_.created_on DESC
LIMIT
  20

SELECT c0_.type_id AS type_id_0, c0_.entity_id AS entity_id_1, c0_.parent_id AS parent_id_2, c0_.user_id AS user_id_3, c0_.created_on AS created_on_4, c0_.user_ip AS user_ip_5, c0_.hidden AS hidden_6, c0_.checked AS checked_7, c0_.deleted AS deleted_8, c0_.confirmed_phone AS confirmed_phone_9, c0_.seen_by_supplier AS seen_by_supplier_10, c0_.comment AS comment_11, c0_.admin_comment AS admin_comment_12, c0_.rating AS rating_13, c0_.taken_by_operator_on AS taken_by_operator_on_14, c0_.processed_by_operator_on AS processed_by_operator_on_15, c0_.telegram_notify_sent AS telegram_notify_sent_16, c0_.allow_to_contact AS allow_to_contact_17, c0_.mobile_version AS mobile_version_18, c0_.hidden_entity AS hidden_entity_19, c0_.id AS id_20, c1_.external_id AS external_id_21, c1_.created_on AS created_on_22, c1_.city_id AS city_id_23, c1_.email AS email_24, c1_.password AS password_25, c1_.accept_newsletter AS accept_newsletter_26, c1_.transition_id AS transition_id_27, c1_.first_name AS first_name_28, c1_.last_name AS last_name_29, c1_.phone AS phone_30, c1_.status AS status_31, c1_.balance AS balance_32, c1_.registered_from_utm_source AS registered_from_utm_source_33, c1_.token AS token_34, c1_.totally_unsubscribed AS totally_unsubscribed_35, c1_.seen_microphone_tooltip AS seen_microphone_tooltip_36, c1_.not_show_rate_popup_till AS not_show_rate_popup_till_37, c1_.geo_location_accepted AS geo_location_accepted_38, c1_.geo_location AS geo_location_39, c1_.telegram_id AS telegram_id_40, c1_.site_id AS site_id_41, c1_.manager_name AS manager_name_42, c1_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_43, c1_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_44, c1_.batch_codes_count AS batch_codes_count_45, c1_.money_balance AS money_balance_46, c1_.id AS id_47, c0_.parent_id AS parent_id_48, c0_.user_id AS user_id_49, c0_.operator_id AS operator_id_50, c1_.city_id AS city_id_51 FROM comment c0_ INNER JOIN customer c1_ ON c0_.user_id = c1_.id WHERE c0_.entity_id = 300143 AND c0_.hidden <> true AND c0_.parent_id IS NULL AND c0_.id < 2147483647 AND c0_.confirmed_phone = true ORDER BY c0_.created_on DESC LIMIT 20;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 2112452;

SELECT
  t0.created_on AS created_on_1,
  t0.email AS email_2,
  t0.status AS status_3,
  t0.id AS id_4,
  t0.referral_id AS referral_id_5,
  t0.user_balance_activity_id AS user_balance_activity_id_6,
  t0.referer_id AS referer_id_7
FROM
  referral t0
WHERE
  t0.referral_id = ?

SELECT t0.created_on AS created_on_1, t0.email AS email_2, t0.status AS status_3, t0.id AS id_4, t0.referral_id AS referral_id_5, t0.user_balance_activity_id AS user_balance_activity_id_6, t0.referer_id AS referer_id_7 FROM referral t0 WHERE t0.referral_id = 1765060;

SELECT
  o0_.title AS title_0,
  o0_.offer_id AS offer_id_1,
  o0_.id AS id_2
FROM
  offer_gallery_video_package o0_
WHERE
  o0_.offer_id = ?

SELECT o0_.title AS title_0, o0_.offer_id AS offer_id_1, o0_.id AS id_2 FROM offer_gallery_video_package o0_ WHERE o0_.offer_id = 300143;

SELECT
  COUNT(*)
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('26')

SELECT COUNT(*) FROM media t0 WHERE t0.entity_id = 201890 AND t0.type IN ('26');

SELECT
  t0.name AS name_1,
  t0.path AS path_2,
  t0.description AS description_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.size AS size_6,
  t0.sort_order AS sort_order_7,
  t0.checked AS checked_8,
  t0.youtube AS youtube_9,
  t0.id AS id_10,
  t0.entity_id AS entity_id_11,
  t0.type
FROM
  media t0
WHERE
  t0.entity_id = ?
  AND t0.type IN ('26')

SELECT t0.name AS name_1, t0.path AS path_2, t0.description AS description_3, t0.width AS width_4, t0.height AS height_5, t0.size AS size_6, t0.sort_order AS sort_order_7, t0.checked AS checked_8, t0.youtube AS youtube_9, t0.id AS id_10, t0.entity_id AS entity_id_11, t0.type FROM media t0 WHERE t0.entity_id = 201890 AND t0.type IN ('26');

SELECT
  t0.title AS title_1,
  t0.domain AS domain_2,
  t0.path AS path_3,
  t0.position AS position_4,
  t0.vimeo_id AS vimeo_id_5,
  t0.package_id AS package_id_6,
  t0.id AS id_7,
  t0.package_id AS package_id_8
FROM
  offer_gallery_video t0
WHERE
  t0.package_id = ?

SELECT t0.title AS title_1, t0.domain AS domain_2, t0.path AS path_3, t0.position AS position_4, t0.vimeo_id AS vimeo_id_5, t0.package_id AS package_id_6, t0.id AS id_7, t0.package_id AS package_id_8 FROM offer_gallery_video t0 WHERE t0.package_id = 201890;