Query Metrics
28
Database Queries
12
Different statements
598.63 ms
Query time
2
Invalid entities
17
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
572.31 ms (95.60%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.father_name AS father_name_3, t0.email AS email_4, t0.mobile AS mobile_5, t0.class AS class_6, t0.mother_name AS mother_name_7, t0.is_paid AS is_paid_8, t0.uni_key AS uni_key_9, t0.attendance_status AS attendance_status_10, t0.gurbani AS gurbani_11, t0.sik_history AS sik_history_12, t0.gurmat AS gurmat_13, t0.total_marks AS total_marks_14, t0.marks_percentage AS marks_percentage_15, t0.marks_date AS marks_date_16, t0.attendance_date AS attendance_date_17, t0.total AS total_18, t0.dp_roll_number AS dp_roll_number_19, t0.is_punjab AS is_punjab_20, t0.grade AS grade_21, t0.grace_number_data AS grace_number_data_22, t0.certificate_number AS certificate_number_23, t0.merit AS merit_24, t0.dp_group_id AS dp_group_id_25, t0.school_id AS school_id_26, t0.dp_season_id AS dp_season_id_27, t0.dp_exam_id AS dp_exam_id_28, t0.dp_languages_id AS dp_languages_id_29, t0.dp_student_lot_id AS dp_student_lot_id_30, t0.roll_number_id AS roll_number_id_31, t0.center_id AS center_id_32, t0.filled_by_id AS filled_by_id_33, t0.attendence_user_id AS attendence_user_id_34 FROM dp_student t0 WHERE t0.uni_key = ? AND t0.dp_season_id = ? LIMIT 1
Parameters:
[ "bec0a40c348f48e4b6edad52c7665a6ba659a837" 5 ] |
|
9.35 ms (1.56%) |
1 |
INSERT INTO dp_student_lot (receipt, amount, total_student, dated, created_on, is_verified, is_saved, created_by, is_disabled, circle_id, member_id, school_id, dp_group_id, dp_season_id, dp_exam_id, center_id, admin_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "A-12246" "240" "6" "2026-05-25 00:00:00" "2026-06-07 15:02:00" 0 1 "member" 0 95 1114 8952 3 5 6 8952 null ] |
|
5.53 ms (0.92%) |
6 |
INSERT INTO dp_student (name, father_name, email, mobile, class, mother_name, is_paid, uni_key, attendance_status, gurbani, sik_history, gurmat, total_marks, marks_percentage, marks_date, attendance_date, total, dp_roll_number, is_punjab, grade, grace_number_data, certificate_number, merit, dp_group_id, school_id, dp_season_id, dp_exam_id, dp_languages_id, dp_student_lot_id, roll_number_id, center_id, filled_by_id, attendence_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "HARNOOR KAUR" "KULJEET SINGH" "[email protected]" "6283379683" "{"label":"Class 10","value":"10"}" "JASDEEP KAUR" 0 "bec0a40c348f48e4b6edad52c7665a6ba659a837" "p" null null null null null null null null null 1 null "[]" null 0 3 8952 5 6 1 29471 null 8952 null null ] |
|
3.60 ms (0.60%) |
6 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM dp_languages t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
|
1.89 ms (0.31%) |
2 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.address1 AS address1_4, t0.address2 AS address2_5, t0.address3 AS address3_6, t0.city AS city_7, t0.phone AS phone_8, t0.pin AS pin_9, t0.email AS email_10, t0.roles AS roles_11, t0.password AS password_12, t0.mobile AS mobile_13, t0.password_reset_key AS password_reset_key_14, t0.password_reset_key_time AS password_reset_key_time_15, t0.is_valid AS is_valid_16, t0.teacher_name AS teacher_name_17, t0.teacher_email AS teacher_email_18, t0.teacher_mobile AS teacher_mobile_19, t0.is_verified AS is_verified_20, t0.deleted AS deleted_21, t0.is_unsubscribe AS is_unsubscribe_22, t0.unsubscribe_at AS unsubscribe_at_23, t0.unsubscribe_key AS unsubscribe_key_24, t0.circle_id AS circle_id_25, t0.state_id AS state_id_26 FROM school t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"8952"
]
|
|
1.66 ms (0.28%) |
1 |
"COMMIT"
Parameters:
[] |
|
1.49 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.msf_code AS msf_code_5, t0.msf_old AS msf_old_6, t0.name AS name_7, t0.father_name AS father_name_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.address3 AS address3_11, t0.city AS city_12, t0.phones AS phones_13, t0.education AS education_14, t0.amrit_dhari AS amrit_dhari_15, t0.subs_date AS subs_date_16, t0.job_name AS job_name_17, t0.job_addr1 AS job_addr1_18, t0.job_addr2 AS job_addr2_19, t0.vehicle AS vehicle_20, t0.suspend AS suspend_21, t0.entry_date AS entry_date_22, t0.subc_dtf AS subc_dtf_23, t0.subc_dtt AS subc_dtt_24, t0.mobile AS mobile_25, t0.is_mobile_verified AS is_mobile_verified_26, t0.mobile_verification_code AS mobile_verification_code_27, t0.mobile_verification_date AS mobile_verification_date_28, t0.email AS email_29, t0.email_verification_date AS email_verification_date_30, t0.email_verification_code AS email_verification_code_31, t0.marital_status AS marital_status_32, t0.date_of_birth AS date_of_birth_33, t0.pincode AS pincode_34, t0.update_on AS update_on_35, t0.education_stage AS education_stage_36, t0.education_type AS education_type_37, t0.spouse_name AS spouse_name_38, t0.gender AS gender_39, t0.expire_date AS expire_date_40, t0.membership_type AS membership_type_41, t0.status AS status_42, t0.password_reset_key AS password_reset_key_43, t0.password_reset_key_time AS password_reset_key_time_44, t0.auto_login_key AS auto_login_key_45, t0.m_app_key AS m_app_key_46, t0.is_deleted AS is_deleted_47, t0.reason AS reason_48, t0.guid AS guid_49, t0.ref_url AS ref_url_50, t0.old_key AS old_key_51, t0.circle_id AS circle_id_52, t0.country_id AS country_id_53, t0.state_id AS state_id_54 FROM member t0 WHERE t0.id = ?
Parameters:
[
1114
]
|
|
0.72 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso AS iso_3, t0.is_enabled AS is_enabled_4, t0.country_id AS country_id_5 FROM state t0 WHERE t0.id = ?
Parameters:
[
19
]
|
|
0.70 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.languages AS languages_3, t0.dp_season_id AS dp_season_id_4 FROM dp_exam t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"6"
]
|
|
0.69 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_current AS is_current_3, t0.result_declared AS result_declared_4 FROM dp_season t0 WHERE t0.is_current = ? LIMIT 1
Parameters:
[
1
]
|
|
0.53 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.classes AS classes_3, t0.price AS price_4 FROM dp_group t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"3"
]
|
|
0.16 ms (0.03%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\DpStudent | 6 |
| App\Entity\State | 2 |
| App\Entity\Member | 1 |
| App\Entity\Circle | 1 |
| App\Entity\Country | 1 |
| App\Entity\School | 1 |
| App\Entity\DpGroup | 1 |
| App\Entity\DpSeason | 1 |
| App\Entity\DpExam | 1 |
| App\Entity\DpLanguages | 1 |
| App\Entity\DpStudentLot | 1 |