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 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 
        be.*, bc.nombre as nombre_categoria
        FROM wb_blog_entradas be 
        INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
        WHERE be.es_tendencia_principal = "SI" 
        AND be.etd = 1 
        LIMIT 3

[]

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.es_tendencia_principal = "SI"
  AND be.etd = 1
LIMIT
  3

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.es_tendencia_principal = "SI" 
        AND be.etd = 1 
        LIMIT 3;

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.es_tendencia = "SI" 
        AND be.etd = 1 
        LIMIT 2

[]

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.es_tendencia = "SI"
  AND be.etd = 1
LIMIT
  2

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.es_tendencia = "SI" 
        AND be.etd = 1 
        LIMIT 2;

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.es_tendencia_principal != "SI"
        AND be.es_tendencia != "SI"
        AND be.etd = 1

[]

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.es_tendencia_principal != "SI"
  AND be.es_tendencia != "SI"
  AND be.etd = 1

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.es_tendencia_principal != "SI"
        AND be.es_tendencia != "SI"
        AND be.etd = 1;

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

[]

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

SELECT 
        be.*, e.username, bc.nombre as nombre_categoria
        FROM wb_blog_entradas be 
        INNER JOIN empleado e ON e.id = be.u_crea 
        INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
        WHERE be.etd = 1
        ORDER BY be.vistas DESC 
        LIMIT 10;

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

[]

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

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

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

[]

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

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

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;