Symfony Profiler

[
  "route" => "app_solo_noticia"
  "route_parameters" => [
    "_route" => "app_solo_noticia"
    "_controller" => "App\Controller\Blog\BlogController::solo_noticia"
    "title" => "La-guía-rápida-para-ahorrar-energía-con-tus-electrodomésticos"
  ]
  "request_uri" => "https://pruebav8.granhogar.com.ec/blog/La-gu%C3%ADa-r%C3%A1pida-para-ahorrar-energ%C3%ADa-con-tus-electrodom%C3%A9sticos"
  "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 be.*,\n
                    CONCAT(\n
                        DAY(be.f_crea), \n
                        ' de ', \n
                        CASE MONTH(be.f_crea)\n
                            WHEN 1 THEN 'Enero,'\n
                            WHEN 2 THEN 'Febrero,'\n
                            WHEN 3 THEN 'Marzo,'\n
                            WHEN 4 THEN 'Abril,'\n
                            WHEN 5 THEN 'Mayo,'\n
                            WHEN 6 THEN 'Junio,'\n
                            WHEN 7 THEN 'Julio,'\n
                            WHEN 8 THEN 'Agosto,'\n
                            WHEN 9 THEN 'Septiembre,'\n
                            WHEN 10 THEN 'Octubre,'\n
                            WHEN 11 THEN 'Noviembre,'\n
                            WHEN 12 THEN 'Diciembre,'\n
                        END,\n
                        ' de ',\n
                        YEAR(be.f_crea)\n
                    ) as fecha_formateada, 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.slug = 'La-guía-rápida-para-ahorrar-energía-con-tus-electrodomésticos'\n
                
    """
]

[
  "sql" => "UPDATE wb_blog_entradas SET vistas = COALESCE(vistas, 0) + 1 WHERE id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#660
      +name: "STRING"
    }
  ]
]

[
  "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.etd = 1\n
                ORDER BY be.vistas DESC \n
                LIMIT 10
    """
]

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

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