Toldos

Messages3 Timeline Exceptions Views12 Route Queries12 Models24 Mails Gate Session Request

7.4.33423ms6MBGET categoria/{clasificacion?}/{sort?}

infolog[15:47:27] LOG.info: 1. Procesamiento inicial: 0,011911869049072 segundos
infolog[15:47:27] LOG.info: Listado Productos: 0,037986993789673 segundos
infolog[15:47:27] LOG.info: retorno: 0,073368072509766 segundos

Booting (151ms)
Application (271ms)
1 x Application (64.02%)
271.03ms
1 x Booting (35.66%)
150.97ms

12 templates were rendered

categoria (resources/views/categoria.blade.php)21blade


item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4

Params
0	`item`
1	`menuSubcategorias`
2	`nombre_categoria`
3	`preguntas`
4	`listado_productos`
5	`nombre_filtros`
6	`filtro_modelo`
7	`filtro_material`
8	`filtro_tipo1`
9	`filtro_tipo2`
10	`filtro_cuarto`
11	`pagelinks`
12	`paginacion`
13	`url_categorias`
14	`url_volver`
15	`huincha_promo`
16	`clasificaciones`
17	`marcas`
18	`modelos`
19	`annos`
20	`banners4`

layouts.filtros_menu (resources/views/layouts/filtros_menu.blade.php)24blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`

layouts.filtros (resources/views/layouts/filtros.blade.php)28blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`

layouts.grilla_productos (resources/views/layouts/grilla_productos.blade.php)28blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria

pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)8blade
Params
0
paginator
1
elements
2
huincha_promo
3
clasificaciones
4
marcas
5
modelos
6
annos
7
banners4
pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)8blade
Params
0
paginator
1
elements
2
huincha_promo
3
clasificaciones
4
marcas
5
modelos
6
annos
7
banners4

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`

Params
0	`paginator`
1	`elements`
2	`huincha_promo`
3	`clasificaciones`
4	`marcas`
5	`modelos`
6	`annos`
7	`banners4`

Params
0	`paginator`
1	`elements`
2	`huincha_promo`
3	`clasificaciones`
4	`marcas`
5	`modelos`
6	`annos`
7	`banners4`

layouts.irarriba (resources/views/layouts/irarriba.blade.php)30blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`

layouts.filtros_responsive (resources/views/layouts/filtros_responsive.blade.php)30blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`

layouts.app (resources/views/layouts/app.blade.php)30blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`

layouts.styles (resources/views/layouts/styles.blade.php)30blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`

layouts.scripts (resources/views/layouts/scripts.blade.php)30blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`

partials.categoriadinamica (resources/views/partials/categoriadinamica.blade.php)32blade


__env
app
errors
item
menuSubcategorias
nombre_categoria
preguntas
listado_productos
nombre_filtros
filtro_modelo
filtro_material
filtro_tipo1
filtro_tipo2
filtro_cuarto
pagelinks
paginacion
url_categorias
url_volver
huincha_promo
clasificaciones
marcas
modelos
annos
banners4
__currentLoopData
dato
loop
subcategoria
i
act
menuCategoriaDinamicas
menuTodosProductos

Params
0	`__env`
1	`app`
2	`errors`
3	`item`
4	`menuSubcategorias`
5	`nombre_categoria`
6	`preguntas`
7	`listado_productos`
8	`nombre_filtros`
9	`filtro_modelo`
10	`filtro_material`
11	`filtro_tipo1`
12	`filtro_tipo2`
13	`filtro_cuarto`
14	`pagelinks`
15	`paginacion`
16	`url_categorias`
17	`url_volver`
18	`huincha_promo`
19	`clasificaciones`
20	`marcas`
21	`modelos`
22	`annos`
23	`banners4`
24	`__currentLoopData`
25	`dato`
26	`loop`
27	`subcategoria`
28	`i`
29	`act`
30	`menuCategoriaDinamicas`
31	`menuTodosProductos`

uri: GET categoria/{clasificacion?}/{sort?}
middleware: web
controller: App\Http\Controllers\BusquedaController@index
namespace
prefix
where
as: categoria
file: app/Http/Controllers/BusquedaController.php:20-1051

12 statements were executed116ms

(select `id`, `nombre`, `link`, `imagen`, `meta_titulo`, `meta_descripcion`, `keywords`, 1 as nivel, `slug`, `brief` from `primeracategorias` where `slug` = 'toldos') union (select `id`, `nombre`, `link`, `imagen`, `meta_titulo`, `meta_descripcion`, `keywords`, 2 as nivel, `slug`, `brief` from `segundacategorias` where `slug` = 'toldos') order by `nivel` asc limit 1

10,75ms/app/Http/Controllers/BusquedaController.php:161dev_bd

Metadata
Bindings	0. toldos 1. toldos
Backtrace	15. /app/Http/Controllers/BusquedaController.php:161 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select distinct `pri`.`id` as `pri_id`, `pri`.`nombre` as `pri_nombre`, `seg`.`id` as `seg_id`, `seg`.`nombre` as `seg_nombre`, `seg`.`link` as `seg_link`, `seg`.`slug` as `seg_slug`, `seg`.`brief` as `seg_brief`, `p`.`id` as `producto_id`, `p`.`nombre_modelo` as `producto_modelo`, `p`.`material` as `producto_material`, `p`.`tipo1` as `producto_tipo1`, `p`.`tipo2` as `producto_tipo2`, `c2`.`nombre` as `cuarto_filtro` from `producto_niveles` as `pn` left join `productos` as `p` on `pn`.`producto_id` = `p`.`id` left join `primeracategorias` as `pri` on `pn`.`primeracategoria_id` = `pri`.`id` and `pri`.`estado` = 1 left join `segundacategorias` as `seg` on `pn`.`segundacategoria_id` = `seg`.`id` and `seg`.`estado` = 1 left join `producto_caracteristicas` as `pc` on `pn`.`producto_id` = `pc`.`producto_id` left join `marcas` as `m` on `pc`.`marca_id` = `m`.`id` and `m`.`estado` = 1 left join `modelos` as `m2` on `pc`.`modelo_id` = `m2`.`id` and `m2`.`estado` = 1 left join `carrocerias` as `c` on `pc`.`carroceria_id` = `c`.`id` and `c`.`estado` = 1 left join `cuartofiltros` as `c2` on `pc`.`cuartofiltro_id` = `c2`.`id` where `p`.`estado` = 1 and `p`.`habilitado` = 1 and `p`.`precio_sap` > 0 and (pn.segundacategoria_id = '28525')

7,83ms/app/Http/Controllers/BusquedaController.php:513dev_bd

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1 4. 1 5. 1 6. 1 7. 0
Backtrace	12. /app/Http/Controllers/BusquedaController.php:513 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

SELECT @@SESSION.sql_mode

1,01ms/app/Http/Controllers/BusquedaController.php:813dev_bd

Metadata
Backtrace	10. /app/Http/Controllers/BusquedaController.php:813 11. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 12. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 13. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

SET SESSION sql_mode=''

560μs/app/Http/Controllers/BusquedaController.php:814dev_bd

Metadata
Backtrace	10. /app/Http/Controllers/BusquedaController.php:814 11. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 12. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 13. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from (SELECT p.id, p.nombre, p.meta_titulo, p.imagen, p.imagen_alt, p.imagen_title, p.link, p.fabrica, p.pais_sap as origen,
(p.stock_sap + p.stock_verde + p.stock_opcional) AS stock_sap, p.stock_sap AS stock_fisico, p.stock_verde, p.stock_opcional,
p.precio_sap, p.precio_liquidacion,
p.liquidacion, p.proximamente, p.cant_calificacion, p.prom_calificacion, 0 as agrupacion, p.nombre_modelo,
CASE WHEN (p.stock_sap + p.stock_verde + p.stock_opcional) > 0 THEN 1 ELSE 0 END AS tiene_stock,
(SELECT MIN(seg2.orden)
FROM producto_niveles pn2
LEFT JOIN segundacategorias seg2 ON pn2.segundacategoria_id = seg2.id AND seg2.estado = 1
WHERE pn2.producto_id = p.id) AS seg_orden,
IF(COUNT(DISTINCT pc.marca_id) > 1, 1, 0) AS especifico,
p.visitas,
'simple' as tipo
from producto_niveles as pn
left join productos p on pn.producto_id = p.id
left join primeracategorias pri on pn.primeracategoria_id = pri.id and pri.estado = 1
left join segundacategorias seg on pn.segundacategoria_id = seg.id and seg.estado = 1
left join producto_caracteristicas as pc on pn.producto_id = pc.producto_id
left join marcas m on pc.marca_id = m.id and m.estado = 1
left join modelos m2 on pc.modelo_id = m2.id and m2.estado = 1
left join carrocerias c on pc.carroceria_id = c.id and c.estado = 1
left join cuartofiltros c2 on pc.cuartofiltro_id = c2.id
where pri.estado = 1 and p.estado = 1 and p.habilitado = 1 and p.precio_sap > 0 and p.grupo_modelo = 0  AND (pn.segundacategoria_id = '28525')
GROUP BY p.id, p.nombre, p.meta_titulo, p.imagen, p.imagen_alt, p.imagen_title, p.link, p.fabrica, p.pais_sap,
p.stock_sap, p.stock_verde, p.stock_opcional, p.precio_sap, p.precio_liquidacion, p.liquidacion, p.proximamente,
p.cant_calificacion, p.prom_calificacion, p.nombre_modelo, p.visitas, tipo, seg_orden, stock_sap, stock_fisico, tiene_stock, agrupacion
union all
select mc.id, mc.nombre, mc.meta_titulo, mc.imagen, mc.imagen_alt, mc.imagen_title, mc.link, mc.fabrica, mc.pais_sap as origen,
(mc.stock_sap + mc.stock_verde + mc.stock_opcional) AS stock_sap, mc.stock_sap AS stock_fisico, mc.stock_verde, mc.stock_opcional,
mc.precio_sap, 0 as precio_liquidacion,
0 as liquidacion, 0 as proximamente, mc.cant_calificacion, mc.prom_calificacion, 1 as agrupacion, '' as nombre_modelo,
CASE WHEN (mc.stock_sap + mc.stock_verde + mc.stock_opcional) > 0 THEN 1 ELSE 0 END AS tiene_stock,
(SELECT MIN(seg2.orden)
FROM producto_niveles pn2
LEFT JOIN segundacategorias seg2 ON pn2.segundacategoria_id = seg2.id AND seg2.estado = 1
WHERE pn2.producto_id = p.id) AS seg_orden,
IF(COUNT(DISTINCT pc.marca_id) > 1, 1, 0) AS especifico,
sum(p.visitas) as visitas,
'grupo' as tipo
from producto_niveles as pn
left join productos p on pn.producto_id = p.id
inner join modelocategorias mc on p.grupo_modelo = mc.id
left join primeracategorias pri on pn.primeracategoria_id = pri.id and pri.estado = 1
left join segundacategorias seg on pn.segundacategoria_id = seg.id and seg.estado = 1
left join producto_caracteristicas as pc on pn.producto_id = pc.producto_id
left join marcas m on pc.marca_id = m.id and m.estado = 1
left join modelos m2 on pc.modelo_id = m2.id and m2.estado = 1
left join carrocerias c on pc.carroceria_id = c.id and c.estado = 1
left join cuartofiltros c2 on pc.cuartofiltro_id = c2.id
where pri.estado = 1 and p.estado = 1 and p.habilitado = 1 and p.precio_sap > 0 and p.grupo_modelo != 0 and mc.link is not null  AND (pn.segundacategoria_id = '28525')
GROUP BY mc.id, mc.nombre, mc.meta_titulo, mc.imagen, mc.imagen_alt, mc.imagen_title, mc.link, mc.fabrica, mc.pais_sap,
mc.stock_sap, mc.stock_verde, mc.stock_opcional, mc.precio_sap, mc.cant_calificacion, mc.prom_calificacion,
liquidacion, proximamente, nombre_modelo, tipo, seg_orden, stock_sap, stock_fisico, tiene_stock, agrupacion
) as productos_tabla

11,98ms/app/Http/Controllers/BusquedaController.php:836dev_bd

Metadata
Backtrace	15. /app/Http/Controllers/BusquedaController.php:836 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from (SELECT p.id, p.nombre, p.meta_titulo, p.imagen, p.imagen_alt, p.imagen_title, p.link, p.fabrica, p.pais_sap as origen,
(p.stock_sap + p.stock_verde + p.stock_opcional) AS stock_sap, p.stock_sap AS stock_fisico, p.stock_verde, p.stock_opcional,
p.precio_sap, p.precio_liquidacion,
p.liquidacion, p.proximamente, p.cant_calificacion, p.prom_calificacion, 0 as agrupacion, p.nombre_modelo,
CASE WHEN (p.stock_sap + p.stock_verde + p.stock_opcional) > 0 THEN 1 ELSE 0 END AS tiene_stock,
(SELECT MIN(seg2.orden)
FROM producto_niveles pn2
LEFT JOIN segundacategorias seg2 ON pn2.segundacategoria_id = seg2.id AND seg2.estado = 1
WHERE pn2.producto_id = p.id) AS seg_orden,
IF(COUNT(DISTINCT pc.marca_id) > 1, 1, 0) AS especifico,
p.visitas,
'simple' as tipo
from producto_niveles as pn
left join productos p on pn.producto_id = p.id
left join primeracategorias pri on pn.primeracategoria_id = pri.id and pri.estado = 1
left join segundacategorias seg on pn.segundacategoria_id = seg.id and seg.estado = 1
left join producto_caracteristicas as pc on pn.producto_id = pc.producto_id
left join marcas m on pc.marca_id = m.id and m.estado = 1
left join modelos m2 on pc.modelo_id = m2.id and m2.estado = 1
left join carrocerias c on pc.carroceria_id = c.id and c.estado = 1
left join cuartofiltros c2 on pc.cuartofiltro_id = c2.id
where pri.estado = 1 and p.estado = 1 and p.habilitado = 1 and p.precio_sap > 0 and p.grupo_modelo = 0  AND (pn.segundacategoria_id = '28525')
GROUP BY p.id, p.nombre, p.meta_titulo, p.imagen, p.imagen_alt, p.imagen_title, p.link, p.fabrica, p.pais_sap,
p.stock_sap, p.stock_verde, p.stock_opcional, p.precio_sap, p.precio_liquidacion, p.liquidacion, p.proximamente,
p.cant_calificacion, p.prom_calificacion, p.nombre_modelo, p.visitas, tipo, seg_orden, stock_sap, stock_fisico, tiene_stock, agrupacion
union all
select mc.id, mc.nombre, mc.meta_titulo, mc.imagen, mc.imagen_alt, mc.imagen_title, mc.link, mc.fabrica, mc.pais_sap as origen,
(mc.stock_sap + mc.stock_verde + mc.stock_opcional) AS stock_sap, mc.stock_sap AS stock_fisico, mc.stock_verde, mc.stock_opcional,
mc.precio_sap, 0 as precio_liquidacion,
0 as liquidacion, 0 as proximamente, mc.cant_calificacion, mc.prom_calificacion, 1 as agrupacion, '' as nombre_modelo,
CASE WHEN (mc.stock_sap + mc.stock_verde + mc.stock_opcional) > 0 THEN 1 ELSE 0 END AS tiene_stock,
(SELECT MIN(seg2.orden)
FROM producto_niveles pn2
LEFT JOIN segundacategorias seg2 ON pn2.segundacategoria_id = seg2.id AND seg2.estado = 1
WHERE pn2.producto_id = p.id) AS seg_orden,
IF(COUNT(DISTINCT pc.marca_id) > 1, 1, 0) AS especifico,
sum(p.visitas) as visitas,
'grupo' as tipo
from producto_niveles as pn
left join productos p on pn.producto_id = p.id
inner join modelocategorias mc on p.grupo_modelo = mc.id
left join primeracategorias pri on pn.primeracategoria_id = pri.id and pri.estado = 1
left join segundacategorias seg on pn.segundacategoria_id = seg.id and seg.estado = 1
left join producto_caracteristicas as pc on pn.producto_id = pc.producto_id
left join marcas m on pc.marca_id = m.id and m.estado = 1
left join modelos m2 on pc.modelo_id = m2.id and m2.estado = 1
left join carrocerias c on pc.carroceria_id = c.id and c.estado = 1
left join cuartofiltros c2 on pc.cuartofiltro_id = c2.id
where pri.estado = 1 and p.estado = 1 and p.habilitado = 1 and p.precio_sap > 0 and p.grupo_modelo != 0 and mc.link is not null  AND (pn.segundacategoria_id = '28525')
GROUP BY mc.id, mc.nombre, mc.meta_titulo, mc.imagen, mc.imagen_alt, mc.imagen_title, mc.link, mc.fabrica, mc.pais_sap,
mc.stock_sap, mc.stock_verde, mc.stock_opcional, mc.precio_sap, mc.cant_calificacion, mc.prom_calificacion,
liquidacion, proximamente, nombre_modelo, tipo, seg_orden, stock_sap, stock_fisico, tiene_stock, agrupacion
) as productos_tabla order by tiene_stock DESC, especifico DESC, seg_orden ASC, visitas DESC limit 24 offset 24

11,46ms/app/Http/Controllers/BusquedaController.php:836dev_bd

Metadata
Backtrace	13. /app/Http/Controllers/BusquedaController.php:836 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

SET SESSION sql_mode='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

620μs/app/Http/Controllers/BusquedaController.php:845dev_bd

Metadata
Backtrace	10. /app/Http/Controllers/BusquedaController.php:845 11. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 12. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 13. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 14. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

(select `pp`.`pregunta`, `pp`.`respuesta` from `primeracategoria_preguntas` as `pp` where `pp`.`primeracategoria_id` = 28525) union (select `sp`.`pregunta`, `sp`.`respuesta` from `segundacategoria_preguntas` as `sp` where `sp`.`segundacategoria_id` = 28525)

3,86ms/app/Http/Controllers/BusquedaController.php:859dev_bd

Metadata
Bindings	0. 28525 1. 28525
Backtrace	12. /app/Http/Controllers/BusquedaController.php:859 13. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `vista_relacion_categorias` where `segundacategoria_id` = 28525 limit 1

64,06ms/app/Http/Controllers/BusquedaController.php:916dev_bd

Metadata
Bindings	0. 28525
Backtrace	13. /app/Http/Controllers/BusquedaController.php:916 14. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `primeracategorias` where `primeracategorias`.`id` = '63413' limit 1

1,23ms/app/Http/Controllers/BusquedaController.php:923dev_bd

Metadata
Bindings	0. 63413
Backtrace	19. /app/Http/Controllers/BusquedaController.php:923 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select distinct `pc`.`id`, `pc`.`nombre`, `pc`.`slug`, `pc`.`link`, `pc`.`imagen` from `primeracategorias` as `pc` inner join `producto_niveles` as `pn` on `pc`.`id` = `pn`.`primeracategoria_id` inner join `segundacategorias` as `sc` on `pn`.`segundacategoria_id` = `sc`.`id` where (`pc`.`estado` = 1 and `pc`.`visible` = 1 and `pc`.`grupo_id` = 1 and `sc`.`estado` = 1) order by `pc`.`orden` asc

1,18ms/app/Http/ViewComposers/CategoriaDinamicaComposer.php:32dev_bd

Metadata
Bindings	0. 1 1. 1 2. 1 3. 1
Backtrace	12. /app/Http/ViewComposers/CategoriaDinamicaComposer.php:32 13. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 17. /vendor/laravel/framework/src/Illuminate/View/View.php:120 18. /vendor/laravel/framework/src/Illuminate/View/View.php:91

select distinct CONCAT(primeracategorias.id,'/',primeracategorias.nombre,'/',primeracategorias.slug) AS primera, `primeracategorias`.`id` as `pri_id`, `primeracategorias`.`nombre` as `primeracategoria`, `primeracategorias`.`link` as `pri_link`, `segundacategorias`.`id` as `seg_id`, `segundacategorias`.`nombre` as `segundacategoria`, `segundacategorias`.`link` as `seg_link` from `producto_niveles` inner join `primeracategorias` on `producto_niveles`.`primeracategoria_id` = `primeracategorias`.`id` left join `segundacategorias` on `producto_niveles`.`segundacategoria_id` = `segundacategorias`.`id` where (`primeracategorias`.`estado` = 1 and `primeracategorias`.`visible` = 1 and `grupo_id` = 3) and `segundacategorias`.`estado` = 1 order by `primeracategorias`.`orden` asc, `segundacategorias`.`orden` asc

1,69ms/app/Http/ViewComposers/CategoriaDinamicaComposer.php:51dev_bd

Metadata
Bindings	0. 1 1. 1 2. 3 3. 1
Backtrace	14. /app/Http/ViewComposers/CategoriaDinamicaComposer.php:51 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:124 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91

App\Models\ProductoNivel: 22
App\Models\Primeracategoria: 2

_token: Gt1GRf44qnNGyIa5xVHAKGmFhzPKffWhXtNCBMJ4
ultima_categoria_visitada: array:4 [ "id" => 28525 "nombre" => "Toldos" "slug" => "toldos" "nivel" => 2 ]
_previous: array:1 [ "url" => "https://dev.gimport.cl/categoria/toldos?page=2" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/categoria/toldos

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_request

  0 of 0   
array:1 [▼
  "page" => "2"
]

request_headers

  0 of 0   
array:16 [▼
  "x-https" => array:1 [▶
    0 => "1"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "dev.gimport.cl"
  ]
]

request_server

  0 of 0   
array:58 [▼
  "USER" => "dev"
  "HOME" => "/home/dev"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/categoria/toldos?page=2"
  "QUERY_STRING" => "page=2"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "page=2"
  "REDIRECT_URL" => "/categoria/toldos"
  "REMOTE_PORT" => "36812"
  "SCRIPT_FILENAME" => "/home/dev/public_html/index.php"
  "SERVER_ADMIN" => "webmaster@dev.gimport.cl"
  "CONTEXT_DOCUMENT_ROOT" => "/home/dev/public_html"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/dev/public_html"
  "REMOTE_ADDR" => "3.144.39.8"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "200.73.113.212"
  "SERVER_NAME" => "dev.gimport.cl"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
  "HTTP_X_HTTPS" => "1"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "dev.gimport.cl"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "dev.gimport.cl"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://dev.gimport.cl/categoria/toldos"
  "SCRIPT_URL" => "/categoria/toldos"
  "UNIQUE_ID" => "aBpnTqo5Z0P4TMvZwsMQSwAAANE"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "dev.gimport.cl"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://dev.gimport.cl/categoria/toldos"
  "REDIRECT_SCRIPT_URL" => "/categoria/toldos"
  "REDIRECT_UNIQUE_ID" => "aBpnTqo5Z0P4TMvZwsMQSwAAANE"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746560846,9373
  "REQUEST_TIME" => 1746560846
  "argv" => array:1 [▶
    0 => "page=2"
  ]
  "argc" => 1
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 06 May 2025 19:47:27 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImFFODFOMnVVaXhVMVJ4dlRWSHUxZHc9PSIsInZhbHVlIjoiYWxQSlAzL3E3a3pLdUNZbk55aUwyODN2bGp4OXVsMXYrRmZvTjczZzludEE2ekZ2aXNrbjQrMkEyVGs1UzVpSmtGN0V0Z0VhL0VHd3JYWHp3TFl1aVZDdWxVV3BZc0tFMEt6b0tBWU1CVXRkNlZXQVV4VmRUSE53bDdKaGpMdlYiLCJtYWMiOiIxOGJmMTgwZjUzNmQ0NDQ5MDgzZWEwNDIyOWI0MTdhY2YzYjRiM2RkM2IwZDVlM2Y4ZjU3MjM5NTM0ZjgzZDVjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 21:47:27 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImFFODFOMnVVaXhVMVJ4dlRWSHUxZHc9PSIsInZhbHVlIjoiYWxQSlAzL3E3a3pLdUNZbk55aUwyODN2bGp4OXVsMXYrRmZvTjczZzludEE2ekZ2aXNrbjQrMkEyVGs1UzVpSmtGN0V0Z ▶"
    1 => "gimport_session=eyJpdiI6InFrVHBaWWZGRDZJMDFiUXhoTjR2WkE9PSIsInZhbHVlIjoiajhXTkE0Zk4rR1FGMVpGNmNjN2FPbnByREdVd1RFMnB0MmlrRjJROWNGd3d0NEsyVnM2SExYZHNhMkFLYnlQcXBLUzgzeTRpdHE1YklSdEU4SkFQYjBMQUljSzBUQzNEa0FySEdUMWhCSXBnM1lxZHNCeE9WcjZoZVdrWHZFOVMiLCJtYWMiOiIzMzVjMzJjMjhjN2YwZDZmNDQ0NTljYjdkZGU3ZTg2Y2MzODAyYjg1Mzk2NDIwYWU0Y2IyNjNjN2FiNjUwOGEyIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 21:47:27 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀gimport_session=eyJpdiI6InFrVHBaWWZGRDZJMDFiUXhoTjR2WkE9PSIsInZhbHVlIjoiajhXTkE0Zk4rR1FGMVpGNmNjN2FPbnByREdVd1RFMnB0MmlrRjJROWNGd3d0NEsyVnM2SExYZHNhMkFLYnlQcXBL ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImFFODFOMnVVaXhVMVJ4dlRWSHUxZHc9PSIsInZhbHVlIjoiYWxQSlAzL3E3a3pLdUNZbk55aUwyODN2bGp4OXVsMXYrRmZvTjczZzludEE2ekZ2aXNrbjQrMkEyVGs1UzVpSmtGN0V0Z0VhL0VHd3JYWHp3TFl1aVZDdWxVV3BZc0tFMEt6b0tBWU1CVXRkNlZXQVV4VmRUSE53bDdKaGpMdlYiLCJtYWMiOiIxOGJmMTgwZjUzNmQ0NDQ5MDgzZWEwNDIyOWI0MTdhY2YzYjRiM2RkM2IwZDVlM2Y4ZjU3MjM5NTM0ZjgzZDVjIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 21:47:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImFFODFOMnVVaXhVMVJ4dlRWSHUxZHc9PSIsInZhbHVlIjoiYWxQSlAzL3E3a3pLdUNZbk55aUwyODN2bGp4OXVsMXYrRmZvTjczZzludEE2ekZ2aXNrbjQrMkEyVGs1UzVpSmtGN0V0Z ▶"
    1 => "gimport_session=eyJpdiI6InFrVHBaWWZGRDZJMDFiUXhoTjR2WkE9PSIsInZhbHVlIjoiajhXTkE0Zk4rR1FGMVpGNmNjN2FPbnByREdVd1RFMnB0MmlrRjJROWNGd3d0NEsyVnM2SExYZHNhMkFLYnlQcXBLUzgzeTRpdHE1YklSdEU4SkFQYjBMQUljSzBUQzNEa0FySEdUMWhCSXBnM1lxZHNCeE9WcjZoZVdrWHZFOVMiLCJtYWMiOiIzMzVjMzJjMjhjN2YwZDZmNDQ0NTljYjdkZGU3ZTg2Y2MzODAyYjg1Mzk2NDIwYWU0Y2IyNjNjN2FiNjUwOGEyIiwidGFnIjoiIn0%3D; expires=Tue, 06-May-2025 21:47:27 GMT; path=/; httponly ◀gimport_session=eyJpdiI6InFrVHBaWWZGRDZJMDFiUXhoTjR2WkE9PSIsInZhbHVlIjoiajhXTkE0Zk4rR1FGMVpGNmNjN2FPbnByREdVd1RFMnB0MmlrRjJROWNGd3d0NEsyVnM2SExYZHNhMkFLYnlQcXBL ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "Gt1GRf44qnNGyIa5xVHAKGmFhzPKffWhXtNCBMJ4"
  "ultima_categoria_visitada" => array:4 [▶
    "id" => 28525
    "nombre" => "Toldos"
    "slug" => "toldos"
    "nivel" => 2
  ]
  "_previous" => array:1 [▶
    "url" => "https://dev.gimport.cl/categoria/toldos?page=2"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Toldos

Toldos

SOPORTE DE TOLDO PARA AUTO INSTALACION EN PARED

TOLDO LATERAL PARA AUTO DE 2.0 METROS X 2.5 METROS

Toldos

1 x Application (64.02%)	271.03ms
1 x Booting (35.66%)	150.97ms