Query Metrics
12
Database Queries
12
Different statements
122.29 ms
Query time
2
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.17 ms |
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 = ?
Parameters:
[
864
]
|
| 2 | 0.43 ms |
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:
[
"864"
]
|
| 3 | 0.24 ms |
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:
[
"1"
]
|
| 4 | 0.39 ms |
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
]
|
| 5 | 0.26 ms |
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"
]
|
| 6 | 105.01 ms |
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:
[ "515f764219a2743f7489f18a0073b79a79e8983a" 5 ] |
| 7 | 0.38 ms |
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
]
|
| 8 | 0.47 ms |
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
]
|
| 9 | 0.15 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 2.64 ms |
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:
[ "NA" "30" "1" "2026-06-06 00:00:00" "2026-06-06 09:02:50" 0 1 "school" 0 714 null 864 1 5 6 864 null ] |
| 11 | 2.01 ms |
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:
[ "GURSHARNVIR SINGH" "KULWINDER SINGH" "[email protected]" "8968837294" "{"label":"Class 5","value":"5"}" "KAWALJIT KAUR" 0 "515f764219a2743f7489f18a0073b79a79e8983a" "p" null null null null null null null null null 1 null "[]" null 0 1 864 5 6 1 29327 null 864 null null ] |
| 12 | 3.17 ms |
"COMMIT"
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\School | 1 |
| App\Entity\Circle | 1 |
| App\Entity\State | 1 |
| App\Entity\DpGroup | 1 |
| App\Entity\DpSeason | 1 |
| App\Entity\DpExam | 1 |
| App\Entity\DpLanguages | 1 |
| App\Entity\Country | 1 |
| App\Entity\DpStudentLot | 1 |
| App\Entity\DpStudent | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\School | No errors. |
| App\Entity\Circle |
|
| App\Entity\State | No errors. |
| App\Entity\DpStudent | No errors. |
| App\Entity\DpStudentLot | No errors. |
| App\Entity\Ticket | No errors. |
| App\Entity\TicketTimeline | No errors. |
| App\Entity\CheckerSticker | No errors. |
| App\Entity\DpGroup | No errors. |
| App\Entity\DpSeason | No errors. |
| App\Entity\DpExam | No errors. |
| App\Entity\BackgroundProcess | No errors. |
| App\Entity\DpPaperIssue | No errors. |
| App\Entity\DpLanguages | No errors. |
| App\Entity\DpStudentRollNumber | No errors. |
| App\Entity\Admin | No errors. |
| App\Entity\Country | No errors. |
| App\Entity\Zone |
|
| App\Entity\Pincodes | No errors. |
| App\Entity\Member | No errors. |
| App\Entity\MagazineByHandMaster | No errors. |
| App\Entity\MembershipRequest | No errors. |
| App\Entity\WaQueue | No errors. |
| App\Entity\SmsQueue | No errors. |