Query Metrics
9
Database Queries
8
Different statements
6.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.83 ms (28.19%) |
1 |
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" ] |
|
0.92 ms (14.17%) |
1 |
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" ] |
|
0.85 ms (13.06%) |
1 |
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
]
|
|
0.67 ms (10.37%) |
1 |
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" ] |
|
0.63 ms (9.63%) |
1 |
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" ] |
|
0.54 ms (8.27%) |
1 |
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" ] |
|
0.53 ms (8.16%) |
2 |
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"
]
|
|
0.53 ms (8.13%) |
1 |
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" ] |
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\User | No errors. |
| App\Entity\Training\Former | No errors. |
| App\Entity\Tutoring\Tutor | No errors. |
| App\Entity\Formation\Intervenant | No errors. |
| App\Entity\Training\Trainee | No errors. |
| App\Entity\Training\Groupe | No errors. |
| App\Entity\Formation\Participant | No errors. |
| App\Entity\Formation\Classe | No errors. |
| App\Entity\Notification | No errors. |
| App\Entity\Formation\Apayment | No errors. |
| App\Entity\Tutoring\Course | No errors. |
| App\Entity\Formation\Apayline | No errors. |
| App\Entity\Tutoring\Spayment | No errors. |
| App\Entity\Tutoring\Rowscourse | No errors. |
| App\Entity\Training\Fpayment | No errors. |
| App\Entity\Formation\Trashapayment | No errors. |
| App\Entity\Tutoring\Trashspayment | No errors. |
| App\Entity\Training\Trashfpayment | No errors. |
| App\Entity\Information | No errors. |