Symfony Profiler

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.institute AS institute_3,
  t0.type AS type_4,
  t0.date_start AS date_start_5,
  t0.date_end AS date_end_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.uid AS uid_9,
  t0.url_certificate AS url_certificate_10,
  t0.is_validated AS is_validated_11,
  t0.user_id AS user_id_12,
  t0.specialty_id AS specialty_id_13
FROM
  studies t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.institute AS institute_3, t0.type AS type_4, t0.date_start AS date_start_5, t0.date_end AS date_end_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.uid AS uid_9, t0.url_certificate AS url_certificate_10, t0.is_validated AS is_validated_11, t0.user_id AS user_id_12, t0.specialty_id AS specialty_id_13 FROM studies t0 WHERE t0.user_id = 4;

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

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.legal_framework AS legal_framework_5,
  t0.clinical_level AS clinical_level_6,
  t0.msp_required AS msp_required_7,
  t0.is_base_profession AS is_base_profession_8,
  t0.public_title_male AS public_title_male_9,
  t0.public_title_female AS public_title_female_10,
  t0.public_title_neutral AS public_title_neutral_11,
  t0.description AS description_12,
  t0.alias AS alias_13,
  t0.cover_wards AS cover_wards_14,
  t0.dimension_id AS dimension_id_15,
  t0.required_base_study_id AS required_base_study_id_16
FROM
  specialty t0
WHERE
  t0.required_base_study_id = ?
  AND t0.is_base_profession = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.name AS name_3, t0.slug AS slug_4, t0.legal_framework AS legal_framework_5, t0.clinical_level AS clinical_level_6, t0.msp_required AS msp_required_7, t0.is_base_profession AS is_base_profession_8, t0.public_title_male AS public_title_male_9, t0.public_title_female AS public_title_female_10, t0.public_title_neutral AS public_title_neutral_11, t0.description AS description_12, t0.alias AS alias_13, t0.cover_wards AS cover_wards_14, t0.dimension_id AS dimension_id_15, t0.required_base_study_id AS required_base_study_id_16 FROM specialty t0 WHERE t0.required_base_study_id = 1 AND t0.is_base_profession = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.legal_framework AS legal_framework_5,
  t0.clinical_level AS clinical_level_6,
  t0.msp_required AS msp_required_7,
  t0.is_base_profession AS is_base_profession_8,
  t0.public_title_male AS public_title_male_9,
  t0.public_title_female AS public_title_female_10,
  t0.public_title_neutral AS public_title_neutral_11,
  t0.description AS description_12,
  t0.alias AS alias_13,
  t0.cover_wards AS cover_wards_14,
  t0.dimension_id AS dimension_id_15,
  t0.required_base_study_id AS required_base_study_id_16
FROM
  specialty t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.name AS name_3, t0.slug AS slug_4, t0.legal_framework AS legal_framework_5, t0.clinical_level AS clinical_level_6, t0.msp_required AS msp_required_7, t0.is_base_profession AS is_base_profession_8, t0.public_title_male AS public_title_male_9, t0.public_title_female AS public_title_female_10, t0.public_title_neutral AS public_title_neutral_11, t0.description AS description_12, t0.alias AS alias_13, t0.cover_wards AS cover_wards_14, t0.dimension_id AS dimension_id_15, t0.required_base_study_id AS required_base_study_id_16 FROM specialty t0 WHERE t0.id = 1;

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,
  (0) AS sclr_29
FROM
  `user` u0_
  LEFT JOIN user_details u1_ ON u0_.id = u1_.user_id
  LEFT JOIN specialty s2_ ON u1_.main_specialty_id = s2_.id
  LEFT JOIN profession p3_ ON u1_.base_profession_id = p3_.id
  LEFT JOIN professional_specialties p5_ ON u0_.id = p5_.user_id
  LEFT JOIN specialty s4_ ON s4_.id = p5_.specialty_id
  LEFT JOIN dimension d6_ ON s2_.dimension_id = d6_.id
  INNER JOIN studies s7_ ON u0_.id = s7_.user_id
WHERE
  s7_.is_validated = ?
  AND u0_.type_account = ?
  AND u0_.status NOT IN (?, ?)
GROUP BY
  u0_.id
ORDER BY
  sclr_29 DESC,
  u0_.completed_consultations DESC,
  u0_.first_name ASC,
  u0_.last_name ASC

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, (0) AS sclr_29 FROM `user` u0_ LEFT JOIN user_details u1_ ON u0_.id = u1_.user_id LEFT JOIN specialty s2_ ON u1_.main_specialty_id = s2_.id LEFT JOIN profession p3_ ON u1_.base_profession_id = p3_.id LEFT JOIN professional_specialties p5_ ON u0_.id = p5_.user_id LEFT JOIN specialty s4_ ON s4_.id = p5_.specialty_id LEFT JOIN dimension d6_ ON s2_.dimension_id = d6_.id INNER JOIN studies s7_ ON u0_.id = s7_.user_id WHERE s7_.is_validated = 1 AND u0_.type_account = 'professional' AND u0_.status NOT IN ('rejected', 'deleted') GROUP BY u0_.id ORDER BY sclr_29 DESC, u0_.completed_consultations DESC, u0_.first_name ASC, u0_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.uid AS uid_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.color_code AS color_code_5,
  t0.icon AS icon_6
FROM
  dimension t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uid AS uid_2, t0.name AS name_3, t0.slug AS slug_4, t0.color_code AS color_code_5, t0.icon AS icon_6 FROM dimension t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.uid AS uid_6,
  t0.legal_framework AS legal_framework_7,
  t0.requires_msp AS requires_msp_8
FROM
  profession t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uid AS uid_6, t0.legal_framework AS legal_framework_7, t0.requires_msp AS requires_msp_8 FROM profession t0 WHERE t0.id = 1;

SET
  time_zone = '-03:00'

SET time_zone = '-03:00';