Symfony Profiler

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "34.75.162.77"
    "port" => 3306
    "user" => "rifusr"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "5.7"
    "defaultTableOptions" => []
    "dbname" => "rifu"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1"
  "params" => [
    1 => "rifutest.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "route" => "app_front_detalle_gestor_nombre"
  "route_parameters" => [
    "_route" => "app_front_detalle_gestor_nombre"
    "_controller" => "App\Controller\Front\DetalleGestorController::index"
    "_locale" => "es"
    "gestorNombre" => "david-duque"
    "gestorId" => "270"
  ]
  "request_uri" => "https://rifutest.com/gestor/david-duque/270"
  "method" => "GET"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "host" => "34.75.162.77"
    "port" => 3306
    "user" => "rifusr"
    "password" => "<redacted>"
    "driverOptions" => []
    "wrapperClass" => "MultiTenancyBundle\Doctrine\DBAL\TenantConnectionWrapper"
    "serverVersion" => "5.7"
    "defaultTableOptions" => []
    "dbname" => "rifu_rifu"
  ]
]

[
  "sql" => "SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC"
]

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

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

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

[
  "sql" => "SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;"
]

[
  "sql" => """
    \n
                    SELECT valor from main_setting where llave = 'validate_integrity';\n
                
    """
]

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

[
  "event" => "kernel.request"
  "listener" => "MultiTenancyBundle\EventListener\TenantRequestListener::onKernelRequest"
]

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

[
  "event" => "kernel.request"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::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" => "ApiPlatform\Symfony\EventListener\AddFormatListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\UserStatusSubscriber::checkUserStatus"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\QueryParameterValidateListener::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" => "App\EventListener\VpnCheckListener::onKernelRequest"
]

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

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

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\ReadListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "ApiPlatform\Symfony\EventListener\DeserializeListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventListener\KernelRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "App\EventSubscriber\RequestLogSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController"
]

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

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

[
  "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" => "ContainerTE6xxaz\RequestPayloadValueResolverGhost3590451::onKernelControllerArguments"
]

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

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.documento AS documento_3, t0.email AS email_4, t0.telefono AS telefono_5, t0.red_social AS red_social_6, t0.aprueba_tyc AS aprueba_tyc_7, t0.destacado AS destacado_8, t0.numero_rifas AS numero_rifas_9, t0.password AS password_10, t0.roles AS roles_11, t0.apellidos AS apellidos_12, t0.activar_boletin AS activar_boletin_13, t0.perfil_red_social AS perfil_red_social_14, t0.calificacion AS calificacion_15, t0.imagen_perfil AS imagen_perfil_16, t0.nombre_gestor AS nombre_gestor_17, t0.apodo AS apodo_18, t0.fecha_nacimiento AS fecha_nacimiento_19, t0.fecha_expedicion AS fecha_expedicion_20, t0.editable AS editable_21, t0.imagen_banner AS imagen_banner_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.fecha_ultimo_login AS fecha_ultimo_login_25, t0.ultima_direccion_ip AS ultima_direccion_ip_26, t0.fecha_ultimo_cambio_clave AS fecha_ultimo_cambio_clave_27, t0.fecha_activacion AS fecha_activacion_28, t0.fecha_desactivacion AS fecha_desactivacion_29, t0.activo AS activo_30, t0.envio_comentario AS envio_comentario_31, t0.saldo_retirable AS saldo_retirable_32, t0.saldo_no_retirable AS saldo_no_retirable_33, t0.descripcion_perfil AS descripcion_perfil_34, t0.intentos_login AS intentos_login_35, t0.acepta_cookies AS acepta_cookies_36, t0.metodo_registro AS metodo_registro_37, t0.direccion AS direccion_38, t0.acepta_correos AS acepta_correos_39, t0.token AS token_40, t0.acepta_monitoreo_cta AS acepta_monitoreo_cta_41, t0.email_contacto AS email_contacto_42, t0.tipo_persona_id AS tipo_persona_id_43, t0.certificado_existencia_id AS certificado_existencia_id_44, t0.documento_representante_id AS documento_representante_id_45, t0.imagen_perfil_principal_id AS imagen_perfil_principal_id_46, t0.imagen_banner_principal_id AS imagen_banner_principal_id_47, t0.estado_gestor_id AS estado_gestor_id_48, t0.ciudad_id AS ciudad_id_49, t0.imagen_destacada_id AS imagen_destacada_id_50, t51.id AS id_52, t51.updated_at AS updated_at_53, t51.created_at AS created_at_54, t51.usuario_id AS usuario_id_55, t51.estado_id AS estado_id_56, t51.acceso_rifas_id AS acceso_rifas_id_57, t0.tipo_documento_id AS tipo_documento_id_58 FROM usuario t0 LEFT JOIN acceso t51 ON t51.usuario_id = t0.id WHERE t0.id = ?"
  "params" => [
    1 => 270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.iso AS iso_2, t0.conversion_rate_to_usd AS conversion_rate_to_usd_3, t0.symbol AS symbol_4 FROM currency t0"
]

[
  "sql" => "SELECT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, l4_.locale AS locale_4, r0_.fecha_sorteo AS fecha_sorteo_5, r5_.valor AS valor_6, DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7, (r0_.numero_fin - r0_.numero_inicio) AS sclr_8 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c6_ ON r5_.currency_id = c6_.id INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id) WHERE e7_.ref = ? AND u3_.activo = 1 AND e8_.nombre = ? AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND u3_.id = ? AND c6_.iso = ? AND COALESCE(r0_.es_suscripcion, 0) = 0 ORDER BY r0_.fecha_sorteo ASC LIMIT 1"
  "params" => [
    1 => "APROBADA"
    2 => "Aprobado"
    3 => 270
    4 => "COP"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, l4_.locale AS locale_4, r0_.fecha_sorteo AS fecha_sorteo_5, r5_.valor AS valor_6, DATEDIFF(r0_.fecha_fin, CURRENT_DATE) AS sclr_7, (r0_.numero_fin - r0_.numero_inicio) AS sclr_8 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c6_ ON r5_.currency_id = c6_.id INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN estado_solicitud e8_ ON (e8_.id = u3_.estado_gestor_id) WHERE e7_.ref = ? AND u3_.activo = 1 AND e8_.nombre = ? AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND u3_.id = ? AND c6_.iso = ? AND r0_.es_suscripcion = 1 ORDER BY r0_.fecha_sorteo ASC LIMIT 1"
  "params" => [
    1 => "APROBADA"
    2 => "Aprobado"
    3 => 270
    4 => "COP"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 1
    4 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT r0_.id AS id_0, i1_.image AS image_1, r2_.nombre AS nombre_2, u3_.nombre AS nombre_3, u3_.apellidos AS apellidos_4, l4_.locale AS locale_5, r0_.fecha_sorteo AS fecha_sorteo_6, r5_.valor AS valor_7, DATEDIFF(r0_.fecha_sorteo, CURRENT_DATE) AS sclr_8, (r0_.numero_fin - r0_.numero_inicio) AS sclr_9, u6_.nombre AS nombre_10, u6_.apellidos AS apellidos_11, p7_.es_ganador AS es_ganador_12, p7_.folio AS folio_13 FROM rifa r0_ INNER JOIN usuario u3_ ON (u3_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l4_ ON r2_.locale_id = l4_.id INNER JOIN rifa_currency r5_ ON (r0_.id = r5_.objeto_id) INNER JOIN currency c8_ ON r5_.currency_id = c8_.id LEFT JOIN imagen i1_ ON (r0_.imagen_base_id = i1_.id) INNER JOIN estado_rifa e9_ ON (e9_.id = r0_.estado_id) INNER JOIN producto p7_ ON (p7_.rifa_id = r0_.id) INNER JOIN usuario u6_ ON (p7_.comprador_id = u6_.id) WHERE u3_.id = ? AND c8_.iso = ? AND e9_.ref = ? AND r0_.fecha_sorteo < CURRENT_DATE AND p7_.es_ganador = 1"
  "params" => [
    1 => 270
    2 => "COP"
    3 => "APROBADA"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT DISTINCT count(DISTINCT r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN usuario u1_ ON (u1_.id = r0_.gestor_id) INNER JOIN rifa_translation r2_ ON (r0_.id = r2_.objeto_id) INNER JOIN locale l3_ ON r2_.locale_id = l3_.id INNER JOIN rifa_currency r4_ ON (r0_.id = r4_.objeto_id) INNER JOIN currency c5_ ON r4_.currency_id = c5_.id LEFT JOIN imagen i6_ ON (r0_.imagen_base_id = i6_.id) INNER JOIN estado_rifa e7_ ON (e7_.id = r0_.estado_id) INNER JOIN producto p8_ ON (p8_.rifa_id = r0_.id) INNER JOIN usuario u9_ ON (p8_.comprador_id = u9_.id) WHERE u1_.id = ? AND c5_.iso = ? AND e7_.ref = ? AND r0_.fecha_sorteo < CURRENT_DATE AND p8_.es_ganador = 1"
  "params" => [
    1 => 270
    2 => "COP"
    3 => "APROBADA"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.orden AS orden_2, t0.visible AS visible_3, t0.perfil AS perfil_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.red_social_id AS red_social_id_7, t0.usuario_id AS usuario_id_8 FROM redes_sociales_usuario t0 WHERE t0.usuario_id = ?"
  "params" => [
    1 => 270
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 780
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 782
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 781
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 783
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 784
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.dominio AS dominio_3, t0.orden AS orden_4, t0.visible AS visible_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.icono_id AS icono_id_8 FROM redes_sociales t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 785
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 1194
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.image AS image_2, t0.image_mobile AS image_mobile_3, t0.path AS path_4, t0.link AS link_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.visible AS visible_8, t0.orden AS orden_9, t0.llave AS llave_10, t0.galeria_id AS galeria_id_11, t0.rifa_id AS rifa_id_12 FROM imagen t0 WHERE t0.id = ?"
  "params" => [
    1 => 1195
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN estado_rifa e1_ ON r0_.estado_id = e1_.id WHERE r0_.gestor_id = ? AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND e1_.ref = ? AND COALESCE(r0_.es_suscripcion, 0) = ?"
  "params" => [
    1 => 270
    2 => "APROBADA"
    3 => 0
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN estado_rifa e1_ ON r0_.estado_id = e1_.id WHERE r0_.gestor_id = ? AND r0_.fecha_fin >= CURRENT_TIMESTAMP AND e1_.ref = ? AND COALESCE(r0_.es_suscripcion, 0) = ?"
  "params" => [
    1 => 270
    2 => "APROBADA"
    3 => 1
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 5
  ]
]

[
  "sql" => "SELECT COUNT(r0_.id) AS sclr_0 FROM rifa r0_ INNER JOIN estado_rifa e1_ ON (e1_.id = r0_.estado_id) WHERE r0_.gestor_id = ? AND e1_.ref = ? AND r0_.fecha_fin < CURRENT_DATE"
  "params" => [
    1 => 270
    2 => "APROBADA"
  ]
  "types" => [
    1 => 1
    2 => 2
  ]
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.precio AS precio_1, p0_.frecuencia AS frecuencia_2, p0_.enabled AS enabled_3, p0_.fecha_creacion AS fecha_creacion_4, p0_.bono_descuento AS bono_descuento_5, p0_.gestor_id AS gestor_id_6, p0_.estado_id AS estado_id_7 FROM plan p0_ INNER JOIN usuario u1_ ON p0_.gestor_id = u1_.id INNER JOIN estado_suscripcion e2_ ON p0_.estado_id = e2_.id WHERE u1_.id = ? AND e2_.nombre IN (?, ?)"
  "params" => [
    1 => 270
    2 => "APROBADO"
    3 => "PENDIENTE"
  ]
  "types" => [
    1 => 1
    2 => 2
    3 => 2
  ]
]

[
  "sql" => "SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.url AS url_1, i1_.image AS image_2, s2_.titulo AS titulo_3, s2_.keywords AS keywords_4, s2_.descripcion AS descripcion_5 FROM seo s0_ LEFT JOIN seo_translation s2_ ON s0_.id = s2_.objeto_id LEFT JOIN locale l3_ ON s2_.locale_id = l3_.id LEFT JOIN imagen i1_ ON s0_.imagen_id = i1_.id WHERE s0_.url = ? AND l3_.locale = ?"
  "params" => [
    1 => "gestor/david-duque/270"
    2 => "es"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.url AS url_1, i1_.image AS image_2, s2_.titulo AS titulo_3, s2_.keywords AS keywords_4, s2_.descripcion AS descripcion_5 FROM seo s0_ LEFT JOIN seo_translation s2_ ON s0_.id = s2_.objeto_id LEFT JOIN locale l3_ ON s2_.locale_id = l3_.id LEFT JOIN imagen i1_ ON s0_.imagen_id = i1_.id WHERE s0_.url = ? AND l3_.locale = ?"
  "params" => [
    1 => "/"
    2 => "es"
  ]
  "types" => [
    1 => 2
    2 => 2
  ]
]

[
  "sql" => "SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto t0_ LEFT JOIN texto_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC"
]

[
  "sql" => "SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_5 FROM imagen i0_ INNER JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) INNER JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 GROUP BY i0_.id ORDER BY i0_.orden ASC"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1"
  "params" => [
    1 => "rifutest.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1"
  "params" => [
    1 => "rifutest.com"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0_.llave AS llave_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', t2_.valor)) AS sclr_1 FROM texto_big t0_ LEFT JOIN texto_big_translation t2_ ON t0_.id = t2_.objeto_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC"
]

[
  "sql" => "SELECT i0_.llave AS llave_0, g1_.llave AS llave_1, i0_.path AS path_2, i0_.link AS link_3, i0_.image AS image_4, i0_.image_mobile AS image_mobile_5, GROUP_CONCAT(JSON_OBJECT('locale', l2_.locale, 'valor', i3_.titulo, 'resumen', i3_.resumen)) AS sclr_6 FROM imagen i0_ INNER JOIN galeria g1_ ON (i0_.galeria_id = g1_.id) LEFT JOIN imagen_translation i3_ ON (i0_.id = i3_.objeto_id) LEFT JOIN locale l2_ ON i3_.locale_id = l2_.id WHERE i0_.visible = 1 AND g1_.llave = ? GROUP BY i0_.id ORDER BY i0_.orden ASC"
  "params" => [
    1 => "social_media"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT v0_.id AS id_0, v0_.version AS version_1, v0_.created_at AS created_at_2, v0_.updated_at AS updated_at_3 FROM version_aplicacion v0_ ORDER BY v0_.id DESC LIMIT 1"
]

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

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

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "App\EventSubscriber\UtmCookieSubscriber::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" => "Zely\ZelyBigQueryBundle\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse"
]

[
  "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"
]