GET https://cp.sikhmissionarycollege.org/state.json?isSelect=true

Query Metrics

110 Database Queries
2 Different statements
20.46 ms Query time
1 Invalid entities
325 Managed entities

Grouped Statements

Show all queries

Time Count Info
19.36 ms
(94.63%)
109
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
]
1.10 ms
(5.37%)
1
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
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\State 216
App\Entity\Country 109

Entities Mapping

Class Mapping errors
App\Entity\State 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\School No errors.
App\Entity\MembershipRequest No errors.
App\Entity\MagazineSubscription No errors.
App\Entity\CCStudent No errors.
App\Entity\User No errors.
App\Entity\Checkout No errors.
App\Entity\EventVisitor No errors.
App\Entity\EMagazineSubscription No errors.
App\Entity\BulkMagazine No errors.
App\Entity\RegularAdmission No errors.