Symfony Profiler

SELECT
  offer_order.id as offer_order_id,
  offer_order.paid_at,
  offer_order.delivery_time as preorder_at,
  offer_order.type,
  offer_order.device_type,
  customer.email as user_email,
  coalesce(offer_order.username, '') as user_name,
  offer_order.user_phone,
  offer_order.delivery_cost as delivery_price,
  offer_order.parameter_int_0 as payment_type,
  offer_order_details.code,
  offer_order_details.purchase_price,
  offer_order_details.items_count,
  gift_certificate.name as gift_certificate_name,
  user_address.name as delivery_address_name,
  user_address.phone as delivery_address_phone,
  street.name as delivery_address_street,
  user_address.house as delivery_address_house,
  user_address.block as delivery_address_block,
  user_address.appartment as delivery_address_apartment,
  user_address.entrance as delivery_address_entrance,
  user_address.floor as delivery_address_floor,
  user_address.doorphone as delivery_address_doorphone,
  offer_extension.name as offer_extension_name,
  offer_extension_variant.partner_id as offer_extension_variant_partner_id,
  user_address.pickup as pickup,
  concat_ws(
    ', ', geo_location.city, geo_location.street,
    geo_location.house
  ) as pickup_address
FROM
  offer_order_details
  INNER JOIN offer_order offer_order ON offer_order.id = offer_order_details.offer_order_id
  LEFT JOIN gift_certificate gift_certificate ON gift_certificate.id = offer_order_details.gift_certificate_id
  LEFT JOIN offer_extension offer_extension ON offer_extension.id = offer_order_details.offer_extension_id
  LEFT JOIN offer_extension_variant offer_extension_variant ON offer_extension_variant.id = offer_order_details.offer_extension_variant_id
  INNER JOIN offer offer ON offer.id = offer_order.offer_id
  INNER JOIN customer customer ON offer_order.user_id = customer.id
  LEFT JOIN user_address user_address ON user_address.id = offer_order.delivery_address_id
  INNER JOIN offer2director offer2director ON offer2director.offer_id = offer.id
  LEFT JOIN street street ON street.id = user_address.street_id
  LEFT JOIN geo_location geo_location ON geo_location.id = user_address.geo_location_id
WHERE
  (
    offer2director.director_id = :directorId
  )
  AND (
    offer_order.type IN (:offerOrderTypes)
  )
  AND (
    offer_order.status > :initOrderStatus
  )
  AND (
    offer_order_details.created_on between :periodStart
    and :periodEnd
  )
ORDER BY
  offer_order.paid_at desc,
  offer_order.id asc,
  offer_order_details.id asc

SELECT offer_order.id as offer_order_id, offer_order.paid_at, offer_order.delivery_time as preorder_at, offer_order.type, offer_order.device_type, customer.email as user_email, coalesce(offer_order.username, '') as user_name, offer_order.user_phone, offer_order.delivery_cost as delivery_price, offer_order.parameter_int_0 as payment_type, offer_order_details.code, offer_order_details.purchase_price, offer_order_details.items_count, gift_certificate.name as gift_certificate_name, user_address.name as delivery_address_name, user_address.phone as delivery_address_phone, street.name as delivery_address_street, user_address.house as delivery_address_house, user_address.block as delivery_address_block, user_address.appartment as delivery_address_apartment, user_address.entrance as delivery_address_entrance, user_address.floor as delivery_address_floor, user_address.doorphone as delivery_address_doorphone, offer_extension.name as offer_extension_name, offer_extension_variant.partner_id as offer_extension_variant_partner_id, user_address.pickup as pickup, concat_ws(', ', geo_location.city, geo_location.street, geo_location.house) as pickup_address FROM offer_order_details INNER JOIN offer_order offer_order ON offer_order.id = offer_order_details.offer_order_id LEFT JOIN gift_certificate gift_certificate ON gift_certificate.id = offer_order_details.gift_certificate_id LEFT JOIN offer_extension offer_extension ON offer_extension.id = offer_order_details.offer_extension_id LEFT JOIN offer_extension_variant offer_extension_variant ON offer_extension_variant.id = offer_order_details.offer_extension_variant_id INNER JOIN offer offer ON offer.id = offer_order.offer_id INNER JOIN customer customer ON offer_order.user_id = customer.id LEFT JOIN user_address user_address ON user_address.id = offer_order.delivery_address_id INNER JOIN offer2director offer2director ON offer2director.offer_id = offer.id LEFT JOIN street street ON street.id = user_address.street_id LEFT JOIN geo_location geo_location ON geo_location.id = user_address.geo_location_id WHERE (offer2director.director_id = 6000) AND (offer_order.type IN (4, 6)) AND (offer_order.status > 0) AND (offer_order_details.created_on between '2025-10-25 15:45:55' and '2025-10-26 15:45:55') ORDER BY offer_order.paid_at desc, offer_order.id asc, offer_order_details.id asc;

SELECT
  director.id
FROM
  director
WHERE
  director.email = :email

SELECT director.id FROM director WHERE director.email = :email;

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.domain = ?
  AND t0.main_alias = ?
  AND t0.active = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.domain = 'www' AND t0.main_alias = '/partner/online-order/live/refresh' AND t0.active = 1 ORDER BY t0.id DESC LIMIT 1;

SELECT
  c0_.external_id AS external_id_0,
  c0_.created_on AS created_on_1,
  c0_.city_id AS city_id_2,
  c0_.email AS email_3,
  c0_.password AS password_4,
  c0_.accept_newsletter AS accept_newsletter_5,
  c0_.transition_id AS transition_id_6,
  c0_.first_name AS first_name_7,
  c0_.last_name AS last_name_8,
  c0_.phone AS phone_9,
  c0_.status AS status_10,
  c0_.balance AS balance_11,
  c0_.registered_from_utm_source AS registered_from_utm_source_12,
  c0_.token AS token_13,
  c0_.totally_unsubscribed AS totally_unsubscribed_14,
  c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15,
  c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16,
  c0_.geo_location_accepted AS geo_location_accepted_17,
  c0_.geo_location AS geo_location_18,
  c0_.telegram_id AS telegram_id_19,
  c0_.site_id AS site_id_20,
  c0_.manager_name AS manager_name_21,
  c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22,
  c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23,
  c0_.dob AS dob_24,
  c0_.batch_codes_count AS batch_codes_count_25,
  c0_.virtual_wallet_amount AS virtual_wallet_amount_26,
  c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27,
  c0_.money_balance AS money_balance_28,
  c0_.security_code AS security_code_29,
  c0_.id AS id_30,
  c0_.city_id AS city_id_31
FROM
  customer c0_
  INNER JOIN director d1_ ON (d1_.email = c0_.email)
  INNER JOIN employee e2_ ON (e2_.company_id = d1_.id)
WHERE
  e2_.user_id = ?

SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.security_code AS security_code_29, c0_.id AS id_30, c0_.city_id AS city_id_31 FROM customer c0_ INNER JOIN director d1_ ON (d1_.email = c0_.email) INNER JOIN employee e2_ ON (e2_.company_id = d1_.id) WHERE e2_.user_id = 535179;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.transition_id AS transition_id_3,
  t0.hidden AS hidden_4,
  t0.id AS id_5
FROM
  user_group t0
  INNER JOIN user2group ON t0.id = user2group.group_id
WHERE
  user2group.user_id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.transition_id AS transition_id_3, t0.hidden AS hidden_4, t0.id AS id_5 FROM user_group t0 INNER JOIN user2group ON t0.id = user2group.group_id WHERE user2group.user_id = 535179;

SELECT
  c0_.external_id AS external_id_0,
  c0_.created_on AS created_on_1,
  c0_.city_id AS city_id_2,
  c0_.email AS email_3,
  c0_.password AS password_4,
  c0_.accept_newsletter AS accept_newsletter_5,
  c0_.transition_id AS transition_id_6,
  c0_.first_name AS first_name_7,
  c0_.last_name AS last_name_8,
  c0_.phone AS phone_9,
  c0_.status AS status_10,
  c0_.balance AS balance_11,
  c0_.registered_from_utm_source AS registered_from_utm_source_12,
  c0_.token AS token_13,
  c0_.totally_unsubscribed AS totally_unsubscribed_14,
  c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15,
  c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16,
  c0_.geo_location_accepted AS geo_location_accepted_17,
  c0_.geo_location AS geo_location_18,
  c0_.telegram_id AS telegram_id_19,
  c0_.site_id AS site_id_20,
  c0_.manager_name AS manager_name_21,
  c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22,
  c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23,
  c0_.dob AS dob_24,
  c0_.batch_codes_count AS batch_codes_count_25,
  c0_.virtual_wallet_amount AS virtual_wallet_amount_26,
  c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27,
  c0_.money_balance AS money_balance_28,
  c0_.security_code AS security_code_29,
  c0_.id AS id_30,
  c0_.city_id AS city_id_31
FROM
  customer c0_
WHERE
  c0_.id = ?

SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.security_code AS security_code_29, c0_.id AS id_30, c0_.city_id AS city_id_31 FROM customer c0_ WHERE c0_.id = 535179;

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 = 535179;

SELECT
  c0_.external_id AS external_id_0,
  c0_.created_on AS created_on_1,
  c0_.city_id AS city_id_2,
  c0_.email AS email_3,
  c0_.password AS password_4,
  c0_.accept_newsletter AS accept_newsletter_5,
  c0_.transition_id AS transition_id_6,
  c0_.first_name AS first_name_7,
  c0_.last_name AS last_name_8,
  c0_.phone AS phone_9,
  c0_.status AS status_10,
  c0_.balance AS balance_11,
  c0_.registered_from_utm_source AS registered_from_utm_source_12,
  c0_.token AS token_13,
  c0_.totally_unsubscribed AS totally_unsubscribed_14,
  c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15,
  c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16,
  c0_.geo_location_accepted AS geo_location_accepted_17,
  c0_.geo_location AS geo_location_18,
  c0_.telegram_id AS telegram_id_19,
  c0_.site_id AS site_id_20,
  c0_.manager_name AS manager_name_21,
  c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22,
  c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23,
  c0_.dob AS dob_24,
  c0_.batch_codes_count AS batch_codes_count_25,
  c0_.virtual_wallet_amount AS virtual_wallet_amount_26,
  c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27,
  c0_.money_balance AS money_balance_28,
  c0_.security_code AS security_code_29,
  c0_.id AS id_30,
  c0_.city_id AS city_id_31
FROM
  customer c0_
WHERE
  c0_.token = ?

SELECT c0_.external_id AS external_id_0, c0_.created_on AS created_on_1, c0_.city_id AS city_id_2, c0_.email AS email_3, c0_.password AS password_4, c0_.accept_newsletter AS accept_newsletter_5, c0_.transition_id AS transition_id_6, c0_.first_name AS first_name_7, c0_.last_name AS last_name_8, c0_.phone AS phone_9, c0_.status AS status_10, c0_.balance AS balance_11, c0_.registered_from_utm_source AS registered_from_utm_source_12, c0_.token AS token_13, c0_.totally_unsubscribed AS totally_unsubscribed_14, c0_.seen_microphone_tooltip AS seen_microphone_tooltip_15, c0_.not_show_rate_popup_till AS not_show_rate_popup_till_16, c0_.geo_location_accepted AS geo_location_accepted_17, c0_.geo_location AS geo_location_18, c0_.telegram_id AS telegram_id_19, c0_.site_id AS site_id_20, c0_.manager_name AS manager_name_21, c0_.mogilev_mailing_bonus_used AS mogilev_mailing_bonus_used_22, c0_.gomel_mailing_bonus_used AS gomel_mailing_bonus_used_23, c0_.dob AS dob_24, c0_.batch_codes_count AS batch_codes_count_25, c0_.virtual_wallet_amount AS virtual_wallet_amount_26, c0_.virtual_wallet_cashback AS virtual_wallet_cashback_27, c0_.money_balance AS money_balance_28, c0_.security_code AS security_code_29, c0_.id AS id_30, c0_.city_id AS city_id_31 FROM customer c0_ WHERE c0_.token = '5351795e997e952d0622.51592337';

SELECT
  t0.created_on AS created_on_1,
  t0.entity_id AS entity_id_2,
  t0.active AS active_3,
  t0.resource_url AS resource_url_4,
  t0.main_alias AS main_alias_5,
  t0.title AS title_6,
  t0.meta_title AS meta_title_7,
  t0.meta_description AS meta_description_8,
  t0.page_description AS page_description_9,
  t0.meta_keywords AS meta_keywords_10,
  t0.domain AS domain_11,
  t0.id AS id_12
FROM
  seo t0
WHERE
  t0.main_alias = ?
ORDER BY
  t0.id DESC

SELECT t0.created_on AS created_on_1, t0.entity_id AS entity_id_2, t0.active AS active_3, t0.resource_url AS resource_url_4, t0.main_alias AS main_alias_5, t0.title AS title_6, t0.meta_title AS meta_title_7, t0.meta_description AS meta_description_8, t0.page_description AS page_description_9, t0.meta_keywords AS meta_keywords_10, t0.domain AS domain_11, t0.id AS id_12 FROM seo t0 WHERE t0.main_alias = '/partner/online-order/live/refresh' ORDER BY t0.id DESC;