GET https://consultation.localbeta.ovh/home

Query Metrics

6 Database Queries
4 Different statements
183.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 13.59 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.country_id AS country_id_4 FROM speciality t0
Parameters:
[]
2 79.09 ms
SELECT e0_.id AS id_0, e0_.prix AS prix_1, e0_.prix_devise AS prix_devise_2, e0_.devise AS devise_3, e0_.consultation_duration AS consultation_duration_4, e0_.consultation_duration_unite AS consultation_duration_unite_5, e0_.bank_name AS bank_name_6, e0_.bank_address AS bank_address_7, e0_.rib AS rib_8, e0_.iban AS iban_9, e0_.currency AS currency_10, e0_.notes AS notes_11, e0_.file_list AS file_list_12, e0_.cv AS cv_13, e0_.profile_pic AS profile_pic_14, e0_.is_confirmed AS is_confirmed_15, e0_.discription AS discription_16, e0_.discription_cv AS discription_cv_17, e0_.language_spoken AS language_spoken_18, e0_.available AS available_19, e0_.last_seen AS last_seen_20, e0_.speciality_id AS speciality_id_21, e0_.user_id AS user_id_22 FROM expert e0_ LEFT JOIN user u1_ ON e0_.user_id = u1_.id ORDER BY e0_.id DESC LIMIT 20
Parameters:
[]
3 36.80 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.local AS local_8, t0.is_active AS is_active_9, t0.gender AS gender_10, t0.civilite AS civilite_11, t0.country_id AS country_id_12, t13.id AS id_14, t13.prix AS prix_15, t13.prix_devise AS prix_devise_16, t13.devise AS devise_17, t13.consultation_duration AS consultation_duration_18, t13.consultation_duration_unite AS consultation_duration_unite_19, t13.bank_name AS bank_name_20, t13.bank_address AS bank_address_21, t13.rib AS rib_22, t13.iban AS iban_23, t13.currency AS currency_24, t13.notes AS notes_25, t13.file_list AS file_list_26, t13.cv AS cv_27, t13.profile_pic AS profile_pic_28, t13.is_confirmed AS is_confirmed_29, t13.discription AS discription_30, t13.discription_cv AS discription_cv_31, t13.language_spoken AS language_spoken_32, t13.available AS available_33, t13.last_seen AS last_seen_34, t13.speciality_id AS speciality_id_35, t13.user_id AS user_id_36, t37.id AS id_38, t37.nick_name AS nick_name_39, t37.profile_pic AS profile_pic_40, t37.bank_name AS bank_name_41, t37.bank_address AS bank_address_42, t37.rib AS rib_43, t37.iban AS iban_44, t37.currency AS currency_45, t37.hide_picture AS hide_picture_46, t37.use_nickname AS use_nickname_47, t37.user_id AS user_id_48 FROM user t0 LEFT JOIN expert t13 ON t13.user_id = t0.id LEFT JOIN patient t37 ON t37.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  28
]
4 53.56 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.speciality_id AS speciality_id_4, t0.country_id AS country_id_5 FROM sub_speciality t0 INNER JOIN expert_sub_speciality ON t0.id = expert_sub_speciality.sub_speciality_id WHERE expert_sub_speciality.expert_id = ?
Parameters:
[
  15
]
5 0.45 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.local AS local_8, t0.is_active AS is_active_9, t0.gender AS gender_10, t0.civilite AS civilite_11, t0.country_id AS country_id_12, t13.id AS id_14, t13.prix AS prix_15, t13.prix_devise AS prix_devise_16, t13.devise AS devise_17, t13.consultation_duration AS consultation_duration_18, t13.consultation_duration_unite AS consultation_duration_unite_19, t13.bank_name AS bank_name_20, t13.bank_address AS bank_address_21, t13.rib AS rib_22, t13.iban AS iban_23, t13.currency AS currency_24, t13.notes AS notes_25, t13.file_list AS file_list_26, t13.cv AS cv_27, t13.profile_pic AS profile_pic_28, t13.is_confirmed AS is_confirmed_29, t13.discription AS discription_30, t13.discription_cv AS discription_cv_31, t13.language_spoken AS language_spoken_32, t13.available AS available_33, t13.last_seen AS last_seen_34, t13.speciality_id AS speciality_id_35, t13.user_id AS user_id_36, t37.id AS id_38, t37.nick_name AS nick_name_39, t37.profile_pic AS profile_pic_40, t37.bank_name AS bank_name_41, t37.bank_address AS bank_address_42, t37.rib AS rib_43, t37.iban AS iban_44, t37.currency AS currency_45, t37.hide_picture AS hide_picture_46, t37.use_nickname AS use_nickname_47, t37.user_id AS user_id_48 FROM user t0 LEFT JOIN expert t13 ON t13.user_id = t0.id LEFT JOIN patient t37 ON t37.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  27
]
6 0.27 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.name AS name_3, t0.speciality_id AS speciality_id_4, t0.country_id AS country_id_5 FROM sub_speciality t0 INNER JOIN expert_sub_speciality ON t0.id = expert_sub_speciality.sub_speciality_id WHERE expert_sub_speciality.expert_id = ?
Parameters:
[
  13
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Speciality No errors.
App\Entity\Country No errors.
App\Entity\SubSpeciality No errors.
App\Entity\Expert No errors.
App\Entity\User No errors.
App\Entity\Competance No errors.
App\Entity\Availability No errors.
App\Entity\Review No errors.
App\Entity\Consultation No errors.
App\Entity\Notification No errors.
App\Entity\Patient No errors.
App\Entity\Contact No errors.