Query Metrics
3
Database Queries
3
Different statements
29.46 ms
Query time
1
Invalid entities
4
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.91 ms |
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:
[
3818
]
|
| 2 | 26.84 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_.circle_id = ? AND c0_.is_paid = ? ORDER BY c0_.id DESC LIMIT 10
Parameters:
[ 357 0 ] |
| 3 | 0.71 ms |
SELECT count(c0_.id) AS sclr_0 FROM ccstudent c0_ WHERE c0_.circle_id = ? AND c0_.is_paid = ?
Parameters:
[ 357 0 ] |
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\Member | 1 |
| App\Entity\Circle | 1 |
| App\Entity\Country | 1 |
| App\Entity\State | 1 |