Query Metrics
4
Database Queries
4
Different statements
9.76 ms
Query time
0
Invalid entities
76
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.69 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:
[
17
]
|
| 2 | 0.71 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:
[
"41"
]
|
| 3 | 7.00 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:
[
41
]
|
| 4 | 1.36 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 | 35 |
| App\Entity\PalletRealMovement | 35 |
| App\Entity\User | 3 |
| App\Entity\PalletRequest | 1 |
| App\Entity\Company | 1 |
| App\Entity\ScheduleSlot | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Company | No errors. |
| App\Entity\PalletRequest | No errors. |
| App\Entity\ScheduleSlot | No errors. |
| App\Entity\PalletRequestDetail | No errors. |
| App\Entity\PalletRequestQualityFile | No errors. |
| App\Entity\OperationIncident | No errors. |
| App\Entity\PalletRealMovement | No errors. |
| App\Entity\Inventory | No errors. |
| App\Entity\Transaction | No errors. |