GET https://api-dev-bdw.softmena.dev/professionals

Query Metrics

85 Database Queries
9 Different statements
19.25 ms Query time
0 Invalid entities
104 Managed entities

Queries

Group similar statements

# Time Info
1 0.11 ms
SET time_zone = '-03:00'
Parameters:
[]
2 1.29 ms
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
Parameters:
[
  1
  "professional"
  "rejected"
  "deleted"
]
3 0.26 ms
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 = ?
Parameters:
[
  4
]
4 0.24 ms
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 = ?
Parameters:
[
  4
]
5 0.27 ms
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 = ?
Parameters:
[
  85
]
6 0.17 ms
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 = ?
Parameters:
[
  85
]
7 1.19 ms
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 = ?
Parameters:
[
  33
]
8 0.20 ms
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 = ?
Parameters:
[
  33
]
9 0.25 ms
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 = ?
Parameters:
[
  90
]
10 0.16 ms
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 = ?
Parameters:
[
  90
]
11 0.26 ms
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 = ?
Parameters:
[
  80
]
12 0.16 ms
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 = ?
Parameters:
[
  80
]
13 0.22 ms
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 = ?
Parameters:
[
  8
]
14 0.19 ms
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 = ?
Parameters:
[
  8
]
15 0.22 ms
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 = ?
Parameters:
[
  21
]
16 0.16 ms
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 = ?
Parameters:
[
  21
]
17 0.25 ms
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 = ?
Parameters:
[
  12
]
18 0.16 ms
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 = ?
Parameters:
[
  12
]
19 0.22 ms
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 = ?
Parameters:
[
  11
]
20 0.17 ms
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 = ?
Parameters:
[
  11
]
21 0.22 ms
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 = ?
Parameters:
[
  5
]
22 0.14 ms
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 = ?
Parameters:
[
  5
]
23 0.26 ms
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 = ?
Parameters:
[
  1
]
24 0.15 ms
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 = ?
Parameters:
[
  1
]
25 0.22 ms
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 = ?
Parameters:
[
  22
]
26 0.19 ms
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 = ?
Parameters:
[
  22
]
27 0.27 ms
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 = ?
Parameters:
[
  75
]
28 0.20 ms
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 = ?
Parameters:
[
  75
]
29 0.25 ms
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 = ?
Parameters:
[
  25
]
30 0.16 ms
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 = ?
Parameters:
[
  25
]
31 0.22 ms
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 = ?
Parameters:
[
  58
]
32 0.19 ms
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 = ?
Parameters:
[
  58
]
33 0.21 ms
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 = ?
Parameters:
[
  71
]
34 0.16 ms
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 = ?
Parameters:
[
  71
]
35 0.22 ms
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 = ?
Parameters:
[
  23
]
36 0.17 ms
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 = ?
Parameters:
[
  23
]
37 0.20 ms
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 = ?
Parameters:
[
  4
]
38 0.22 ms
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 = ?
Parameters:
[
  1
]
39 0.21 ms
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 = ?
Parameters:
[
  1
]
40 0.26 ms
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
Parameters:
[
  1
  1
]
41 0.17 ms
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 = ?
Parameters:
[
  1
]
42 0.24 ms
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 = ?
Parameters:
[
  85
]
43 0.20 ms
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 = ?
Parameters:
[
  11
]
44 0.20 ms
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
Parameters:
[
  1
  1
]
45 0.19 ms
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 = ?
Parameters:
[
  33
]
46 0.21 ms
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
Parameters:
[
  1
  1
]
47 0.23 ms
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 = ?
Parameters:
[
  90
]
48 0.20 ms
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 = ?
Parameters:
[
  6
]
49 0.21 ms
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
Parameters:
[
  1
  1
]
50 0.19 ms
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 = ?
Parameters:
[
  80
]
51 0.19 ms
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 = ?
Parameters:
[
  29
]
52 0.17 ms
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 = ?
Parameters:
[
  2
]
53 0.19 ms
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 = ?
Parameters:
[
  8
]
54 0.24 ms
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
Parameters:
[
  1
  1
]
55 0.19 ms
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 = ?
Parameters:
[
  21
]
56 0.17 ms
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 = ?
Parameters:
[
  20
]
57 0.17 ms
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 = ?
Parameters:
[
  3
]
58 0.21 ms
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
Parameters:
[
  3
  1
]
59 0.25 ms
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 = ?
Parameters:
[
  12
]
60 0.20 ms
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 = ?
Parameters:
[
  4
]
61 0.25 ms
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
Parameters:
[
  1
  1
]
62 0.19 ms
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 = ?
Parameters:
[
  11
]
63 0.19 ms
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 = ?
Parameters:
[
  41
]
64 0.17 ms
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 = ?
Parameters:
[
  3
]
65 0.21 ms
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 = ?
Parameters:
[
  5
]
66 0.22 ms
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
Parameters:
[
  1
  1
]
67 0.20 ms
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 = ?
Parameters:
[
  1
]
68 0.19 ms
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 = ?
Parameters:
[
  2
]
69 0.24 ms
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
Parameters:
[
  1
  1
]
70 0.19 ms
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 = ?
Parameters:
[
  22
]
71 0.19 ms
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 = ?
Parameters:
[
  40
]
72 0.19 ms
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 = ?
Parameters:
[
  75
]
73 0.21 ms
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
Parameters:
[
  1
  1
]
74 0.19 ms
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 = ?
Parameters:
[
  25
]
75 0.18 ms
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 = ?
Parameters:
[
  9
]
76 0.20 ms
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 = ?
Parameters:
[
  2
]
77 0.21 ms
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
Parameters:
[
  2
  1
]
78 0.19 ms
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 = ?
Parameters:
[
  58
]
79 0.22 ms
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
Parameters:
[
  1
  1
]
80 0.20 ms
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 = ?
Parameters:
[
  71
]
81 0.18 ms
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 = ?
Parameters:
[
  37
]
82 0.22 ms
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 = ?
Parameters:
[
  23
]
83 0.19 ms
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 = ?
Parameters:
[
  57
]
84 0.20 ms
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
Parameters:
[
  1
  1
]
85 0.17 ms
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 = ?
Parameters:
[
  4
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Studies 32
App\Entity\User 17
App\Entity\UserDetails 17
App\Entity\Specialty 17
App\Entity\ProfessionalWallet 14
App\Entity\Dimension 4
App\Entity\Profession 3

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\UserDetails No errors.
App\Entity\Specialty No errors.
App\Entity\Profession No errors.
App\Entity\Dimension No errors.
App\Entity\Studies No errors.
App\Entity\ProfessionalWallet No errors.
App\Entity\Booking No errors.
App\Entity\Availability No errors.
App\Entity\Withdrawal No errors.
App\Entity\Refund No errors.
App\Entity\WalletLedger No errors.