| 0.0005 |
SELECT *
FROM (`categoria`)
WHERE `activo` = 'S'
AND `nombre` != ''
ORDER BY `destacado` DESC, `nombre` ASC
|
| 0.0012 |
SELECT `prod`.`idproducto` AS idproducto, `prod`.`etiqueta` AS etiqueta, `prod`.`nombre` AS nombre, `prod`.`detalle` AS detalle, `prod`.`precio` AS precio, `prod`.`tipo` AS tipo
FROM (`producto` prod)
WHERE `activo` = 'S'
AND `etiqueta` != ''
GROUP BY `prod`.`idproducto`
|
| 0.0060 |
SELECT *
FROM (`producto`)
WHERE `activo` = 'S'
AND `oferta` = 'O'
AND `oferta` != ''
ORDER BY RAND()
|
| 0.0036 |
SELECT *
FROM (`producto`)
WHERE `activo` = 'S'
AND `novedad` != ''
AND `novedad` = 'N'
|
| 0.0243 |
SELECT `prod`.`idproducto` AS idproducto, SUM(pedprod.cantidad) AS cantidad, `prod`.`nombre` AS nombre, `pedprod`.`cantidad` AS cantidad, `prod`.`codigo` AS codigo
FROM (`producto` prod)
JOIN `pedido_producto` pedprod ON `pedprod`.`producto_idproducto`= `prod`.`idproducto`
GROUP BY `pedprod`.`producto_idproducto`
ORDER BY `pedprod`.`cantidad` DESC
LIMIT 3
|
| 0.0035 |
SELECT `prod`.`idproducto` AS idproducto, `prod`.`nombre` AS nombre, `prod`.`detalle` AS detalle, `prod`.`precio` AS precio, `prod`.`tipo` AS tipo, SUM(prod.visita) AS visita
FROM (`producto` prod)
WHERE `activo` = 'S'
AND `visita` != '0'
GROUP BY `prod`.`idproducto`
ORDER BY `prod`.`visita` DESC
LIMIT 4
|
| 0.0001 |
SELECT *
FROM (`banner`)
WHERE `activo` = 'S'
AND `tipo` = 'central'
|
| 0.0001 |
SELECT *
FROM (`banner`)
WHERE `activo` = 'S'
AND `tipo` = 'BLD'
|
| 0.0001 |
SELECT *
FROM (`banner`)
WHERE `activo` = 'S'
AND `tipo` = 'BLI'
|
| 0.0001 |
SELECT *
FROM (`banner`)
WHERE `activo` = 'S'
AND `tipo` = 'H'
|
| 0.0110 |
SELECT COUNT(DISTINCT idproducto) AS numrows
FROM (`producto` prod)
JOIN `producto_categoria` prodc ON `prodc`.`producto_idproducto` = `prod`.`idproducto`
JOIN `categoria` cat ON `cat`.`idcategoria` = `prodc`.`categoria_idcategoria`
WHERE `prod`.`activo` = 'S'
AND (`prod`.`nombre` LIKE '%rosas%' OR `prod`.`detalle` LIKE '%rosas%' OR `prod`.`descripcion` LIKE '%rosas%' OR `cat`.`nombre` LIKE '%rosas%')
|
| 0.0127 |
SELECT `prod`.`idproducto` AS idproducto, `prod`.`nombre` AS nombre, `prod`.`detalle` AS detalle, `prod`.`precio` AS precio, `prod`.`tipo` AS tipo, `prod`.`oferta` AS oferta, `prod`.`descripcion` AS descripcion, `prod`.`etiqueta` AS etiqueta, `prod`.`destacado` AS destacado, `prod`.`stock` AS stock, `prod`.`novedad` AS novedad, `prod`.`descuento` AS descuento
FROM (`producto` prod)
JOIN `producto_categoria` prodc ON `prodc`.`producto_idproducto` = `prod`.`idproducto`
JOIN `categoria` cat ON `cat`.`idcategoria` = `prodc`.`categoria_idcategoria`
WHERE `prod`.`activo` = 'S'
AND (`prod`.`nombre` LIKE '%rosas%' OR `prod`.`detalle` LIKE '%rosas%' OR `prod`.`descripcion` LIKE '%rosas%' OR `cat`.`nombre` LIKE '%rosas%')
GROUP BY `prod`.`idproducto`
ORDER BY `prod`.`precio` asc
LIMIT 12
|
