Symfony Profiler

[
  "route" => "app_categoria_producto"
  "route_parameters" => [
    "_route" => "app_categoria_producto"
    "ctg" => "lavadoras"
    "subct" => "lavadoras-semiautomaticas"
    "filtro1" => "NaN"
    "filtro2" => "NaN"
    "filtro3" => "NaN"
    "filtro4" => "NaN"
    "filtro5" => "NaN"
    "_controller" => "App\Controller\Categorias\CategoriaController::productSlug"
    "_line" => "electrodomesticos"
  ]
  "request_uri" => "https://pruebav8.granhogar.com.ec/electrodomesticos/lavadoras/lavadoras-semiautomaticas"
  "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 slug FROM categoria WHERE slug = 'lavadoras-semiautomaticas'"
]

[
  "sql" => "SELECT * FROM wb_enlaces wbe WHERE wbe.etd IN (1) AND wbe.slug = 'electrodomesticos/lavadoras/lavadoras-semiautomaticas' AND wbe.nombre_comercial = 2"
]

[
  "sql" => "SELECT id,linea,padre, nombre,w_det FROM categoria WHERE etd=1 AND slug = 'lavadoras-semiautomaticas'"
]

[
  "sql" => "SELECT id,nombre FROM marca WHERE id in (SELECT distinct(marca)  FROM producto p WHERE  p.categoria IN (30) AND p.etd = 1 AND p.w_img = 1 AND p.pvp > 0 AND p.stockd >= IF(JSON_VALUE(p.w_det,'$.regla') IS NULL, 3, 1) AND p.is_ret != 'SI' AND p.w_tpo = 'PUBLICAR' AND p.slug IS NOT NULL AND p.marca <> 94 AND p.precio_tc > 10 )"
]

[
  "sql" => "SELECT MAX(p.precio_tc) AS mascaro FROM producto p WHERE  p.categoria IN (30) AND p.etd = 1 AND p.w_img = 1 AND p.pvp > 0 AND p.stockd >= IF(JSON_VALUE(p.w_det,'$.regla') IS NULL, 3, 1) AND p.is_ret != 'SI' AND p.w_tpo = 'PUBLICAR' AND p.slug IS NOT NULL AND p.marca <> 94 AND p.precio_tc > 10 "
]

[
  "sql" => "SELECT DISTINCT(JSON_KEYS(JSON_VALUE(p.w_det,'$.filtros'))) AS filtro  FROM producto p  WHERE  p.categoria IN (30) AND JSON_VALUE(p.w_det,'$.filtros') IS NOT NULL AND p.etd = 1 AND p.w_img = 1 AND p.pvp > 0 AND p.stockd >= IF(JSON_VALUE(p.w_det,'$.regla') IS NULL, 3, 1) AND p.is_ret != 'SI' AND p.w_tpo = 'PUBLICAR' AND p.slug IS NOT NULL AND p.marca <> 94 AND p.precio_tc > 10 "
]

[
  "sql" => "SELECT id, pregunta, respuesta FROM wb_preguntas WHERE etd in(1) AND grupo = 'SC' AND identificador = '30' AND nombre_comercial = 2"
]

[
  "sql" => """
    SELECT id, etd, JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.descripcion_pagina')) AS descripcion, \n
                        JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.etd_descripcion_pagina')) AS etd_descripcion\n
                        FROM categoria WHERE etd = 1 AND slug = 'lavadoras-semiautomaticas'
    """
]

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

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