Symfony Profiler

[
  "route" => "api_contrato"
  "route_parameters" => [
    "_route" => "api_contrato"
    "_controller" => "App\Controller\ApiController::contrato"
  ]
  "request_uri" => "https://wattson.es/api/contrato"
  "method" => "POST"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "localhost"
    "port" => 3306
    "user" => "energaze"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "energaze"
    "serverVersion" => "5.7"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t6.id AS id_7, t6.nombre AS nombre_8, t6.apellido AS apellido_9, t6.apellido2 AS apellido2_10, t6.nif AS nif_11, t6.representante AS representante_12, t6.nombre_representante AS nombre_representante_13, t6.dni_representante AS dni_representante_14, t6.telefono AS telefono_15, t6.telefono2 AS telefono2_16, t6.email AS email_17, t6.nombre_via AS nombre_via_18, t6.numero_direccion AS numero_direccion_19, t6.escalera AS escalera_20, t6.piso AS piso_21, t6.puerta AS puerta_22, t6.cp AS cp_23, t6.poblacion AS poblacion_24, t6.provincia AS provincia_25, t6.notificaciones AS notificaciones_26, t6.nombre_notificaciones AS nombre_notificaciones_27, t6.direccion_notificaciones AS direccion_notificaciones_28, t6.poblacion_notificaciones AS poblacion_notificaciones_29, t6.cp_notificaciones AS cp_notificaciones_30, t6.provincia_notificaciones AS provincia_notificaciones_31, t6.observaciones AS observaciones_32, t6.codigo_contable AS codigo_contable_33, t6.informacion_factura_e AS informacion_factura_e_34, t6.codigo_receptor AS codigo_receptor_35, t6.codigo_pagador AS codigo_pagador_36, t6.codigo_fiscal AS codigo_fiscal_37, t6.tipo_documento_id AS tipo_documento_id_38, t6.tipo_via_id AS tipo_via_id_39, t6.user_id AS user_id_40, t41.id AS id_42, t41.nif AS nif_43, t41.nombre AS nombre_44, t41.apellido1 AS apellido1_45, t41.apellido2 AS apellido2_46, t41.telefono AS telefono_47, t41.email AS email_48, t41.codigo_vendedor AS codigo_vendedor_49, t41.total_puntos AS total_puntos_50, t41.user_id AS user_id_51 FROM `user` t0 LEFT JOIN cliente t6 ON t6.user_id = t0.id LEFT JOIN comercial t41 ON t41.user_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 2144
  ]
  "types" => [
    1 => 1
  ]
]

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

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "yas"
]

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

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

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

[
  "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\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

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

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

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

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

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

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

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

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

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelControllerArguments"
]

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

[
  "event" => "kernel.controller_arguments"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\IsGrantedListener::onKernelControllerArguments"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.referencia_contrato AS referencia_contrato_2, t0.fecha AS fecha_3, t0.consumo_grabado AS consumo_grabado_4, t0.consumo_firmado AS consumo_firmado_5, t0.visita AS visita_6, t0.referido AS referido_7, t0.forma_pago AS forma_pago_8, t0.iban AS iban_9, t0.ccc AS ccc_10, t0.lectura_inicial_p1 AS lectura_inicial_p1_11, t0.lectura_inicial_p2 AS lectura_inicial_p2_12, t0.lectura_inicial_p3 AS lectura_inicial_p3_13, t0.lectura_inicial_p4 AS lectura_inicial_p4_14, t0.lectura_inicial_p5 AS lectura_inicial_p5_15, t0.lectura_inicial_p6 AS lectura_inicial_p6_16, t0.lectura_reactiva_p1 AS lectura_reactiva_p1_17, t0.lectura_reactiva_p2 AS lectura_reactiva_p2_18, t0.lectura_reactiva_p3 AS lectura_reactiva_p3_19, t0.lectura_reactiva_p4 AS lectura_reactiva_p4_20, t0.lectura_reactiva_p5 AS lectura_reactiva_p5_21, t0.lectura_reactiva_p6 AS lectura_reactiva_p6_22, t0.fecha_lectura AS fecha_lectura_23, t0.fecha_cobro AS fecha_cobro_24, t0.fecha_fin AS fecha_fin_25, t0.observaciones AS observaciones_26, t0.comercial AS comercial_27, t0.oculto AS oculto_28, t0.cambio_tarifa AS cambio_tarifa_29, t0.factor_conversion AS factor_conversion_30, t0.ultima_lectura AS ultima_lectura_31, t0.ahorro_anual AS ahorro_anual_32, t0.fecha_caducidad AS fecha_caducidad_33, t0.comision1 AS comision1_34, t0.comision2 AS comision2_35, t0.otros_gastos AS otros_gastos_36, t0.optimizacion AS optimizacion_37, t0.comision_comercial AS comision_comercial_38, t0.factura_devuelta AS factura_devuelta_39, t0.cambios AS cambios_40, t0.consumo_real_p1 AS consumo_real_p1_41, t0.consumo_real_p2 AS consumo_real_p2_42, t0.consumo_real_p3 AS consumo_real_p3_43, t0.consumo_real_p4 AS consumo_real_p4_44, t0.consumo_real_p5 AS consumo_real_p5_45, t0.consumo_real_p6 AS consumo_real_p6_46, t0.comision_cobrada_valor AS comision_cobrada_valor_47, t0.comision_pagada_valor AS comision_pagada_valor_48, t0.comision_cobrada_fecha AS comision_cobrada_fecha_49, t0.comision_pagada_fecha AS comision_pagada_fecha_50, t0.fecha_rentabilidad AS fecha_rentabilidad_51, t0.observaciones_rentabilidad AS observaciones_rentabilidad_52, t0.consumo_acumulado AS consumo_acumulado_53, t0.logo_hosteleria AS logo_hosteleria_54, t0.importe_bateria_virtual AS importe_bateria_virtual_55, t0.bateria_virtual AS bateria_virtual_56, t0.canal_id AS canal_id_57, t0.tipo_lectura_id AS tipo_lectura_id_58, t0.cliente_id AS cliente_id_59, t0.suministro_id AS suministro_id_60, t0.producto_id AS producto_id_61, t0.producto_proveedor_id AS producto_proveedor_id_62, t0.proveedor_id AS proveedor_id_63, t0.tipo_impuesto_id AS tipo_impuesto_id_64, t0.created_by_id AS created_by_id_65, t0.estado_id AS estado_id_66, t0.seller_id AS seller_id_67, t0.comision_cobrada_id AS comision_cobrada_id_68, t0.comision_pagada_id AS comision_pagada_id_69, t0.estado_financiero_id AS estado_financiero_id_70, t0.tipo_iva_id AS tipo_iva_id_71 FROM contrato t0 WHERE t0.id = ?"
  "params" => [
    1 => "4481"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM estado t0 WHERE t0.id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "UPDATE contrato SET estado_id = ? WHERE id = ?"
  "params" => [
    1 => 2
    2 => 4481
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "key" => "_security_main"
]

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

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

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

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

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

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

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

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

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

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

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

[
  "event" => "kernel.response"
  "listener" => "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse"
]

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

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

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

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

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