0.0010 |
SELECT * FROM (`categoria`) WHERE `activo` = 'S' AND `nombre` != '' ORDER BY `destacado` DESC, `nombre` ASC
|
0.0017 |
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.0102 |
SELECT * FROM (`producto`) WHERE `activo` = 'S' AND `oferta` = 'O' AND `oferta` != '' ORDER BY RAND()
|
0.0050 |
SELECT * FROM (`producto`) WHERE `activo` = 'S' AND `novedad` != '' AND `novedad` = 'N'
|
0.0533 |
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.0059 |
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.0004 |
SELECT * FROM (`banner`) WHERE `activo` = 'S' AND `tipo` = 'central'
|
0.0003 |
SELECT * FROM (`banner`) WHERE `activo` = 'S' AND `tipo` = 'BLD'
|
0.0003 |
SELECT * FROM (`banner`) WHERE `activo` = 'S' AND `tipo` = 'BLI'
|
0.0003 |
SELECT * FROM (`banner`) WHERE `activo` = 'S' AND `tipo` = 'H'
|
0.0178 |
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.0164 |
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
|