Query Metrics
3
Database Queries
3
Different statements
2.44 ms
Query time
0
Invalid entities
Grouped Statements
company_group connection
| Time▼ | Count | Info |
|---|---|---|
|
1.49 ms (60.95%) |
1 |
SELECT e0_.id AS id_0, e0_.reply_to AS reply_to_1, e0_.ticket_marker_hash AS ticket_marker_hash_2, e0_.title AS title_3, e0_.email AS email_4, e0_.attachments AS attachments_5, e0_.phone AS phone_6, e0_.name AS name_7, e0_.ticket_body AS ticket_body_8, e0_.preferred_contact_method AS preferred_contact_method_9, e0_.ticket_reply_data AS ticket_reply_data_10, e0_.ticket_assigned_date AS ticket_assigned_date_11, e0_.ticket_expiry_date AS ticket_expiry_date_12, e0_.assigned_to_user_id AS assigned_to_user_id_13, e0_.assigned_by_user_id AS assigned_by_user_id_14, e0_.assigned_by_client_id AS assigned_by_client_id_15, e0_.assigned_by_supplier_id AS assigned_by_supplier_id_16, e0_.user_id AS user_id_17, e0_.tagged_user_ids AS tagged_user_ids_18, e0_.app_id AS app_id_19, e0_.company_id AS company_id_20, e0_.entity AS entity_21, e0_.entity_id AS entity_id_22, e0_.meeting_id AS meeting_id_23, e0_.applicant_id AS applicant_id_24, e0_.type AS type_25, e0_.flag AS flag_26, e0_.status AS status_27, e0_.expired AS expired_28, e0_.urgency AS urgency_29, e0_.document_hash AS document_hash_30, e0_.note AS note_31, e0_.deadline_date AS deadline_date_32, e0_.expected_start_ts AS expected_start_ts_33, e0_.expected_end_ts AS expected_end_ts_34, e0_.expected_duration_min AS expected_duration_min_35, e0_.actual_start_ts AS actual_start_ts_36, e0_.actual_end_ts AS actual_end_ts_37, e0_.location_type AS location_type_38, e0_.lat AS lat_39, e0_.lng AS lng_40, e0_.branch_id AS branch_id_41, e0_.working_status AS working_status_42, e0_.approved AS approved_43, e0_.expire_ts AS expire_ts_44, e0_.reason_type AS reason_type_45, e0_.feedback AS feedback_46, e0_.is_recurring AS is_recurring_47, e0_.is_recurring_parent AS is_recurring_parent_48, e0_.recurring_parent_id AS recurring_parent_id_49, e0_.is_recurring_perpetual AS is_recurring_perpetual_50, e0_.recurring_type AS recurring_type_51, e0_.recurring_values AS recurring_values_52, e0_.recurring_ends_ts AS recurring_ends_ts_53, e0_.recurring_condition AS recurring_condition_54, e0_.achievable_target_value AS achievable_target_value_55, e0_.achievable_target_type AS achievable_target_type_56, e0_.target_increase_value AS target_increase_value_57, e0_.target_increase_type AS target_increase_type_58, e0_.created_at AS created_at_59, e0_.updated_at AS updated_at_60, e0_.doc_booked_flag AS doc_booked_flag_61, e0_.time_stamp_of_form AS time_stamp_of_form_62, e0_.ticket_number AS ticket_number_63, e0_.source AS source_64, e0_.system_created AS system_created_65, e0_.problem_hash AS problem_hash_66, e0_.report_count AS report_count_67, e0_.first_reported_at AS first_reported_at_68, e0_.last_reported_at AS last_reported_at_69, e0_.last_payload_json AS last_payload_json_70, e0_.server_identifier AS server_identifier_71, e0_.resolved_at AS resolved_at_72, e0_.closed_at AS closed_at_73 FROM entity_ticket e0_ ORDER BY e0_.created_at DESC LIMIT 20 OFFSET 500
Parameters:
[] |
|
0.48 ms (19.54%) |
1 |
SELECT e0_.status AS status_0, COUNT(e0_.id) AS sclr_1 FROM entity_ticket e0_ GROUP BY e0_.status
Parameters:
[] |
|
0.48 ms (19.50%) |
1 |
SELECT COUNT(e0_.id) AS sclr_0 FROM entity_ticket e0_ ORDER BY e0_.created_at DESC
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| company_group | doctrine.dbal.company_group_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| company_group | doctrine.orm.company_group_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
No loaded entities.
company_group entity manager
| Class | Mapping errors |
|---|---|
| CompanyGroupBundle\Entity\EntityTicket | No errors. |