Symfony Profiler

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 = ?

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 = 4;

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 = ?

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 = '43';

SELECT
  p0_.id AS id_0,
  p0_.qad_event_id AS qad_event_id_1,
  p0_.qad_event_name AS qad_event_name_2,
  p0_.movement_type AS movement_type_3,
  p0_.real_pallet AS real_pallet_4,
  p0_.real_product_code AS real_product_code_5,
  p0_.real_customer_ref AS real_customer_ref_6,
  p0_.real_lot AS real_lot_7,
  p0_.real_quantity AS real_quantity_8,
  p0_.real_site AS real_site_9,
  p0_.real_location AS real_location_10,
  p0_.real_expiration_date AS real_expiration_date_11,
  p0_.qad_event_date AS qad_event_date_12,
  p0_.qad_event_time AS qad_event_time_13,
  p0_.qad_user AS qad_user_14,
  p0_.created_at AS created_at_15,
  p0_.updated_at AS updated_at_16,
  p1_.id AS id_17,
  p1_.product_description AS product_description_18,
  p1_.sku AS sku_19,
  p1_.quantity AS quantity_20,
  p1_.weight AS weight_21,
  p1_.observations AS observations_22,
  p1_.product_code AS product_code_23,
  p1_.box_quantity AS box_quantity_24,
  p1_.reference AS reference_25,
  p1_.lot AS lot_26,
  p1_.pallet_number AS pallet_number_27,
  p1_.detail_line AS detail_line_28,
  p1_.expiration_date AS expiration_date_29,
  p1_.unit_of_measure AS unit_of_measure_30,
  p0_.pallet_request_id AS pallet_request_id_31,
  p0_.pallet_request_detail_id AS pallet_request_detail_id_32,
  p1_.pallet_request_id AS pallet_request_id_33
FROM
  pallet_real_movement p0_
  LEFT JOIN pallet_request_detail p1_ ON p0_.pallet_request_detail_id = p1_.id
WHERE
  p0_.pallet_request_id = ?
  AND p0_.qad_event_name = ?
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.qad_event_id AS qad_event_id_1, p0_.qad_event_name AS qad_event_name_2, p0_.movement_type AS movement_type_3, p0_.real_pallet AS real_pallet_4, p0_.real_product_code AS real_product_code_5, p0_.real_customer_ref AS real_customer_ref_6, p0_.real_lot AS real_lot_7, p0_.real_quantity AS real_quantity_8, p0_.real_site AS real_site_9, p0_.real_location AS real_location_10, p0_.real_expiration_date AS real_expiration_date_11, p0_.qad_event_date AS qad_event_date_12, p0_.qad_event_time AS qad_event_time_13, p0_.qad_user AS qad_user_14, p0_.created_at AS created_at_15, p0_.updated_at AS updated_at_16, p1_.id AS id_17, p1_.product_description AS product_description_18, p1_.sku AS sku_19, p1_.quantity AS quantity_20, p1_.weight AS weight_21, p1_.observations AS observations_22, p1_.product_code AS product_code_23, p1_.box_quantity AS box_quantity_24, p1_.reference AS reference_25, p1_.lot AS lot_26, p1_.pallet_number AS pallet_number_27, p1_.detail_line AS detail_line_28, p1_.expiration_date AS expiration_date_29, p1_.unit_of_measure AS unit_of_measure_30, p0_.pallet_request_id AS pallet_request_id_31, p0_.pallet_request_detail_id AS pallet_request_detail_id_32, p1_.pallet_request_id AS pallet_request_id_33 FROM pallet_real_movement p0_ LEFT JOIN pallet_request_detail p1_ ON p0_.pallet_request_detail_id = p1_.id WHERE p0_.pallet_request_id = 43 AND p0_.qad_event_name = 'PALLET_IN' ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.document_folio AS document_folio_2,
  t0.caption AS caption_3,
  t0.original_filename AS original_filename_4,
  t0.s3_key AS s3_key_5,
  t0.mime_type AS mime_type_6,
  t0.file_size AS file_size_7,
  t0.created_at AS created_at_8,
  t0.pallet_request_id AS pallet_request_id_9,
  t0.document_type_id AS document_type_id_10,
  t0.uploaded_by_id AS uploaded_by_id_11
FROM
  pallet_request_quality_file t0
WHERE
  t0.pallet_request_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.document_folio AS document_folio_2, t0.caption AS caption_3, t0.original_filename AS original_filename_4, t0.s3_key AS s3_key_5, t0.mime_type AS mime_type_6, t0.file_size AS file_size_7, t0.created_at AS created_at_8, t0.pallet_request_id AS pallet_request_id_9, t0.document_type_id AS document_type_id_10, t0.uploaded_by_id AS uploaded_by_id_11 FROM pallet_request_quality_file t0 WHERE t0.pallet_request_id = 43 ORDER BY t0.created_at DESC;

SELECT
  g0_.id AS id_0,
  g0_.code AS code_1,
  g0_.value AS value_2,
  g0_.description AS description_3
FROM
  generalized_codes g0_
WHERE
  g0_.code = ?
ORDER BY
  g0_.description ASC

SELECT g0_.id AS id_0, g0_.code AS code_1, g0_.value AS value_2, g0_.description AS description_3 FROM generalized_codes g0_ WHERE g0_.code = 'PALLET_REQUEST_ANNEX_TYPE' ORDER BY g0_.description ASC;

SELECT
  t0.id AS id_1,
  t0.product_description AS product_description_2,
  t0.sku AS sku_3,
  t0.quantity AS quantity_4,
  t0.weight AS weight_5,
  t0.observations AS observations_6,
  t0.product_code AS product_code_7,
  t0.box_quantity AS box_quantity_8,
  t0.reference AS reference_9,
  t0.lot AS lot_10,
  t0.pallet_number AS pallet_number_11,
  t0.detail_line AS detail_line_12,
  t0.expiration_date AS expiration_date_13,
  t0.unit_of_measure AS unit_of_measure_14,
  t0.pallet_request_id AS pallet_request_id_15
FROM
  pallet_request_detail t0
WHERE
  t0.pallet_request_id = ?
ORDER BY
  t0.detail_line ASC,
  t0.pallet_number ASC

SELECT t0.id AS id_1, t0.product_description AS product_description_2, t0.sku AS sku_3, t0.quantity AS quantity_4, t0.weight AS weight_5, t0.observations AS observations_6, t0.product_code AS product_code_7, t0.box_quantity AS box_quantity_8, t0.reference AS reference_9, t0.lot AS lot_10, t0.pallet_number AS pallet_number_11, t0.detail_line AS detail_line_12, t0.expiration_date AS expiration_date_13, t0.unit_of_measure AS unit_of_measure_14, t0.pallet_request_id AS pallet_request_id_15 FROM pallet_request_detail t0 WHERE t0.pallet_request_id = 43 ORDER BY t0.detail_line ASC, t0.pallet_number ASC;

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 = ?

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 = 12;

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 = ?

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 = 5;

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 = ?

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 = 11;

SELECT
  t0.id AS id_1,
  t0.start_time AS start_time_2,
  t0.end_time AS end_time_3,
  t0.max_appointments AS max_appointments_4,
  t0.is_active AS is_active_5,
  t0.schedule_id AS schedule_id_6
FROM
  schedule_slot t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.max_appointments AS max_appointments_4, t0.is_active AS is_active_5, t0.schedule_id AS schedule_id_6 FROM schedule_slot t0 WHERE t0.id = 327;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.status AS status_3,
  t0.origin AS origin_4,
  t0.description AS description_5,
  t0.resolution AS resolution_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.resolved_at AS resolved_at_9,
  t0.closed_at AS closed_at_10,
  t0.company_id AS company_id_11,
  t0.pallet_request_id AS pallet_request_id_12,
  t0.reported_by_id AS reported_by_id_13,
  t0.resolved_by_id AS resolved_by_id_14
FROM
  operation_incident t0
WHERE
  t0.pallet_request_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.status AS status_3, t0.origin AS origin_4, t0.description AS description_5, t0.resolution AS resolution_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.resolved_at AS resolved_at_9, t0.closed_at AS closed_at_10, t0.company_id AS company_id_11, t0.pallet_request_id AS pallet_request_id_12, t0.reported_by_id AS reported_by_id_13, t0.resolved_by_id AS resolved_by_id_14 FROM operation_incident t0 WHERE t0.pallet_request_id = 43 ORDER BY t0.created_at DESC;