Query Metrics
24
Database Queries
9
Different statements
365.83 ms
Query time
2
Invalid entities
38
Managed entities
Queries
| #▲ | 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 |