Symfony Profiler

[
  "route" => "solo_categoria_producto"
  "route_parameters" => [
    "_route" => "solo_categoria_producto"
    "tp" => "NaN"
    "_controller" => "App\Controller\Categorias\CategoriaController::productSoloSlug"
    "_prd" => "televisor-43ua7500psa-smart-tv-uhd-4k-led-lg"
  ]
  "request_uri" => "https://pruebav8.granhogar.com.ec/televisor-43ua7500psa-smart-tv-uhd-4k-led-lg/p"
  "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 valor FROM f_parametro WHERE codigo = 'IVA';"
]

[
  "sql" => "SELECT num,valor,descuento,vori FROM f_alicuota where etd = 1 "
]

[
  "sql" => "SELECT nombre, valor FROM f_parametro WHERE codigo = 'DNC' AND etd ='1'"
]

[
  "sql" => "SELECT p.id,p.nombre_web AS nombre,p.w_det,JSON_VALUE(p.w_imagenes, '$.version.a') AS img1, JSON_VALUE(p.w_det, '$.etiquetas') AS etiquetas,p.linea,p.slug,p.categoria,p.pvp,p.ivav,p.eme, e.n_ef, e.n_tc, p.plz_web, p.ivac, p.pvp_campana,  m.id AS mid,  m.nombre AS nmarca, p.tipo_pvp,IF(JSON_VALUE(p.w_det,'$.precio_envio') IS NULL,f.valor,JSON_VALUE(p.w_det,'$.precio_envio')) as precio_envio, p.w_imagenes ,c.slug AS slugC ,JSON_EXTRACT(p.w_imagenes,'$.colores') AS colores ,JSON_EXTRACT(p.w_imagenes,'$.version') AS versiones, p.url_video FROM producto p INNER JOIN f_eme e ON p.eme = e.id INNER JOIN marca m ON p.marca = m.id INNER JOIN categoria c ON p.categoria = c.id INNER JOIN f_parametro f ON f.codigo='PEPW'  WHERE p.slug = 'televisor-43ua7500psa-smart-tv-uhd-4k-led-lg' "
]

[
  "sql" => "SELECT p.id, p.stockd as stock,IF(JSON_VALUE(p.w_det,'$.regla')  IS NULL,3,1)  as regla, p.w_tpo, p.w_imagenes FROM producto p WHERE p.id in (10011)"
]

[
  "sql" => "SELECT p.id,p.nombre_web AS nombre,p.w_det,JSON_VALUE(p.w_imagenes, '$.version.a') AS img1, JSON_VALUE(p.w_det, '$.etiquetas') AS etiquetas,p.linea,p.slug,p.categoria,p.pvp,p.ivav,p.eme, e.n_ef, e.n_tc, p.plz_web, p.ivac, p.pvp_campana,  m.id AS mid,  m.nombre AS nmarca, p.tipo_pvp,IF(JSON_VALUE(p.w_det,'$.precio_envio') IS NULL,f.valor,JSON_VALUE(p.w_det,'$.precio_envio')) as precio_envio, p.w_imagenes ,c.slug AS slugC FROM producto p INNER JOIN f_eme e ON p.eme = e.id INNER JOIN marca m ON p.marca = m.id INNER JOIN categoria c ON p.categoria = c.id INNER JOIN f_parametro f ON f.codigo='PEPW'  WHERE  p.linea IN (2) 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 p.id,p.nombre_web AS nombre,p.w_det,JSON_VALUE(p.w_imagenes, '$.version.a') AS img1, JSON_VALUE(p.w_det, '$.etiquetas') AS etiquetas,p.linea,p.slug,p.categoria,p.pvp,p.ivav,p.eme, e.n_ef, e.n_tc, p.plz_web, p.ivac, p.pvp_campana,  m.id AS mid,  m.nombre AS nmarca, p.tipo_pvp,IF(JSON_VALUE(p.w_det,'$.precio_envio') IS NULL,f.valor,JSON_VALUE(p.w_det,'$.precio_envio')) as precio_envio, p.w_imagenes ,c.slug AS slugC FROM producto p INNER JOIN f_eme e ON p.eme = e.id INNER JOIN marca m ON p.marca = m.id INNER JOIN categoria c ON p.categoria = c.id INNER JOIN f_parametro f ON f.codigo='PEPW'  WHERE  p.categoria IN (39) 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,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', 'INFORMACION', 'SIMILARES', '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;
    """
]

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

[
  "sql" => "SELECT * FROM wb_preguntas WHERE etd in(1) AND identificador = '10011' AND grupo = 'P' AND nombre_comercial IN (2,0)"
]

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