|
17:37:30
|
security |
Read existing security token from the session.
Context: { "key": "_security_distribuidores" }
|
|
17:37:30
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: [2]
|
|
17:37:30
|
security |
User was reloaded from a user provider.
Context: { "username": "maenar", "provider": "Symfony\\Component\\Security\\Core\\User\\ChainUserProvider" }
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\FrameworkBundle\EventListener\SessionListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\FragmentListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Component\Security\Http\Firewall::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.request" to listener "Symfony\Bundle\AsseticBundle\EventListener\RequestListener::onKernelRequest".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ControllerListener::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\SecurityListener::onKernelController".
|
|
17:37:30
|
event |
Notified event "kernel.controller" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\TemplateListener::onKernelController".
|
|
17:37:30
|
doctrine |
SELECT h0_.id AS id0, h0_.horaInicio AS horaInicio1, h0_.horaFin AS horaFin2, h0_.ordersjson AS ordersjson3, h0_.furgon_id AS furgon_id4, h0_.Orders_id AS Orders_id5 FROM horariosDisponibles h0_ WHERE YEAR(h0_.horaInicio) = 2025 AND MONTH(h0_.horaInicio) = 10 AND DAY(h0_.horaInicio) = 3 GROUP BY h0_.horaInicio
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 8 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 8 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 8 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 9 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 9 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:30
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: ["21878"]
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 9 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 10 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 10 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 10 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 11 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 11 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 11 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 12 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 12 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:30
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 12 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:30
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 16 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:31
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 16 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:31
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: ["11105"]
|
|
17:37:31
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: ["39235"]
|
|
17:37:31
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: ["13725"]
|
|
17:37:31
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 16 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:31
|
doctrine |
SELECT f0_.id AS id0, f0_.conductor AS conductor1, f0_.marca AS marca2, f0_.modelo AS modelo3, f0_.telefono AS telefono4, f0_.fechaAlta AS fechaAlta5, f0_.matricula AS matricula6 FROM furgon f0_ INNER JOIN horariosDisponibles h1_ ON (YEAR(h1_.horaInicio) = 2025 AND MONTH(h1_.horaInicio) = 10 AND DAY(h1_.horaInicio) = 3 AND HOUR(h1_.horaInicio) = 17 AND MINUTE(h1_.horaInicio) = 0 AND f0_.id = h1_.furgon_id)
|
|
17:37:31
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 17 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id <> 2
|
|
17:37:31
|
doctrine |
SELECT t0.id AS id6, t0.firstname AS firstname7, t0.lastname AS lastname8, t0.email AS email9, t0.username AS username10, t0.password AS password11, t0.nif AS nif12, t0.company AS company13, t0.address AS address14, t0.cp AS cp15, t0.localidad AS localidad16, t0.provincia AS provincia17, t0.comunity AS comunity18, t0.phone AS phone19, t0.mphone AS mphone20, t0.salt AS salt21, t0.rol AS rol22, t0.codigorecuperacion AS codigorecuperacion23, t0.pathdnifrontal AS pathdnifrontal24, t0.pathdnitrasera AS pathdnitrasera25, t0.pathfoto AS pathfoto26, t0.pathrgpdfirmadofisico AS pathrgpdfirmadofisico27, t0.pathrgpdfirma AS pathrgpdfirma28, t0.firmadorgpdelectronico AS firmadorgpdelectronico29, t0.tieneCuenta AS tieneCuenta30, t0.tipoFianza AS tipoFianza31, t0.activo AS activo32, t0.bloqueado AS bloqueado33, t0.expirado AS expirado34, t0.tipo, t1.nombre AS nombre35, t1.latitud AS latitud36, t1.longitud AS longitud37, t1.especial AS especial38, t1.sendSMS AS sendSMS39, t1.entregadirectaacliente AS entregadirectaacliente40, t1.categorydistributor_id AS categorydistributor_id41, t1.gestorZona_id AS gestorZona_id42, t3.pagoWeb AS pagoWeb43, t3.descuento AS descuento44, t3.aceptacondiciones AS aceptacondiciones45, t3.distribuidor_id AS distribuidor_id46, t5.gestorzona_id AS gestorzona_id47 FROM User t0 LEFT JOIN Distributor t1 ON t0.id = t1.id LEFT JOIN admin t2 ON t0.id = t2.id LEFT JOIN UserWeb t3 ON t0.id = t3.id LEFT JOIN little t4 ON t0.id = t4.id LEFT JOIN gestorZonaUser t5 ON t0.id = t5.id WHERE t0.id = ?
Context: ["39633"]
|
|
17:37:31
|
doctrine |
SELECT o0_.id AS id0, o0_.numeroPedido AS numeroPedido1, o0_.tipoPedido AS tipoPedido2, o0_.subNumeroPedido AS subNumeroPedido3, o0_.parcial AS parcial4, o0_.stringnumeropedido AS stringnumeropedido5, o0_.diasPedido AS diasPedido6, o0_.fechaCreacion AS fechaCreacion7, o0_.fechaEntrega AS fechaEntrega8, o0_.fechaDevolucion AS fechaDevolucion9, o0_.fechaEstimadaDevolucion AS fechaEstimadaDevolucion10, o0_.momentoentrega AS momentoentrega11, o0_.estado AS estado12, o0_.deposito AS deposito13, o0_.metodopago AS metodopago14, o0_.importecobrado AS importecobrado15, o0_.horaRecogidaCliente AS horaRecogidaCliente16, o0_.horaRecogidaDistribuidor AS horaRecogidaDistribuidor17, o0_.servicioExpress AS servicioExpress18, o0_.serviciodomicilio AS serviciodomicilio19, o0_.recogidadomicilio AS recogidadomicilio20, o0_.recogidadistribuidor AS recogidadistribuidor21, o0_.recogidacentral AS recogidacentral22, o0_.importeRecargo AS importeRecargo23, o0_.direccion AS direccion24, o0_.cp AS cp25, o0_.localidad AS localidad26, o0_.provincia AS provincia27, o0_.personacontacto AS personacontacto28, o0_.telefonodomicilio AS telefonodomicilio29, o0_.observaciones AS observaciones30, o0_.observacionesDevolucion AS observacionesDevolucion31, o0_.entregadopor AS entregadopor32, o0_.numeropedidointerno AS numeropedidointerno33, o0_.numeropedidointernotemporal AS numeropedidointernotemporal34, o0_.personaentrega AS personaentrega35, o0_.costeserviciodomicilio AS costeserviciodomicilio36, o0_.especial AS especial37, o0_.inicial AS inicial38, o0_.devuelta AS devuelta39, o0_.copia AS copia40, o0_.notas AS notas41, o0_.saltarCargoLogistico AS saltarCargoLogistico42, o0_.temporal AS temporal43, o0_.albaraninterno AS albaraninterno44, o0_.personarecoge AS personarecoge45, o0_.personarealizapedido AS personarealizapedido46, o0_.origen AS origen47, o0_.signature AS signature48, o0_.tokeninfoentrega AS tokeninfoentrega49, o0_.smsenviado AS smsenviado50, o0_.denysendSMStoclient AS denysendSMStoclient51, o0_.latitud AS latitud52, o0_.longitud AS longitud53, o0_.distribuidor_id AS distribuidor_id54, o0_.pago_id AS pago_id55, o0_.usuario_id AS usuario_id56, o0_.rangosserviciodomicilio_id AS rangosserviciodomicilio_id57, o0_.codigoPromocional_id AS codigoPromocional_id58 FROM Orders o0_ WHERE YEAR(o0_.fechaEntrega) = 2025 AND MONTH(o0_.fechaEntrega) = 10 AND DAY(o0_.fechaEntrega) = 3 AND HOUR(o0_.horaRecogidaDistribuidor) = 17 AND MINUTE(o0_.horaRecogidaDistribuidor) = 0 AND o0_.temporal = 0 AND o0_.distribuidor_id = 2
|
|
17:37:31
|
security |
Stored the security token in the session.
Context: { "key": "_security_distribuidores" }
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Symfony\Component\Security\Http\RememberMe\ResponseListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Sensio\Bundle\FrameworkExtraBundle\EventListener\HttpCacheListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SaveSessionListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\StreamedResponseListener::onKernelResponse".
|
|
17:37:31
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
|
|
17:37:31
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\TranslatorListener::onKernelFinishRequest".
|
|
17:37:31
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
|
|
17:37:31
|
event |
Notified event "kernel.finish_request" to listener "Symfony\Component\Security\Http\Firewall::onKernelFinishRequest".
|