Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• 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 DISTINCT(JSON_KEYS(JSON_VALUE(p.w_det,'$.filtros'))) AS filtro  FROM producto p  WHERE  p.categoria IN (51,52,53,54,103) 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

[]

SELECT
  DISTINCT(
    JSON_KEYS(
      JSON_VALUE(p.w_det, '$.filtros')
    )
  ) AS filtro
FROM
  producto p
WHERE
  p.categoria IN (51, 52, 53, 54, 103)
  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

SELECT DISTINCT(JSON_KEYS(JSON_VALUE(p.w_det,'$.filtros'))) AS filtro  FROM producto p  WHERE  p.categoria IN (51,52,53,54,103) 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 ;

SELECT id,nombre FROM marca WHERE id in (SELECT distinct(marca)  FROM producto p WHERE  p.categoria IN (51,52,53,54,103) 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 )

[]

SELECT
  id,
  nombre
FROM
  marca
WHERE
  id in (
    SELECT
      distinct(marca)
    FROM
      producto p
    WHERE
      p.categoria IN (51, 52, 53, 54, 103)
      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
  )

SELECT id,nombre FROM marca WHERE id in (SELECT distinct(marca)  FROM producto p WHERE  p.categoria IN (51,52,53,54,103) 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 );

SELECT MAX(p.precio_tc) AS mascaro FROM producto p WHERE  p.categoria IN (51,52,53,54,103) 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

[]

SELECT
  MAX(p.precio_tc) AS mascaro
FROM
  producto p
WHERE
  p.categoria IN (51, 52, 53, 54, 103)
  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

SELECT MAX(p.precio_tc) AS mascaro FROM producto p WHERE  p.categoria IN (51,52,53,54,103) 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 ;

SELECT id, pregunta, respuesta FROM wb_preguntas WHERE etd in(1) AND grupo = 'C' AND identificador = '12' AND nombre_comercial = 2

[]

SELECT
  id,
  pregunta,
  respuesta
FROM
  wb_preguntas
WHERE
  etd in(1)
  AND grupo = 'C'
  AND identificador = '12'
  AND nombre_comercial = 2

SELECT id, pregunta, respuesta FROM wb_preguntas WHERE etd in(1) AND grupo = 'C' AND identificador = '12' AND nombre_comercial = 2;

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 id, etd, JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.descripcion_pagina')) AS descripcion, 
                    JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.etd_descripcion_pagina')) AS etd_descripcion
                    FROM categoria WHERE etd = 1 AND slug = 'muebles-de-sala'

[]

SELECT
  id,
  etd,
  JSON_UNQUOTE(
    JSON_EXTRACT(w_det, '$.descripcion_pagina')
  ) AS descripcion,
  JSON_UNQUOTE(
    JSON_EXTRACT(
      w_det, '$.etd_descripcion_pagina'
    )
  ) AS etd_descripcion
FROM
  categoria
WHERE
  etd = 1
  AND slug = 'muebles-de-sala'

SELECT id, etd, JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.descripcion_pagina')) AS descripcion, 
                    JSON_UNQUOTE(JSON_EXTRACT(w_det, '$.etd_descripcion_pagina')) AS etd_descripcion
                    FROM categoria WHERE etd = 1 AND slug = 'muebles-de-sala';

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 * FROM wb_enlaces wbe WHERE wbe.etd IN (1) AND wbe.slug = 'muebles/muebles-de-sala' AND wbe.nombre_comercial = 2

[]

SELECT
  *
FROM
  wb_enlaces wbe
WHERE
  wbe.etd IN (1)
  AND wbe.slug = 'muebles/muebles-de-sala'
  AND wbe.nombre_comercial = 2

SELECT * FROM wb_enlaces wbe WHERE wbe.etd IN (1) AND wbe.slug = 'muebles/muebles-de-sala' AND wbe.nombre_comercial = 2;

SELECT id,linea, nombre,w_det FROM categoria Where etd=1 AND slug = 'muebles-de-sala'

[]

SELECT
  id,
  linea,
  nombre,
  w_det
FROM
  categoria
Where
  etd = 1
  AND slug = 'muebles-de-sala'

SELECT id,linea, nombre,w_det FROM categoria Where etd=1 AND slug = 'muebles-de-sala';

SELECT slug FROM categoria WHERE slug = 'NaN'

[]

SELECT
  slug
FROM
  categoria
WHERE
  slug = 'NaN'

SELECT slug FROM categoria WHERE slug = 'NaN';

SELECT GROUP_CONCAT(c.id) as ids FROM categoria c WHERE c.padre=12

[]

SELECT
  GROUP_CONCAT(c.id) as ids
FROM
  categoria c
WHERE
  c.padre = 12

SELECT GROUP_CONCAT(c.id) as ids FROM categoria c WHERE c.padre=12;