Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 32
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine 9
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Centrifugo
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.is_active AS is_active_1, u0_.is_blocked AS is_blocked_2, u0_.email AS email_3, u0_.full_name AS full_name_4, u0_.phone AS phone_5, u0_.description AS description_6, u0_.query_params AS query_params_7, u0_.messengers AS messengers_8, u0_.preferred_locale AS preferred_locale_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.firebase_uid AS firebase_uid_11, u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12, u0_.notification_settings AS notification_settings_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.accounts AS accounts_17, u0_.role AS role_18 FROM users u0_ WHERE (LOWER(u0_.email) = ? AND u0_.deleted_at IS NULL) AND u0_.role IN (1, 2)

[
  "dk@redstart.pro"
]

SELECT
  u0_.id AS id_0,
  u0_.is_active AS is_active_1,
  u0_.is_blocked AS is_blocked_2,
  u0_.email AS email_3,
  u0_.full_name AS full_name_4,
  u0_.phone AS phone_5,
  u0_.description AS description_6,
  u0_.query_params AS query_params_7,
  u0_.messengers AS messengers_8,
  u0_.preferred_locale AS preferred_locale_9,
  u0_.stripe_customer_id AS stripe_customer_id_10,
  u0_.firebase_uid AS firebase_uid_11,
  u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12,
  u0_.notification_settings AS notification_settings_13,
  u0_.created_at AS created_at_14,
  u0_.updated_at AS updated_at_15,
  u0_.deleted_at AS deleted_at_16,
  u0_.accounts AS accounts_17,
  u0_.role AS role_18
FROM
  users u0_
WHERE
  (
    LOWER(u0_.email) = ?
    AND u0_.deleted_at IS NULL
  )
  AND u0_.role IN (1, 2)

SELECT u0_.id AS id_0, u0_.is_active AS is_active_1, u0_.is_blocked AS is_blocked_2, u0_.email AS email_3, u0_.full_name AS full_name_4, u0_.phone AS phone_5, u0_.description AS description_6, u0_.query_params AS query_params_7, u0_.messengers AS messengers_8, u0_.preferred_locale AS preferred_locale_9, u0_.stripe_customer_id AS stripe_customer_id_10, u0_.firebase_uid AS firebase_uid_11, u0_.user_uuid_for_create_notification_contact AS user_uuid_for_create_notification_contact_12, u0_.notification_settings AS notification_settings_13, u0_.created_at AS created_at_14, u0_.updated_at AS updated_at_15, u0_.deleted_at AS deleted_at_16, u0_.accounts AS accounts_17, u0_.role AS role_18 FROM users u0_ WHERE (LOWER(u0_.email) = 'dk@redstart.pro' AND u0_.deleted_at IS NULL) AND u0_.role IN (1, 2);

SELECT t0.id AS id_1, t0.business_role AS business_role_2, t0.business_id AS business_id_3, t0.user_id AS user_id_4 FROM business_representatives t0 WHERE t0.user_id = ?

[
  158
]

SELECT
  t0.id AS id_1,
  t0.business_role AS business_role_2,
  t0.business_id AS business_id_3,
  t0.user_id AS user_id_4
FROM
  business_representatives t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.business_role AS business_role_2, t0.business_id AS business_id_3, t0.user_id AS user_id_4 FROM business_representatives t0 WHERE t0.user_id = 158;

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.billing_country_code AS billing_country_code_4, t0.is_campaign_creatable AS is_campaign_creatable_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.registrator_id AS registrator_id_8 FROM businesses t0 WHERE t0.id = ?

[
  "93"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_active AS is_active_3,
  t0.billing_country_code AS billing_country_code_4,
  t0.is_campaign_creatable AS is_campaign_creatable_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.registrator_id AS registrator_id_8
FROM
  businesses t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_active AS is_active_3, t0.billing_country_code AS billing_country_code_4, t0.is_campaign_creatable AS is_campaign_creatable_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.registrator_id AS registrator_id_8 FROM businesses t0 WHERE t0.id = '93';

select id, title, country_code from cities c
                where importance > 0
                order by importance DESC, title, id;

[]

select
  id,
  title,
  country_code
from
  cities c
where
  importance > 0
order by
  importance DESC,
  title,
  id;

select id, title, country_code from cities c
                where importance > 0
                order by importance DESC, title, id;;