Symfony Profiler

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 <> 'INFORMACION'

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

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
  valor
FROM
  f_parametro
WHERE
  codigo = 'IVA';

SELECT valor FROM f_parametro WHERE codigo = 'IVA';;

SELECT
  num,
  valor,
  descuento,
  vori
FROM
  f_alicuota
where
  etd = 1

SELECT num,valor,descuento,vori FROM f_alicuota where etd = 1 ;

SELECT
  nombre,
  valor
FROM
  f_parametro
WHERE
  codigo = 'DNC'
  AND etd = '1'

SELECT nombre, valor FROM f_parametro WHERE codigo = 'DNC' AND etd ='1';

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.estado_campana = 'ACTIVO'
  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
ORDER BY
  RAND()

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.estado_campana = 'ACTIVO' 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 ORDER BY RAND();

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.estado_campana = 'ACTIVO'
  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
  AND p.precio_tc <= 300
ORDER BY
  RAND()

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.estado_campana = 'ACTIVO' 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 AND p.precio_tc <= 300 ORDER BY RAND();

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.estado_campana = 'ACTIVO'
  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
ORDER BY
  RAND()

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.estado_campana = 'ACTIVO' 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 ORDER BY RAND();

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.is_fav_mth = 'SI'
  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
ORDER BY
  RAND()

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.is_fav_mth='SI' 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 ORDER BY RAND();

SELECT
  categoria
from
  wb_seccion
WHERE
  tipo = 'RELACIONADOS'

SELECT categoria from wb_seccion WHERE tipo = 'RELACIONADOS';

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
ORDER BY
  RAND()
LIMIT
  15

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 ORDER BY RAND() LIMIT 15;

SELECT
  categoria
from
  wb_seccion
WHERE
  tipo = 'RELACIONADOS'

SELECT categoria from wb_seccion WHERE tipo = 'RELACIONADOS';

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
ORDER BY
  RAND()
LIMIT
  15

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 ORDER BY RAND() LIMIT 15;

SELECT
  w_det
FROM
  wb_paginas
WHERE
  id = 1

SELECT w_det FROM wb_paginas WHERE id=1;