Query Metrics

7 Database Queries
6 Different statements
3.94 ms Query time
2 Invalid entities
64 Managed entities

Queries

Group similar statements

# Time Info
1 1.02 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:
[
  8605
]
2 1.35 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.circle_id = ? AND t0.is_valid = ?
Parameters:
[
  555
  1
]
3 0.52 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:
[
  555
]
4 0.33 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:
[
  37
]
5 0.25 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:
[
  58
]
6 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
]
7 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.country_id AS country_id_5 FROM state t0 WHERE t0.id = ?
Parameters:
[
  19
]

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 57
App\Entity\State 2
App\Entity\Member 1
App\Entity\Circle 1
App\Entity\Country 1
App\Entity\Zone 1
App\Entity\RoadRoute 1

Entities Mapping

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