Query Metrics
6
Database Queries
4
Different statements
183.77 ms
Query time
0
Invalid entities
Queries
| #▲ | 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. |