Query Metrics
2
Database Queries
2
Different statements
2.07 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.19 ms (57.35%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.logo AS logo_3, c0_.expiry_date AS expiry_date_4, c0_.status AS status_5, c0_.subdomain AS subdomain_6, c0_.name_bn AS name_bn_7, c0_.contact_mobile AS contact_mobile_8, c0_.contact_phone AS contact_phone_9, c0_.contact_email AS contact_email_10, c0_.module AS module_11, c0_.go_code AS go_code_12, c0_.sms_end_point AS sms_end_point_13, c0_.sms_api_key AS sms_api_key_14, c0_.sms_sender_id AS sms_sender_id_15, c0_.api_vendor AS api_vendor_16 FROM companies c0_ WHERE c0_.status = 1 AND c0_.module IN (?, ?) ORDER BY c0_.id ASC LIMIT 1
Parameters:
[ "education" "school" ]
|
||||||||||||||||||||||||||||||||
|
0.88 ms (42.65%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.code AS code_3, c0_.alias AS alias_4, c0_.status AS status_5, c0_.created_by AS created_by_6, c0_.created_time AS created_time_7, c0_.updated_by AS updated_by_8, c0_.updated_time AS updated_time_9, c0_.company_id AS company_id_10 FROM campus c0_ WHERE c0_.status <> ? AND c0_.company_id = ? ORDER BY c0_.name ASC
Parameters:
[ 99 1 ]
|
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\Education\InstituteSetup\Campus | 3 |
| App\Entity\Companies | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Companies | No errors. |
| App\Entity\Education\InstituteSetup\Campus | No errors. |
| App\Entity\User | No errors. |