Symfony Profiler

[
  "route" => "app_blog"
  "route_parameters" => [
    "_route" => "app_blog"
    "_controller" => "App\Controller\Blog\BlogController::index"
  ]
  "request_uri" => "https://pruebav8.granhogar.com.ec/blog"
  "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"
]

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

[
  "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\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" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "log_sistemas"
    "charset" => "utf8mb4"
  ]
]

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

[
  "event" => "kernel.controller"
  "listener" => "App\EventListener\Interceptor::onController"
]

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

[
  "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" => "Symfony\Component\HttpKernel\Controller\ArgumentResolver\RequestPayloadValueResolver::onKernelControllerArguments"
]

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

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "66.1.0.9"
    "port" => 3306
    "user" => "pruebas"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "gpi_t5"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => """
    SELECT t2.id,t1.linea,l.nombre AS nombre_linea,l.slug AS slugL,t1.id idp,t1.nombre ctg,t1.slug as slugC,t2.nombre subctg,t2.slug as slugS\n
                FROM categoria AS t1\n
                LEFT JOIN categoria AS t2 ON t2.padre = t1.id\n
                LEFT JOIN linea AS l ON l.id = t1.linea\n
                WHERE t1.nivel = 1 AND t1.id > 1 AND t1.etd = 1 AND t2.etd = 1 AND t2.id in (\n
                    SELECT DISTINCT(p.categoria) from producto p where  p.stockd >= IF(JSON_VALUE(w_det,'$.regla')  IS NULL,3,1) \n
                    AND p.marca <> 94 AND p.is_ret != 'SI' \n
                    AND p.w_img != 0 AND p.w_tpo='PUBLICAR')\n
                ORDER BY ctg ASC, subctg ASC;
    """
]

[
  "sql" => "SELECT id,slug FROM marca WHERE etd=1"
]

[
  "sql" => "SELECT * FROM wb_seccion WHERE etd = 1 and FIND_IN_SET(2, nombre_comercial) > 0 AND tipo IN ('PIE', 'TARJETAS_PRODUCTO')"
]

[
  "sql" => "SELECT w_det FROM wb_paginas WHERE id=10"
]

[
  "sql" => """
    SELECT \n
            be.*, bc.nombre as nombre_categoria\n
            FROM wb_blog_entradas be \n
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria\n
            WHERE be.es_tendencia_principal = "SI" \n
            AND be.etd = 1 \n
            LIMIT 3
    """
]

[
  "sql" => """
    SELECT \n
            be.*, bc.nombre as nombre_categoria\n
            FROM wb_blog_entradas be \n
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria\n
            WHERE be.es_tendencia = "SI" \n
            AND be.etd = 1 \n
            LIMIT 2
    """
]

[
  "sql" => """
    SELECT \n
            be.*, bc.nombre as nombre_categoria\n
            FROM wb_blog_entradas be \n
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria\n
            WHERE be.es_tendencia_principal != "SI"\n
            AND be.es_tendencia != "SI"\n
            AND be.etd = 1
    """
]

[
  "sql" => """
    SELECT \n
            be.*, e.username, bc.nombre as nombre_categoria\n
            FROM wb_blog_entradas be \n
            INNER JOIN empleado e ON e.id = be.u_crea \n
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria\n
            WHERE be.etd = 1\n
            ORDER BY be.vistas DESC \n
            LIMIT 10
    """
]

[
  "sql" => """
    SELECT \n
                                bb.id, \n
                                bb.imagen_escritorio, \n
                                bb.imagen_movil, \n
                                bb.tipo, \n
                                CASE \n
                                    WHEN be.titulo IS NOT NULL THEN be.titulo \n
                                    ELSE "No definido" \n
                                END AS identificador,\n
                                bb.estado,\n
                                be.slug\n
                                FROM \n
                                    wb_blog_banners bb\n
                                LEFT JOIN \n
                                    wb_blog_entradas be \n
                                ON \n
                                    be.id = bb.identificador\n
                                WHERE bb.estado = "Activo"\n
                                AND bb.tipo = "Portada"\n
                                
    """
]

[
  "sql" => """
    SELECT \n
                                bb.id, \n
                                bb.imagen_escritorio, \n
                                bb.imagen_movil, \n
                                bb.tipo, \n
                                CASE \n
                                    WHEN be.titulo IS NOT NULL THEN be.titulo \n
                                    ELSE "No definido" \n
                                END AS identificador,\n
                                bb.estado,\n
                                be.slug\n
                                FROM \n
                                    wb_blog_banners bb\n
                                LEFT JOIN \n
                                    wb_blog_entradas be \n
                                ON \n
                                    be.id = bb.identificador\n
                                WHERE bb.estado = "Activo"\n
                                AND bb.tipo = "Footer"\n
                                
    """
]

[
  "sql" => "SELECT nombre FROM wb_blog_categorias WHERE estado = 1"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::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"
]