Query Metrics
2
Database Queries
2
Different statements
2.07 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.10 ms (53.19%) |
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.97 ms (46.81%) |
1 |
SELECT w0_.id AS id_0, w0_.menu AS menu_1, w0_.type AS type_2, w0_.title AS title_3, w0_.sub_title AS sub_title_4, w0_.short_description AS short_description_5, w0_.description AS description_6, w0_.footer_note AS footer_note_7, w0_.image AS image_8, w0_.status AS status_9, w0_.created_by AS created_by_10, w0_.created_time AS created_time_11, w0_.updated_by AS updated_by_12, w0_.updated_time AS updated_time_13, w0_.company_id AS company_id_14 FROM website_posts w0_ WHERE w0_.company_id = ? AND w0_.status = ? AND w0_.type = ? ORDER BY w0_.id DESC LIMIT 48
Parameters:
[ 1 1 12 ]
|
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\Companies | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Companies | No errors. |
| App\Entity\Website\WebsitePost | No errors. |