Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

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
            FROM categoria AS t1
            LEFT JOIN categoria AS t2 ON t2.padre = t1.id
            LEFT JOIN linea AS l ON l.id = t1.linea
            WHERE t1.nivel = 1 AND t1.id > 1 AND t1.etd = 1 AND t2.etd = 1 AND t2.id in (
                SELECT DISTINCT(p.categoria) from producto p where  p.stockd >= IF(JSON_VALUE(w_det,'$.regla')  IS NULL,3,1) 
                AND p.marca <> 94 AND p.is_ret != 'SI' 
                AND p.w_img != 0 AND p.w_tpo='PUBLICAR')
            ORDER BY ctg ASC, subctg ASC;

[]

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
FROM
  categoria AS t1
  LEFT JOIN categoria AS t2 ON t2.padre = t1.id
  LEFT JOIN linea AS l ON l.id = t1.linea
WHERE
  t1.nivel = 1
  AND t1.id > 1
  AND t1.etd = 1
  AND t2.etd = 1
  AND t2.id in (
    SELECT
      DISTINCT(p.categoria)
    from
      producto p
    where
      p.stockd >= IF(
        JSON_VALUE(w_det, '$.regla') IS NULL,
        3,
        1
      )
      AND p.marca <> 94
      AND p.is_ret != 'SI'
      AND p.w_img != 0
      AND p.w_tpo = 'PUBLICAR'
  )
ORDER BY
  ctg ASC,
  subctg ASC;

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
            FROM categoria AS t1
            LEFT JOIN categoria AS t2 ON t2.padre = t1.id
            LEFT JOIN linea AS l ON l.id = t1.linea
            WHERE t1.nivel = 1 AND t1.id > 1 AND t1.etd = 1 AND t2.etd = 1 AND t2.id in (
                SELECT DISTINCT(p.categoria) from producto p where  p.stockd >= IF(JSON_VALUE(w_det,'$.regla')  IS NULL,3,1) 
                AND p.marca <> 94 AND p.is_ret != 'SI' 
                AND p.w_img != 0 AND p.w_tpo='PUBLICAR')
            ORDER BY ctg ASC, subctg ASC;;

SELECT 
            be.*, bc.nombre as nombre_categoria
            FROM wb_blog_entradas be 
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
            WHERE be.etd = 1 AND bc.nombre = ? ORDER BY be.f_crea DESC

[
  "Tips para el hogar"
]

SELECT
  be.*,
  bc.nombre as nombre_categoria
FROM
  wb_blog_entradas be
  INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
WHERE
  be.etd = 1
  AND bc.nombre = ?
ORDER BY
  be.f_crea DESC

SELECT 
            be.*, bc.nombre as nombre_categoria
            FROM wb_blog_entradas be 
            INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
            WHERE be.etd = 1 AND bc.nombre = 'Tips para el hogar' ORDER BY be.f_crea DESC;

SELECT id,slug FROM marca WHERE etd=1

[]

SELECT
  id,
  slug
FROM
  marca
WHERE
  etd = 1

SELECT id,slug FROM marca WHERE etd=1;

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

[]

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

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

SELECT w_det FROM wb_paginas WHERE id=10

[]

SELECT
  w_det
FROM
  wb_paginas
WHERE
  id = 10

SELECT w_det FROM wb_paginas WHERE id=10;

SELECT nombre FROM wb_blog_categorias WHERE estado = 1

[]

SELECT
  nombre
FROM
  wb_blog_categorias
WHERE
  estado = 1

SELECT nombre FROM wb_blog_categorias WHERE estado = 1;