GET https://logistics.trendy.cl/admin/incidents/request/43/new

Query Metrics

4 Database Queries
4 Different statements
6.22 ms Query time
0 Invalid entities
58 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.58 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.last_login AS last_login_7, t0.is_new AS is_new_8, t0.position AS position_9, t0.is_company_admin AS is_company_admin_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.62 ms
SELECT t0.id AS id_1, t0.folio AS folio_2, t0.type AS type_3, t0.quantity AS quantity_4, t0.status AS status_5, t0.notes AS notes_6, t0.created_at AS created_at_7, t0.requested_date AS requested_date_8, t0.approved_at AS approved_at_9, t0.closed_at AS closed_at_10, t0.rejection_reason AS rejection_reason_11, t0.scheduled_date AS scheduled_date_12, t0.transport_company AS transport_company_13, t0.transport_company_rut AS transport_company_rut_14, t0.camion_plate AS camion_plate_15, t0.truck_plate AS truck_plate_16, t0.driver_rut AS driver_rut_17, t0.driver_name AS driver_name_18, t0.driver_phone AS driver_phone_19, t0.quality_temperature_transport AS quality_temperature_transport_20, t0.quality_temperature_start AS quality_temperature_start_21, t0.quality_temperature_middle AS quality_temperature_middle_22, t0.quality_temperature_end AS quality_temperature_end_23, t0.company_id AS company_id_24, t0.requested_by_id AS requested_by_id_25, t0.approved_by_id AS approved_by_id_26, t0.schedule_slot_id AS schedule_slot_id_27 FROM pallet_request t0 WHERE t0.id = ?
Parameters:
[
  "43"
]
3 4.29 ms
SELECT p0_.id AS id_0, p0_.product_description AS product_description_1, p0_.sku AS sku_2, p0_.quantity AS quantity_3, p0_.weight AS weight_4, p0_.observations AS observations_5, p0_.product_code AS product_code_6, p0_.box_quantity AS box_quantity_7, p0_.reference AS reference_8, p0_.lot AS lot_9, p0_.pallet_number AS pallet_number_10, p0_.detail_line AS detail_line_11, p0_.expiration_date AS expiration_date_12, p0_.unit_of_measure AS unit_of_measure_13, p1_.id AS id_14, p1_.folio AS folio_15, p1_.type AS type_16, p1_.quantity AS quantity_17, p1_.status AS status_18, p1_.notes AS notes_19, p1_.created_at AS created_at_20, p1_.requested_date AS requested_date_21, p1_.approved_at AS approved_at_22, p1_.closed_at AS closed_at_23, p1_.rejection_reason AS rejection_reason_24, p1_.scheduled_date AS scheduled_date_25, p1_.transport_company AS transport_company_26, p1_.transport_company_rut AS transport_company_rut_27, p1_.camion_plate AS camion_plate_28, p1_.truck_plate AS truck_plate_29, p1_.driver_rut AS driver_rut_30, p1_.driver_name AS driver_name_31, p1_.driver_phone AS driver_phone_32, p1_.quality_temperature_transport AS quality_temperature_transport_33, p1_.quality_temperature_start AS quality_temperature_start_34, p1_.quality_temperature_middle AS quality_temperature_middle_35, p1_.quality_temperature_end AS quality_temperature_end_36, p2_.id AS id_37, p2_.qad_event_id AS qad_event_id_38, p2_.qad_event_name AS qad_event_name_39, p2_.movement_type AS movement_type_40, p2_.real_pallet AS real_pallet_41, p2_.real_product_code AS real_product_code_42, p2_.real_customer_ref AS real_customer_ref_43, p2_.real_lot AS real_lot_44, p2_.real_quantity AS real_quantity_45, p2_.real_site AS real_site_46, p2_.real_location AS real_location_47, p2_.real_expiration_date AS real_expiration_date_48, p2_.qad_event_date AS qad_event_date_49, p2_.qad_event_time AS qad_event_time_50, p2_.qad_user AS qad_user_51, p2_.created_at AS created_at_52, p2_.updated_at AS updated_at_53, p0_.pallet_request_id AS pallet_request_id_54, p1_.company_id AS company_id_55, p1_.requested_by_id AS requested_by_id_56, p1_.approved_by_id AS approved_by_id_57, p1_.schedule_slot_id AS schedule_slot_id_58, p2_.pallet_request_id AS pallet_request_id_59, p2_.pallet_request_detail_id AS pallet_request_detail_id_60 FROM pallet_request_detail p0_ LEFT JOIN pallet_request p1_ ON p0_.pallet_request_id = p1_.id LEFT JOIN pallet_real_movement p2_ ON p1_.id = p2_.pallet_request_id WHERE p0_.pallet_request_id = ? ORDER BY p0_.pallet_number ASC, p0_.detail_line ASC
Parameters:
[
  43
]
4 0.73 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.contact_person AS contact_person_7, t0.status AS status_8, t0.max_daily_requests AS max_daily_requests_9, t0.created_at AS created_at_10 FROM company t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\PalletRequestDetail 26
App\Entity\PalletRealMovement 26
App\Entity\User 3
App\Entity\PalletRequest 1
App\Entity\Company 1
App\Entity\ScheduleSlot 1