Symfony Profiler

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,
  JSON_EXTRACT(p.w_imagenes, '$.colores') AS colores,
  JSON_EXTRACT(p.w_imagenes, '$.version') AS versiones,
  p.url_video
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.slug = 'cocina-a-gas-milan-zafiro-indurama'

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 ,JSON_EXTRACT(p.w_imagenes,'$.colores') AS colores ,JSON_EXTRACT(p.w_imagenes,'$.version') AS versiones, p.url_video 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.slug = 'cocina-a-gas-milan-zafiro-indurama' ;

SELECT
  p.id,
  p.stockd as stock,
  IF(
    JSON_VALUE(p.w_det, '$.regla') IS NULL,
    3,
    1
  ) as regla,
  p.w_tpo,
  p.w_imagenes
FROM
  producto p
WHERE
  p.id in (8027)

SELECT p.id, p.stockd as stock,IF(JSON_VALUE(p.w_det,'$.regla')  IS NULL,3,1)  as regla, p.w_tpo, p.w_imagenes FROM producto p WHERE p.id in (8027);

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.linea IN (1)
  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 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.linea IN (1) 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
  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 (24)
  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 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 (24) 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,
  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', 'INFORMACION', 'SIMILARES',
    'TARJETAS_PRODUCTO'
  )

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

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
  w_det
FROM
  wb_paginas
WHERE
  id = 1

SELECT w_det FROM wb_paginas WHERE id=1;

SELECT
  *
FROM
  wb_preguntas
WHERE
  etd in(1)
  AND identificador = '8027'
  AND grupo = 'P'
  AND nombre_comercial IN (2, 0)

SELECT * FROM wb_preguntas WHERE etd in(1) AND identificador = '8027' AND grupo = 'P' AND nombre_comercial IN (2,0);