Query Metrics
2
Database Queries
2
Different statements
2.69 ms
Query time
0
Invalid entities
Grouped Statements
company_group connection
| Time▼ | Count | Info |
|---|---|---|
|
1.53 ms (57.00%) |
1 |
SELECT e0_.id AS id_0, e0_.ticket_id AS ticket_id_1, e0_.payload_json AS payload_json_2, e0_.reported_at AS reported_at_3, e0_.server_identifier AS server_identifier_4, e0_.message AS message_5, e0_.error_code AS error_code_6, e0_.created_at AS created_at_7 FROM entity_ticket_report e0_ WHERE e0_.ticket_id = ? ORDER BY e0_.reported_at DESC LIMIT 100
Parameters:
[
"375"
]
|
|
1.16 ms (43.00%) |
1 |
SELECT t0.id AS id_1, t0.reply_to AS reply_to_2, t0.ticket_marker_hash AS ticket_marker_hash_3, t0.title AS title_4, t0.email AS email_5, t0.attachments AS attachments_6, t0.phone AS phone_7, t0.name AS name_8, t0.ticket_body AS ticket_body_9, t0.preferred_contact_method AS preferred_contact_method_10, t0.ticket_reply_data AS ticket_reply_data_11, t0.ticket_assigned_date AS ticket_assigned_date_12, t0.ticket_expiry_date AS ticket_expiry_date_13, t0.assigned_to_user_id AS assigned_to_user_id_14, t0.assigned_by_user_id AS assigned_by_user_id_15, t0.assigned_by_client_id AS assigned_by_client_id_16, t0.assigned_by_supplier_id AS assigned_by_supplier_id_17, t0.user_id AS user_id_18, t0.tagged_user_ids AS tagged_user_ids_19, t0.app_id AS app_id_20, t0.company_id AS company_id_21, t0.entity AS entity_22, t0.entity_id AS entity_id_23, t0.meeting_id AS meeting_id_24, t0.applicant_id AS applicant_id_25, t0.type AS type_26, t0.flag AS flag_27, t0.status AS status_28, t0.expired AS expired_29, t0.urgency AS urgency_30, t0.document_hash AS document_hash_31, t0.note AS note_32, t0.deadline_date AS deadline_date_33, t0.expected_start_ts AS expected_start_ts_34, t0.expected_end_ts AS expected_end_ts_35, t0.expected_duration_min AS expected_duration_min_36, t0.actual_start_ts AS actual_start_ts_37, t0.actual_end_ts AS actual_end_ts_38, t0.location_type AS location_type_39, t0.lat AS lat_40, t0.lng AS lng_41, t0.branch_id AS branch_id_42, t0.working_status AS working_status_43, t0.approved AS approved_44, t0.expire_ts AS expire_ts_45, t0.reason_type AS reason_type_46, t0.feedback AS feedback_47, t0.is_recurring AS is_recurring_48, t0.is_recurring_parent AS is_recurring_parent_49, t0.recurring_parent_id AS recurring_parent_id_50, t0.is_recurring_perpetual AS is_recurring_perpetual_51, t0.recurring_type AS recurring_type_52, t0.recurring_values AS recurring_values_53, t0.recurring_ends_ts AS recurring_ends_ts_54, t0.recurring_condition AS recurring_condition_55, t0.achievable_target_value AS achievable_target_value_56, t0.achievable_target_type AS achievable_target_type_57, t0.target_increase_value AS target_increase_value_58, t0.target_increase_type AS target_increase_type_59, t0.created_at AS created_at_60, t0.updated_at AS updated_at_61, t0.doc_booked_flag AS doc_booked_flag_62, t0.time_stamp_of_form AS time_stamp_of_form_63, t0.ticket_number AS ticket_number_64, t0.source AS source_65, t0.system_created AS system_created_66, t0.problem_hash AS problem_hash_67, t0.report_count AS report_count_68, t0.first_reported_at AS first_reported_at_69, t0.last_reported_at AS last_reported_at_70, t0.last_payload_json AS last_payload_json_71, t0.server_identifier AS server_identifier_72, t0.resolved_at AS resolved_at_73, t0.closed_at AS closed_at_74 FROM entity_ticket t0 WHERE t0.id = ?
Parameters:
[
"375"
]
|
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. |
| CompanyGroupBundle\Entity\EntityTicketReport | No errors. |