Query Metrics
22
Database Queries
12
Different statements
10.45 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.85 ms |
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.name AS name_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.skin AS skin_8, t0.last_login AS last_login_9, t0.id AS id_10, t0.create_at AS create_at_11, t0.published AS published_12, t0.published_at AS published_at_13, t0.docs AS docs_14, t15.first_name AS first_name_16, t15.last_name AS last_name_17, t15.email AS email_18, t15.phone AS phone_19, t15.wp AS wp_20, t15.specialty AS specialty_21, t15.type_pay AS type_pay_22, t15.pc_pay AS pc_pay_23, t15.min_pay AS min_pay_24, t15.months AS months_25, t15.id AS id_26, t15.create_at AS create_at_27, t15.published AS published_28, t15.published_at AS published_at_29, t15.docs AS docs_30, t15.user_id AS user_id_31, t32.first_name AS first_name_33, t32.last_name AS last_name_34, t32.email AS email_35, t32.phone AS phone_36, t32.wp AS wp_37, t32.type_pay AS type_pay_38, t32.pc_pay AS pc_pay_39, t32.min_pay AS min_pay_40, t32.specialty AS specialty_41, t32.id AS id_42, t32.create_at AS create_at_43, t32.published AS published_44, t32.published_at AS published_at_45, t32.docs AS docs_46, t32.user_id AS user_id_47, t48.first_name AS first_name_49, t48.last_name AS last_name_50, t48.email AS email_51, t48.phone AS phone_52, t48.wp AS wp_53, t48.specialty AS specialty_54, t48.type_pay AS type_pay_55, t48.pc_pay AS pc_pay_56, t48.min_pay AS min_pay_57, t48.id AS id_58, t48.create_at AS create_at_59, t48.published AS published_60, t48.published_at AS published_at_61, t48.docs AS docs_62, t48.user_id AS user_id_63, t64.first_name AS first_name_65, t64.last_name AS last_name_66, t64.first_name_ar AS first_name_ar_67, t64.last_name_ar AS last_name_ar_68, t64.cin AS cin_69, t64.gender AS gender_70, t64.birth_in AS birth_in_71, t64.birth_in_ar AS birth_in_ar_72, t64.birth_at AS birth_at_73, t64.nationality AS nationality_74, t64.phone AS phone_75, t64.phone2 AS phone2_76, t64.wp AS wp_77, t64.email AS email_78, t64.address AS address_79, t64.address_ar AS address_ar_80, t64.city AS city_81, t64.school_level AS school_level_82, t64.school_last AS school_last_83, t64.registration_number AS registration_number_84, t64.serie_number AS serie_number_85, t64.id_massar AS id_massar_86, t64.diplome_number AS diplome_number_87, t64.registration_at AS registration_at_88, t64.status AS status_89, t64.status_at AS status_at_90, t64.image_name AS image_name_91, t64.cin_image AS cin_image_92, t64.school_level_image AS school_level_image_93, t64.monthly_payment AS monthly_payment_94, t64.register_fees AS register_fees_95, t64.exam_fees AS exam_fees_96, t64.diploma_fees AS diploma_fees_97, t64.discount AS discount_98, t64.plain_password AS plain_password_99, t64.id AS id_100, t64.create_at AS create_at_101, t64.published AS published_102, t64.published_at AS published_at_103, t64.docs AS docs_104, t64.user_id AS user_id_105, t64.groupe_id AS groupe_id_106, t107.first_name AS first_name_108, t107.last_name AS last_name_109, t107.first_name_ar AS first_name_ar_110, t107.last_name_ar AS last_name_ar_111, t107.cin AS cin_112, t107.gender AS gender_113, t107.birth_in AS birth_in_114, t107.birth_in_ar AS birth_in_ar_115, t107.birth_at AS birth_at_116, t107.nationality AS nationality_117, t107.phone AS phone_118, t107.phone2 AS phone2_119, t107.wp AS wp_120, t107.email AS email_121, t107.address AS address_122, t107.address_ar AS address_ar_123, t107.city AS city_124, t107.school_level AS school_level_125, t107.school_last AS school_last_126, t107.registration_number AS registration_number_127, t107.serie_number AS serie_number_128, t107.id_massar AS id_massar_129, t107.diplome_number AS diplome_number_130, t107.registration_at AS registration_at_131, t107.status AS status_132, t107.status_at AS status_at_133, t107.image_name AS image_name_134, t107.cin_image AS cin_image_135, t107.school_level_image AS school_level_image_136, t107.monthly_payment AS monthly_payment_137, t107.register_costs AS register_costs_138, t107.other_costs AS other_costs_139, t107.diploma_costs AS diploma_costs_140, t107.discount AS discount_141, t107.plain_password AS plain_password_142, t107.training_duration AS training_duration_143, t107.id AS id_144, t107.create_at AS create_at_145, t107.published AS published_146, t107.published_at AS published_at_147, t107.docs AS docs_148, t107.user_id AS user_id_149, t107.classe_id AS classe_id_150 FROM hs_tc_user t0 LEFT JOIN hs_tc_training_former t15 ON t15.user_id = t0.id LEFT JOIN hs_tc_tutoring_tutor t32 ON t32.user_id = t0.id LEFT JOIN hs_tc_formation_intervenant t48 ON t48.user_id = t0.id LEFT JOIN hs_tc_training_trainee t64 ON t64.user_id = t0.id LEFT JOIN hs_tc_formation_participant t107 ON t107.user_id = t0.id WHERE t0.id = ?
Parameters:
[
8
]
|
| 2 | 0.53 ms |
SELECT h0_.costs AS costs_0, h0_.way AS way_1, h0_.amount AS amount_2, h0_.doc_number AS doc_number_3, h0_.moyen AS moyen_4, h0_.id AS id_5, h0_.create_at AS create_at_6, h0_.published AS published_7, h0_.published_at AS published_at_8, h0_.docs AS docs_9, h0_.participant_id AS participant_id_10, h0_.initie_id AS initie_id_11 FROM hs_tc_formation_apayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 3 | 1.83 ms |
SELECT h0_.way AS way_0, h0_.amount AS amount_1, h0_.moyen AS moyen_2, h0_.doc_number AS doc_number_3, h0_.receipt AS receipt_4, h0_.cached AS cached_5, h0_.id AS id_6, h0_.create_at AS create_at_7, h0_.published AS published_8, h0_.published_at AS published_at_9, h0_.docs AS docs_10, h0_.rowscourse_id AS rowscourse_id_11, h0_.initie_id AS initie_id_12 FROM hs_tc_tutoring_spayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 4 | 0.54 ms |
SELECT h0_.fees AS fees_0, h0_.way AS way_1, h0_.amount AS amount_2, h0_.doc_number AS doc_number_3, h0_.moyen AS moyen_4, h0_.id AS id_5, h0_.create_at AS create_at_6, h0_.published AS published_7, h0_.published_at AS published_at_8, h0_.docs AS docs_9, h0_.trainee_id AS trainee_id_10, h0_.initie_id AS initie_id_11 FROM hs_tc_training_fpayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 5 | 0.63 ms |
SELECT h0_.participant_id AS participant_id_0, h0_.classe_id AS classe_id_1, h0_.classe_name AS classe_name_2, h0_.participant_first_name AS participant_first_name_3, h0_.participant_last_name AS participant_last_name_4, h0_.costs AS costs_5, h0_.way AS way_6, h0_.amount AS amount_7, h0_.doc_number AS doc_number_8, h0_.moyen AS moyen_9, h0_.trashed_at AS trashed_at_10, h0_.id AS id_11, h0_.create_at AS create_at_12, h0_.published AS published_13, h0_.published_at AS published_at_14, h0_.docs AS docs_15, h0_.initie_id AS initie_id_16, h0_.suppressor_id AS suppressor_id_17 FROM hs_tc_formation_trashapayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 6 | 0.92 ms |
SELECT h0_.rows_cours_id AS rows_cours_id_0, h0_.cours_id AS cours_id_1, h0_.student_id AS student_id_2, h0_.rows_cours_price AS rows_cours_price_3, h0_.cours_name AS cours_name_4, h0_.student_first_name AS student_first_name_5, h0_.student_last_name AS student_last_name_6, h0_.student_level AS student_level_7, h0_.way AS way_8, h0_.amount AS amount_9, h0_.moyen AS moyen_10, h0_.doc_number AS doc_number_11, h0_.cached AS cached_12, h0_.trashed_at AS trashed_at_13, h0_.id AS id_14, h0_.create_at AS create_at_15, h0_.published AS published_16, h0_.published_at AS published_at_17, h0_.docs AS docs_18, h0_.initie_id AS initie_id_19, h0_.suppressor_id AS suppressor_id_20 FROM hs_tc_tutoring_trashspayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 7 | 0.67 ms |
SELECT h0_.trainee_id AS trainee_id_0, h0_.groupe_id AS groupe_id_1, h0_.groupe_name AS groupe_name_2, h0_.trainee_first_name AS trainee_first_name_3, h0_.trainee_last_name AS trainee_last_name_4, h0_.fees AS fees_5, h0_.way AS way_6, h0_.amount AS amount_7, h0_.doc_number AS doc_number_8, h0_.moyen AS moyen_9, h0_.trashed_at AS trashed_at_10, h0_.id AS id_11, h0_.create_at AS create_at_12, h0_.published AS published_13, h0_.published_at AS published_at_14, h0_.docs AS docs_15, h0_.initie_id AS initie_id_16, h0_.suppressor_id AS suppressor_id_17 FROM hs_tc_training_trashfpayment h0_ WHERE h0_.create_at >= ? AND h0_.create_at <= ?
Parameters:
[ "2026-09-11 00:00:00" "2026-09-11 23:59:00" ] |
| 8 | 0.29 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ?
Parameters:
[
"Informations"
]
|
| 9 | 0.24 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ?
Parameters:
[
"Coordonnées"
]
|
| 10 | 0.39 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ?
Parameters:
[
"Informations"
]
|
| 11 | 0.26 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.type AS type_3, t0.val AS val_4, t0.category AS category_5, t0.show_in_home AS show_in_home_6, t0.show_in_contact AS show_in_contact_7, t0.id AS id_8, t0.create_at AS create_at_9, t0.published AS published_10, t0.published_at AS published_at_11, t0.docs AS docs_12 FROM hs_tc_information t0 WHERE t0.category = ?
Parameters:
[
"Coordonnées"
]
|
| 12 | 0.42 ms |
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.first_name_ar AS first_name_ar_3, t0.last_name_ar AS last_name_ar_4, t0.cin AS cin_5, t0.gender AS gender_6, t0.birth_in AS birth_in_7, t0.birth_in_ar AS birth_in_ar_8, t0.birth_at AS birth_at_9, t0.nationality AS nationality_10, t0.phone AS phone_11, t0.phone2 AS phone2_12, t0.wp AS wp_13, t0.email AS email_14, t0.address AS address_15, t0.address_ar AS address_ar_16, t0.city AS city_17, t0.school_level AS school_level_18, t0.school_last AS school_last_19, t0.registration_number AS registration_number_20, t0.serie_number AS serie_number_21, t0.id_massar AS id_massar_22, t0.diplome_number AS diplome_number_23, t0.registration_at AS registration_at_24, t0.status AS status_25, t0.status_at AS status_at_26, t0.image_name AS image_name_27, t0.cin_image AS cin_image_28, t0.school_level_image AS school_level_image_29, t0.monthly_payment AS monthly_payment_30, t0.register_costs AS register_costs_31, t0.other_costs AS other_costs_32, t0.diploma_costs AS diploma_costs_33, t0.discount AS discount_34, t0.plain_password AS plain_password_35, t0.training_duration AS training_duration_36, t0.id AS id_37, t0.create_at AS create_at_38, t0.published AS published_39, t0.published_at AS published_at_40, t0.docs AS docs_41, t0.user_id AS user_id_42, t0.classe_id AS classe_id_43 FROM hs_tc_formation_participant t0 WHERE t0.id = ?
Parameters:
[
157
]
|
| 13 | 0.31 ms |
SELECT t0.label AS label_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.monthly_payment AS monthly_payment_4, t0.register_costs AS register_costs_5, t0.other_costs AS other_costs_6, t0.nbr_months AS nbr_months_7, t0.list_months AS list_months_8, t0.graduation_at AS graduation_at_9, t0.opened AS opened_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.published AS published_13, t0.published_at AS published_at_14, t0.docs AS docs_15, t0.activity_id AS activity_id_16, t0.schoolyear_id AS schoolyear_id_17, t0.responsable_id AS responsable_id_18 FROM hs_tc_formation_classe t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 14 | 0.29 ms |
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 15 | 0.36 ms |
SELECT t0.title AS title_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.current AS current_4, t0.opened AS opened_5, t0.msg_registration AS msg_registration_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.previous_id AS previous_id_12, t13.title AS title_14, t13.start_at AS start_at_15, t13.end_at AS end_at_16, t13.current AS current_17, t13.opened AS opened_18, t13.msg_registration AS msg_registration_19, t13.id AS id_20, t13.create_at AS create_at_21, t13.published AS published_22, t13.published_at AS published_at_23, t13.docs AS docs_24, t13.previous_id AS previous_id_25 FROM hs_tc_schoolyear t0 LEFT JOIN hs_tc_schoolyear t13 ON t13.previous_id = t0.id WHERE t0.id = ?
Parameters:
[
7
]
|
| 16 | 0.36 ms |
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.first_name_ar AS first_name_ar_3, t0.last_name_ar AS last_name_ar_4, t0.cin AS cin_5, t0.gender AS gender_6, t0.birth_in AS birth_in_7, t0.birth_in_ar AS birth_in_ar_8, t0.birth_at AS birth_at_9, t0.nationality AS nationality_10, t0.phone AS phone_11, t0.phone2 AS phone2_12, t0.wp AS wp_13, t0.email AS email_14, t0.address AS address_15, t0.address_ar AS address_ar_16, t0.city AS city_17, t0.school_level AS school_level_18, t0.school_last AS school_last_19, t0.registration_number AS registration_number_20, t0.serie_number AS serie_number_21, t0.id_massar AS id_massar_22, t0.diplome_number AS diplome_number_23, t0.registration_at AS registration_at_24, t0.status AS status_25, t0.status_at AS status_at_26, t0.image_name AS image_name_27, t0.cin_image AS cin_image_28, t0.school_level_image AS school_level_image_29, t0.monthly_payment AS monthly_payment_30, t0.register_costs AS register_costs_31, t0.other_costs AS other_costs_32, t0.diploma_costs AS diploma_costs_33, t0.discount AS discount_34, t0.plain_password AS plain_password_35, t0.training_duration AS training_duration_36, t0.id AS id_37, t0.create_at AS create_at_38, t0.published AS published_39, t0.published_at AS published_at_40, t0.docs AS docs_41, t0.user_id AS user_id_42, t0.classe_id AS classe_id_43 FROM hs_tc_formation_participant t0 WHERE t0.id = ?
Parameters:
[
156
]
|
| 17 | 0.27 ms |
SELECT t0.label AS label_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.monthly_payment AS monthly_payment_4, t0.register_costs AS register_costs_5, t0.other_costs AS other_costs_6, t0.nbr_months AS nbr_months_7, t0.list_months AS list_months_8, t0.graduation_at AS graduation_at_9, t0.opened AS opened_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.published AS published_13, t0.published_at AS published_at_14, t0.docs AS docs_15, t0.activity_id AS activity_id_16, t0.schoolyear_id AS schoolyear_id_17, t0.responsable_id AS responsable_id_18 FROM hs_tc_formation_classe t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 18 | 0.23 ms |
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 19 | 0.33 ms |
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.first_name_ar AS first_name_ar_3, t0.last_name_ar AS last_name_ar_4, t0.cin AS cin_5, t0.gender AS gender_6, t0.birth_in AS birth_in_7, t0.birth_in_ar AS birth_in_ar_8, t0.birth_at AS birth_at_9, t0.nationality AS nationality_10, t0.phone AS phone_11, t0.phone2 AS phone2_12, t0.wp AS wp_13, t0.email AS email_14, t0.address AS address_15, t0.address_ar AS address_ar_16, t0.city AS city_17, t0.school_level AS school_level_18, t0.school_last AS school_last_19, t0.registration_number AS registration_number_20, t0.serie_number AS serie_number_21, t0.id_massar AS id_massar_22, t0.diplome_number AS diplome_number_23, t0.registration_at AS registration_at_24, t0.status AS status_25, t0.status_at AS status_at_26, t0.image_name AS image_name_27, t0.cin_image AS cin_image_28, t0.school_level_image AS school_level_image_29, t0.monthly_payment AS monthly_payment_30, t0.register_costs AS register_costs_31, t0.other_costs AS other_costs_32, t0.diploma_costs AS diploma_costs_33, t0.discount AS discount_34, t0.plain_password AS plain_password_35, t0.training_duration AS training_duration_36, t0.id AS id_37, t0.create_at AS create_at_38, t0.published AS published_39, t0.published_at AS published_at_40, t0.docs AS docs_41, t0.user_id AS user_id_42, t0.classe_id AS classe_id_43 FROM hs_tc_formation_participant t0 WHERE t0.id = ?
Parameters:
[
158
]
|
| 20 | 0.25 ms |
SELECT t0.label AS label_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.monthly_payment AS monthly_payment_4, t0.register_costs AS register_costs_5, t0.other_costs AS other_costs_6, t0.nbr_months AS nbr_months_7, t0.list_months AS list_months_8, t0.graduation_at AS graduation_at_9, t0.opened AS opened_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.published AS published_13, t0.published_at AS published_at_14, t0.docs AS docs_15, t0.activity_id AS activity_id_16, t0.schoolyear_id AS schoolyear_id_17, t0.responsable_id AS responsable_id_18 FROM hs_tc_formation_classe t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 21 | 0.20 ms |
SELECT t0.title AS title_1, t0.title_ar AS title_ar_2, t0.diploma AS diploma_3, t0.slug AS slug_4, t0.forder AS forder_5, t0.featured AS featured_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.published AS published_9, t0.published_at AS published_at_10, t0.docs AS docs_11, t0.category_id AS category_id_12, t0.domaine_id AS domaine_id_13 FROM hs_tc_formation_activity t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 22 | 0.28 ms |
SELECT t0.first_name AS first_name_1, t0.last_name AS last_name_2, t0.first_name_ar AS first_name_ar_3, t0.last_name_ar AS last_name_ar_4, t0.cin AS cin_5, t0.gender AS gender_6, t0.birth_in AS birth_in_7, t0.birth_in_ar AS birth_in_ar_8, t0.birth_at AS birth_at_9, t0.nationality AS nationality_10, t0.phone AS phone_11, t0.phone2 AS phone2_12, t0.wp AS wp_13, t0.email AS email_14, t0.address AS address_15, t0.address_ar AS address_ar_16, t0.city AS city_17, t0.school_level AS school_level_18, t0.school_last AS school_last_19, t0.registration_number AS registration_number_20, t0.serie_number AS serie_number_21, t0.id_massar AS id_massar_22, t0.diplome_number AS diplome_number_23, t0.registration_at AS registration_at_24, t0.status AS status_25, t0.status_at AS status_at_26, t0.image_name AS image_name_27, t0.cin_image AS cin_image_28, t0.school_level_image AS school_level_image_29, t0.monthly_payment AS monthly_payment_30, t0.register_costs AS register_costs_31, t0.other_costs AS other_costs_32, t0.diploma_costs AS diploma_costs_33, t0.discount AS discount_34, t0.plain_password AS plain_password_35, t0.training_duration AS training_duration_36, t0.id AS id_37, t0.create_at AS create_at_38, t0.published AS published_39, t0.published_at AS published_at_40, t0.docs AS docs_41, t0.user_id AS user_id_42, t0.classe_id AS classe_id_43 FROM hs_tc_formation_participant t0 WHERE t0.id = ?
Parameters:
[
159
]
|
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.