Symfony Profiler

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

Query Metrics

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

SELECT be.*,
                CONCAT(
                    DAY(be.f_crea), 
                    ' de ', 
                    CASE MONTH(be.f_crea)
                        WHEN 1 THEN 'Enero,'
                        WHEN 2 THEN 'Febrero,'
                        WHEN 3 THEN 'Marzo,'
                        WHEN 4 THEN 'Abril,'
                        WHEN 5 THEN 'Mayo,'
                        WHEN 6 THEN 'Junio,'
                        WHEN 7 THEN 'Julio,'
                        WHEN 8 THEN 'Agosto,'
                        WHEN 9 THEN 'Septiembre,'
                        WHEN 10 THEN 'Octubre,'
                        WHEN 11 THEN 'Noviembre,'
                        WHEN 12 THEN 'Diciembre,'
                    END,
                    ' de ',
                    YEAR(be.f_crea)
                ) as fecha_formateada, bc.nombre as nombre_categoria 
                FROM wb_blog_entradas be
                INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
                WHERE be.slug = '¿-Cuál-es-la-mejor-marca-de-refrigeradoras-en-Ecuador-?'

[]

SELECT
  be.*,
  CONCAT(
    DAY(be.f_crea),
    ' de ',
    CASE MONTH(be.f_crea)
    WHEN 1 THEN
      'Enero,'
    WHEN 2 THEN
      'Febrero,'
    WHEN 3 THEN
      'Marzo,'
    WHEN 4 THEN
      'Abril,'
    WHEN 5 THEN
      'Mayo,'
    WHEN 6 THEN
      'Junio,'
    WHEN 7 THEN
      'Julio,'
    WHEN 8 THEN
      'Agosto,'
    WHEN 9 THEN
      'Septiembre,'
    WHEN 10 THEN
      'Octubre,'
    WHEN 11 THEN
      'Noviembre,'
    WHEN 12 THEN
      'Diciembre,'
    END,
    ' de ',
    YEAR(be.f_crea)
  ) as fecha_formateada,
  bc.nombre as nombre_categoria
FROM
  wb_blog_entradas be
  INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
WHERE
  be.slug = '¿-Cuál-es-la-mejor-marca-de-refrigeradoras-en-Ecuador-?'

SELECT be.*,
                CONCAT(
                    DAY(be.f_crea), 
                    ' de ', 
                    CASE MONTH(be.f_crea)
                        WHEN 1 THEN 'Enero,'
                        WHEN 2 THEN 'Febrero,'
                        WHEN 3 THEN 'Marzo,'
                        WHEN 4 THEN 'Abril,'
                        WHEN 5 THEN 'Mayo,'
                        WHEN 6 THEN 'Junio,'
                        WHEN 7 THEN 'Julio,'
                        WHEN 8 THEN 'Agosto,'
                        WHEN 9 THEN 'Septiembre,'
                        WHEN 10 THEN 'Octubre,'
                        WHEN 11 THEN 'Noviembre,'
                        WHEN 12 THEN 'Diciembre,'
                    END,
                    ' de ',
                    YEAR(be.f_crea)
                ) as fecha_formateada, bc.nombre as nombre_categoria 
                FROM wb_blog_entradas be
                INNER JOIN wb_blog_categorias bc ON bc.id = be.categoria
                WHERE be.slug = '¿-Cuál-es-la-mejor-marca-de-refrigeradoras-en-Ecuador-?'
            ;

UPDATE wb_blog_entradas SET vistas = COALESCE(vistas, 0) + 1 WHERE id = ?

[
  11
]

UPDATE
  wb_blog_entradas
SET
  vistas = COALESCE(vistas, 0) + 1
WHERE
  id = ?

UPDATE wb_blog_entradas SET vistas = COALESCE(vistas, 0) + 1 WHERE id = 11;

"COMMIT"

[]

"COMMIT"

"COMMIT";

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
            ORDER BY be.vistas DESC 
            LIMIT 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.etd = 1
ORDER BY
  be.vistas DESC
LIMIT
  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.etd = 1
            ORDER BY be.vistas DESC 
            LIMIT 10;

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;