Symfony Profiler

SET
  time_zone = '-03:00'

SET time_zone = '-03:00';

SELECT
  u0_.id AS id_0,
  u0_.uid AS uid_1,
  u0_.email AS email_2,
  u0_.password AS password_3,
  u0_.fcm_token AS fcm_token_4,
  u0_.roles AS roles_5,
  u0_.username AS username_6,
  u0_.first_name AS first_name_7,
  u0_.last_name AS last_name_8,
  u0_.dni AS dni_9,
  u0_.phone_number AS phone_number_10,
  u0_.newsletter_active AS newsletter_active_11,
  u0_.created_at AS created_at_12,
  u0_.updated_at AS updated_at_13,
  u0_.is_active AS is_active_14,
  u0_.status AS status_15,
  u0_.type_account AS type_account_16,
  u0_.response_firebase AS response_firebase_17,
  u0_.verification_token AS verification_token_18,
  u0_.email_verification_code AS email_verification_code_19,
  u0_.is_email_verified AS is_email_verified_20,
  u0_.email_verification_code_expires_at AS email_verification_code_expires_at_21,
  u0_.last_verification_code_sent_at AS last_verification_code_sent_at_22,
  u0_.reset_password_token AS reset_password_token_23,
  u0_.reset_token_expires_at AS reset_token_expires_at_24,
  u0_.permissions AS permissions_25,
  u0_.completed_consultations AS completed_consultations_26,
  u0_.msp_number AS msp_number_27,
  u0_.msp_verification_status AS msp_verification_status_28
FROM
  `user` u0_
WHERE
  (
    u0_.username = ?
    OR u0_.email = ?
  )
  AND u0_.status <> ?

SELECT u0_.id AS id_0, u0_.uid AS uid_1, u0_.email AS email_2, u0_.password AS password_3, u0_.fcm_token AS fcm_token_4, u0_.roles AS roles_5, u0_.username AS username_6, u0_.first_name AS first_name_7, u0_.last_name AS last_name_8, u0_.dni AS dni_9, u0_.phone_number AS phone_number_10, u0_.newsletter_active AS newsletter_active_11, u0_.created_at AS created_at_12, u0_.updated_at AS updated_at_13, u0_.is_active AS is_active_14, u0_.status AS status_15, u0_.type_account AS type_account_16, u0_.response_firebase AS response_firebase_17, u0_.verification_token AS verification_token_18, u0_.email_verification_code AS email_verification_code_19, u0_.is_email_verified AS is_email_verified_20, u0_.email_verification_code_expires_at AS email_verification_code_expires_at_21, u0_.last_verification_code_sent_at AS last_verification_code_sent_at_22, u0_.reset_password_token AS reset_password_token_23, u0_.reset_token_expires_at AS reset_token_expires_at_24, u0_.permissions AS permissions_25, u0_.completed_consultations AS completed_consultations_26, u0_.msp_number AS msp_number_27, u0_.msp_verification_status AS msp_verification_status_28 FROM `user` u0_ WHERE (u0_.username = 'henry_tovar' OR u0_.email = 'henry_tovar') AND u0_.status <> 'deleted';

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.date_birth AS date_birth_3,
  t0.gender AS gender_4,
  t0.country AS country_5,
  t0.city AS city_6,
  t0.zipcode AS zipcode_7,
  t0.address AS address_8,
  t0.language AS language_9,
  t0.about AS about_10,
  t0.phone AS phone_11,
  t0.time_availability AS time_availability_12,
  t0.policies AS policies_13,
  t0.medical_condition AS medical_condition_14,
  t0.consult_time AS consult_time_15,
  t0.short_description AS short_description_16,
  t0.banner_image AS banner_image_17,
  t0.image_original AS image_original_18,
  t0.image_params AS image_params_19,
  t0.banner_image_original AS banner_image_original_20,
  t0.banner_image_params AS banner_image_params_21,
  t0.professional_info AS professional_info_22,
  t0.consult_type AS consult_type_23,
  t0.consult_price AS consult_price_24,
  t0.account_number AS account_number_25,
  t0.holder_name AS holder_name_26,
  t0.bank_name AS bank_name_27,
  t0.profile_media_type AS profile_media_type_28,
  t0.profile_video_url AS profile_video_url_29,
  t0.rejection_reason AS rejection_reason_30,
  t0.user_id AS user_id_31,
  t0.base_profession_id AS base_profession_id_32,
  t0.dimension_id AS dimension_id_33,
  t0.main_specialty_id AS main_specialty_id_34
FROM
  user_details t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.date_birth AS date_birth_3, t0.gender AS gender_4, t0.country AS country_5, t0.city AS city_6, t0.zipcode AS zipcode_7, t0.address AS address_8, t0.language AS language_9, t0.about AS about_10, t0.phone AS phone_11, t0.time_availability AS time_availability_12, t0.policies AS policies_13, t0.medical_condition AS medical_condition_14, t0.consult_time AS consult_time_15, t0.short_description AS short_description_16, t0.banner_image AS banner_image_17, t0.image_original AS image_original_18, t0.image_params AS image_params_19, t0.banner_image_original AS banner_image_original_20, t0.banner_image_params AS banner_image_params_21, t0.professional_info AS professional_info_22, t0.consult_type AS consult_type_23, t0.consult_price AS consult_price_24, t0.account_number AS account_number_25, t0.holder_name AS holder_name_26, t0.bank_name AS bank_name_27, t0.profile_media_type AS profile_media_type_28, t0.profile_video_url AS profile_video_url_29, t0.rejection_reason AS rejection_reason_30, t0.user_id AS user_id_31, t0.base_profession_id AS base_profession_id_32, t0.dimension_id AS dimension_id_33, t0.main_specialty_id AS main_specialty_id_34 FROM user_details t0 WHERE t0.user_id = 7;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.status AS status_3,
  t0.available_balance AS available_balance_4,
  t0.frozen_balance AS frozen_balance_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.professional_id AS professional_id_8
FROM
  professional_wallets t0
WHERE
  t0.professional_id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.status AS status_3, t0.available_balance AS available_balance_4, t0.frozen_balance AS frozen_balance_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.professional_id AS professional_id_8 FROM professional_wallets t0 WHERE t0.professional_id = 7;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.uid AS uid_1,
          n0_.title AS title_2,
          n0_.body AS body_3,
          n0_.type AS type_4,
          n0_.data AS data_5,
          n0_.read_at AS read_at_6,
          n0_.created_at AS created_at_7,
          CASE WHEN n0_.read_at IS NULL THEN
            0
          ELSE
            1
          END AS sclr_8
        FROM
          notification n0_
        WHERE
          n0_.user_id = ?
        ORDER BY
          sclr_8 ASC,
          n0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.uid AS uid_1, n0_.title AS title_2, n0_.body AS body_3, n0_.type AS type_4, n0_.data AS data_5, n0_.read_at AS read_at_6, n0_.created_at AS created_at_7, CASE WHEN n0_.read_at IS NULL THEN 0 ELSE 1 END AS sclr_8 FROM notification n0_ WHERE n0_.user_id = 7 ORDER BY sclr_8 ASC, n0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sclr_8,
      created_at_7
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.uid AS uid_1,
          n0_.title AS title_2,
          n0_.body AS body_3,
          n0_.type AS type_4,
          n0_.data AS data_5,
          n0_.read_at AS read_at_6,
          n0_.created_at AS created_at_7,
          CASE WHEN n0_.read_at IS NULL THEN
            0
          ELSE
            1
          END AS sclr_8
        FROM
          notification n0_
        WHERE
          n0_.user_id = ?
      ) dctrn_result_inner
    ORDER BY
      sclr_8 ASC,
      created_at_7 DESC
  ) dctrn_result
LIMIT
  5

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sclr_8, created_at_7 FROM (SELECT n0_.id AS id_0, n0_.uid AS uid_1, n0_.title AS title_2, n0_.body AS body_3, n0_.type AS type_4, n0_.data AS data_5, n0_.read_at AS read_at_6, n0_.created_at AS created_at_7, CASE WHEN n0_.read_at IS NULL THEN 0 ELSE 1 END AS sclr_8 FROM notification n0_ WHERE n0_.user_id = 7) dctrn_result_inner ORDER BY sclr_8 ASC, created_at_7 DESC) dctrn_result LIMIT 5;

SELECT
  n0_.id AS id_0,
  n0_.uid AS uid_1,
  n0_.title AS title_2,
  n0_.body AS body_3,
  n0_.type AS type_4,
  n0_.data AS data_5,
  n0_.read_at AS read_at_6,
  n0_.created_at AS created_at_7,
  CASE WHEN n0_.read_at IS NULL THEN
    0
  ELSE
    1
  END AS sclr_8,
  n0_.user_id AS user_id_9
FROM
  notification n0_
WHERE
  n0_.user_id = ?
  AND n0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  sclr_8 ASC,
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.uid AS uid_1, n0_.title AS title_2, n0_.body AS body_3, n0_.type AS type_4, n0_.data AS data_5, n0_.read_at AS read_at_6, n0_.created_at AS created_at_7, CASE WHEN n0_.read_at IS NULL THEN 0 ELSE 1 END AS sclr_8, n0_.user_id AS user_id_9 FROM notification n0_ WHERE n0_.user_id = 7 AND n0_.id IN (2290, 2289, 2287, 2285, 2282) ORDER BY sclr_8 ASC, n0_.created_at DESC;