Query Metrics

24 Database Queries
9 Different statements
365.83 ms Query time
2 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 0.80 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.deleted AS deleted_6, t0.deleted_on AS deleted_on_7 FROM admin t0 WHERE t0.id = ?
Parameters:
[
  8
]
2 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM cclanguages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "PB"
]
3 204.53 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.father_name AS father_name_2, c0_.address AS address_3, c0_.city AS city_4, c0_.pin AS pin_5, c0_.qualification AS qualification_6, c0_.occupation AS occupation_7, c0_.is_amritdhari AS is_amritdhari_8, c0_.phone AS phone_9, c0_.roll_number AS roll_number_10, c0_.date_of_birth AS date_of_birth_11, c0_.mother_name AS mother_name_12, c0_.is_paid AS is_paid_13, c0_.mobile AS mobile_14, c0_.certificate_number AS certificate_number_15, c0_.certificate_date AS certificate_date_16, c0_.reciept AS reciept_17, c0_.created_by AS created_by_18, c0_.gender AS gender_19, c0_.relation AS relation_20, c0_.created_on AS created_on_21, c0_.name_punjabi AS name_punjabi_22, c0_.father_name_punjabi AS father_name_punjabi_23, c0_.address_punjabi AS address_punjabi_24, c0_.darja_punjabi AS darja_punjabi_25, c0_.payment_mode AS payment_mode_26, c0_.amount AS amount_27, c0_.email AS email_28, c0_.prospectus AS prospectus_29, c0_.circle_id AS circle_id_30, c0_.correspondence_course_id AS correspondence_course_id_31, c0_.language_id AS language_id_32, c0_.user_id AS user_id_33, c0_.country_id AS country_id_34, c0_.member_id AS member_id_35 FROM ccstudent c0_ WHERE (c0_.id LIKE ? OR c0_.name LIKE ? OR c0_.roll_number LIKE ?) AND c0_.language_id = ? AND c0_.correspondence_course_id = ? AND c0_.roll_number IS NOT NULL ORDER BY c0_.id DESC LIMIT 10 OFFSET 20
Parameters:
[
  "%5447%"
  "%5447%"
  "%5447%"
  1
  "1"
]
4 154.11 ms
SELECT count(c0_.id) AS sclr_0 FROM ccstudent c0_ WHERE (c0_.id LIKE ? OR c0_.name LIKE ? OR c0_.roll_number LIKE ?) AND c0_.language_id = ? AND c0_.correspondence_course_id = ? AND c0_.roll_number IS NOT NULL
Parameters:
[
  "%5447%"
  "%5447%"
  "%5447%"
  1
  "1"
]
5 0.68 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  113
]
6 0.53 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  69
]
7 0.36 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:
[
  82
]
8 0.23 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.calling_code AS calling_code_5 FROM country t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.admission_fee AS admission_fee_3, t0.online AS online_4 FROM correspondence_course t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.37 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.26 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  1
]
12 0.21 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:
[
  28
]
13 0.33 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  46
]
14 0.24 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  34
]
15 0.21 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:
[
  56
]
16 0.30 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  94
]
17 0.25 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  24
]
18 0.19 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:
[
  49
]
19 0.32 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  810
]
20 0.24 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  125
]
21 0.20 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
]
22 0.29 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.star AS star_3, t0.wz_code AS wz_code_4, t0.circle_code AS circle_code_5, t0.circle_name AS circle_name_6, t0.circle_name1 AS circle_name1_7, t0.circle_add1 AS circle_add1_8, t0.circle_add2 AS circle_add2_9, t0.circle_add3 AS circle_add3_10, t0.circle_city AS circle_city_11, t0.circle_state AS circle_state_12, t0.pincode AS pincode_13, t0.phone AS phone_14, t0.punjabi_magzine AS punjabi_magzine_15, t0.hindi_magzine AS hindi_magzine_16, t0.free_lit_p AS free_lit_p_17, t0.free_lit_h AS free_lit_h_18, t0.bp_mag AS bp_mag_19, t0.category AS category_20, t0.head_circle AS head_circle_21, t0.flag AS flag_22, t0.suspend AS suspend_23, t0.lbls AS lbls_24, t0.lbl_s1 AS lbl_s1_25, t0.bilty AS bilty_26, t0.line1 AS line1_27, t0.line2 AS line2_28, t0.line3 AS line3_29, t0.line4 AS line4_30, t0.line5 AS line5_31, t0.total AS total_32, t0.bh_mag AS bh_mag_33, t0.status AS status_34, t0.email AS email_35, t0.zoho_customer_id AS zoho_customer_id_36, t0.district_id AS district_id_37, t0.zone_id AS zone_id_38, t0.zone_fixer_id AS zone_fixer_id_39, t0.road_route_id AS road_route_id_40 FROM circle t0 WHERE t0.id = ?
Parameters:
[
  12
]
23 0.28 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.code AS code_6, t0.phone AS phone_7, t0.dollar AS dollar_8, t0.is_foreign AS is_foreign_9, t0.star AS star_10, t0.category AS category_11, t0.total AS total_12, t0.last_update_on AS last_update_on_13, t0.email AS email_14, t0.state_id AS state_id_15 FROM zone t0 WHERE t0.id = ?
Parameters:
[
  25
]
24 0.20 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:
[
  50
]

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\CCStudent 10
App\Entity\Zone 8
App\Entity\Circle 6
App\Entity\State 6
App\Entity\RoadRoute 4
App\Entity\Admin 1
App\Entity\CCLanguages 1
App\Entity\CorrespondenceCourse 1
App\Entity\Country 1

Entities Mapping

Class Mapping errors
App\Entity\Admin No errors.
App\Entity\MagazineSubscription No errors.
App\Entity\MagazineByHandMaster No errors.
App\Entity\Ticket No errors.
App\Entity\TicketTimeline No errors.
App\Entity\DpStudentLot No errors.
App\Entity\DpStudent No errors.
App\Entity\CCStudentTimeline No errors.
App\Entity\History No errors.
App\Entity\RecieptBook No errors.
App\Entity\RecieptBookIssue No errors.
App\Entity\MembershipRenewHistory No errors.
App\Entity\CCLanguages No errors.
App\Entity\CCLanguagesAvailable No errors.
App\Entity\CorrespondenceCourseCheckers No errors.
App\Entity\CCStudent No errors.
App\Entity\Circle
  • The mappings App\Entity\Circle#district and App\Entity\Zone#circles are inconsistent with each other.
App\Entity\CorrespondenceCourse No errors.
App\Entity\User No errors.
App\Entity\Country No errors.
App\Entity\Member No errors.
App\Entity\CCStudentProgress No errors.
App\Entity\CheckoutItem No errors.
App\Entity\Payment No errors.
App\Entity\PaypalOrder 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\RoadRoute No errors.
App\Entity\ProjectMembers No errors.
App\Entity\MagazinePrintJobCircle No errors.
App\Entity\ReportCircleWiseMagazine No errors.
App\Entity\School No errors.
App\Entity\Events No errors.
App\Entity\EventVisitor No errors.
App\Entity\EMagazineSubscription No errors.
App\Entity\Cart No errors.
App\Entity\MemberCircleOrder No errors.
App\Entity\MemberCircleOrderItem No errors.
App\Entity\OrgStructure No errors.
App\Entity\OnlineDonation No errors.
App\Entity\ElibrarySubscription No errors.
App\Entity\CirclePerforma No errors.
App\Entity\CirclePerformaMaster No errors.
App\Entity\MMP No errors.
App\Entity\DpPaperIssueItems No errors.
App\Entity\State No errors.
App\Entity\ZoneContacts No errors.
App\Entity\MagazinePrintJobZone No errors.
App\Entity\Pincodes No errors.
App\Entity\MembershipRequest No errors.
App\Entity\Checkout No errors.
App\Entity\BulkMagazine No errors.
App\Entity\RegularAdmission No errors.
App\Entity\CorrespondenceCoursePlan No errors.