POST https://cp.sikhmissionarycollege.org/school/dp/lot/student/createv2

Query Metrics

12 Database Queries
12 Different statements
122.29 ms Query time
2 Invalid entities
10 Managed entities

Queries

Group similar statements

# 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
  • The mappings App\Entity\Circle#district and App\Entity\Zone#circles are inconsistent with each other.
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
  • The mappings App\Entity\Zone#districtCircles and App\Entity\Circle#district are inconsistent with each other.
  • The association App\Entity\Zone#correspondenceCourseCheckers refers to the owning side field App\Entity\CorrespondenceCourseCheckers#zone which does not exist.
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.