Symfony Profiler

[
  "route" => "app_admin_request_show"
  "route_parameters" => [
    "_route" => "app_admin_request_show"
    "_controller" => "App\Controller\Admin\RequestController::show"
    "id" => "43"
  ]
  "request_uri" => "https://logistics.trendy.cl/admin/request/43"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "10.0.1.64"
    "port" => 3306
    "user" => "logistics"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "logistics"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "emunoz@trendy.cl"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\UX\Turbo\Request\RequestListener::__invoke"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "43"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\IsSignatureValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Container9wvxTRS\RequestPayloadValueResolverGhost5776a3c::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "sql" => "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"
  "params" => [
    1 => 43
    2 => "PALLET_IN"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1520
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "PALLET_REQUEST_ANNEX_TYPE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1520
      +name: "STRING"
    }
  ]
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 327
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 43
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#790
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]