Suburbia

Pantalones y Jeans / Weekend Premium

Electrónica

Electrodomésticos

Videojuegos

Mujer

Request history8.3.144.31s2MBGET {countryCode}/{catalogSlug}/c/{categorySlug}/b/{brandSlug}

Booting (9.04ms)time
Application (4.31s)time
1 x Application (99.84%)
4.31s
1 x Booting (0.21%)
9.04ms

132 templates were rendered

1x livewire.web.show-catalogshow-catalog.blade.php#?blade
3x components.taxonomy-treetaxonomy-tree.blade.php#?blade
96x components.linklink.blade.php#?blade
2x livewire::simple-tailwindsimple-tailwind.blade.php#?blade
1x components.product-gridproduct-grid.blade.php#?blade
5x components.product-cardproduct-card.blade.php#?blade
5x components.product-thumbproduct-thumb.blade.php#?blade
1x __components::4943bc92ebba41e8b0e508149542e0ad4943bc92ebba41e8b0e508149542e0ad.blade.php#?blade
1x layouts.appapp.blade.php#?blade
1x components.bannerbanner.blade.php#?blade
1x components.login-modallogin-modal.blade.php#?blade
1x components.socialstreamsocialstream.blade.php#?blade
1x components.input-errorinput-error.blade.php#?blade
1x components.socialstream-icons.provider-iconprovider-icon.blade.php#?blade
1x components.socialstream-icons.googlegoogle.blade.php#?blade
1x components.link-buttonlink-button.blade.php#?blade
1x components.modalmodal.blade.php#?blade
1x navigation-menunavigation-menu.blade.php#?blade
1x components.application-logoapplication-logo.blade.php#?blade
2x components.inputinput.blade.php#?blade
1x components.catalog-menucatalog-menu.blade.php#?blade
4x components.responsive-nav-linkresponsive-nav-link.blade.php#?blade

uri: GET {countryCode}/{catalogSlug}/c/{categorySlug}/b/{brandSlug}
middleware: web, App\Http\Middleware\StoreIntendedUrl
uses: App\Livewire\Web\ShowCatalog@__invoke
controller: App\Livewire\Web\ShowCatalog@render
namespace
prefix: /{countryCode}
where
as: catalogs.category_brand
file: app/Livewire/Web/ShowCatalog.php:19-82

10 statements were executed (2 duplicates)Show only duplicates4.06s

AppServiceProvider.php#69descuentoConnection Established

Backtrace

app/Providers/AppServiceProvider.php:69
app/Providers/AppServiceProvider.php:53
vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
vendor/laravel/framework/src/Illuminate/Container/Util.php:43
vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95

ShowCatalog.php#39descuento6.03msselect * from `stores` where `country` = 'mx' and `slug` = 'suburbia' limit 1

Bindings	0: mx 1: suburbia
Backtrace	app/Livewire/Web/ShowCatalog.php:39 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 vendor/laravel/framework/src/Illuminate/Container/Util.php:43 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

Product.php#136descuento3.8msselect `id` from `categories` where `slug` = 'pantalones-y-jeans'

Bindings	0: pantalones-y-jeans
Backtrace	app/Models/Product.php:136 app/Livewire/Web/ShowCatalog.php:59 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 vendor/laravel/framework/src/Illuminate/Container/Util.php:43 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95

ShowCatalog.php#60descuento5.02msselect * from `categories` where `slug` = 'pantalones-y-jeans' limit 1

Bindings	0: pantalones-y-jeans
Backtrace	app/Livewire/Web/ShowCatalog.php:60 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 vendor/laravel/framework/src/Illuminate/Container/Util.php:43 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

ShowCatalog.php#69descuento4.89msselect * from `products` where `brand_slug` = 'weekend-premium' limit 1

Bindings	0: weekend-premium
Backtrace	app/Livewire/Web/ShowCatalog.php:69 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 vendor/laravel/framework/src/Illuminate/Container/Util.php:43 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

ShowCatalog.php#80descuento3.99s

select * from products FORCE INDEX (products_discount_index) inner join (select distinct `product_id` from `category_product` force index (category_product_category_id_product_id_index) where `category_id` in (4954, 4955, 9215, 9867, 9903, 10465, 10481, 13977)) as `cp` on `products`.`id` = `cp`.`product_id` where exists (select * from `stores` where `products`.`store_id` = `stores`.`id` and `stores`.`country` = 'mx') and `is_active` = 1 and `priced_at` >= '2025-03-09 14:06:01' and `store_id` = 4 and `brand_slug` = 'weekend-premium' order by `discount` desc, `priced_at` desc limit 25 offset 0

Bindings	0: 4954 1: 4955 2: 9215 3: 9867 4: 9903 5: 10465 6: 10481 7: 13977 8: mx 9: 1 10: 2025-03-09 14:06:01 11: 4 12: weekend-premium
Backtrace	app/Livewire/Web/ShowCatalog.php:80 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36 vendor/laravel/framework/src/Illuminate/Container/Util.php:43 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95 vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

ShowCatalog.php#80descuento3.82msselect * from `stores` where `stores`.`id` in (4)

Backtrace

app/Livewire/Web/ShowCatalog.php:80
vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:36
vendor/laravel/framework/src/Illuminate/Container/Util.php:43
vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:95
vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php:35

TaxonomyTree.php#21descuento11.28ms

WITH RECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULL AS CHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id IS NULL AND store_id = 4
UNION ALL
SELECT t.slug, t.title, CAST(cte.slug AS CHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNER JOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug AND store_id = 4 LIMIT 1
)
)
SELECT DISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDER BY `order`

Backtrace

app/View/Components/TaxonomyTree.php:21
vendor/laravel/framework/src/Illuminate/View/Component.php:143
view::livewire.web.show-catalog:25
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:38
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

CatalogMenu.php#21descuento4.36msselect * from `stores` where `country` = 'mx' order by `priority` asc limit 5

Bindings	0: mx
Backtrace	app/View/Components/CatalogMenu.php:21 vendor/laravel/framework/src/Illuminate/View/Component.php:110 view::navigation-menu:384 vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:38 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

TaxonomyTree.php#21descuento14.22ms

WITH RECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULL AS CHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id IS NULL
UNION ALL
SELECT t.slug, t.title, CAST(cte.slug AS CHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNER JOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug  LIMIT 1
)
)
SELECT DISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDER BY `order`

Backtrace

app/View/Components/TaxonomyTree.php:21
vendor/laravel/framework/src/Illuminate/View/Component.php:143
view::components.catalog-menu:31
vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:38
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75

TaxonomyTree.php#21descuento9.72ms

WITH RECURSIVE taxonomy_cte AS (
SELECT slug, title, CAST(NULL AS CHAR(255)) AS parent_slug, `order`
FROM taxonomies
WHERE parent_id IS NULL
UNION ALL
SELECT t.slug, t.title, CAST(cte.slug AS CHAR(255)) AS parent_slug, t.`order`
FROM taxonomies t
INNER JOIN taxonomy_cte cte ON t.parent_id = (
SELECT id FROM taxonomies WHERE slug = cte.slug  LIMIT 1
)
)
SELECT DISTINCT slug, title, parent_slug, `order`
FROM taxonomy_cte
ORDER BY `order`

Backtrace

app/View/Components/TaxonomyTree.php:21
vendor/laravel/framework/src/Illuminate/View/Component.php:143
view::layouts.app:107
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

App\Models\Category: 9Category.php#?
App\Models\Store: 7Store.php#?
App\Models\Product: 6Product.php#?

web.show-catalog #uVnbIKEtIvMIVzNxquyD: array:4 [ "data" => array:1 [ "paginators" => array:1 [ "page" => 1 ] ] "name" =...
navigation-menu #38wrDwQqy0Ziu9772YeB: array:4 [ "data" => [] "name" => "navigation-menu" "component" => "Laravel\Jetstream\Http\Live...

app: array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/suburbia/c/pantalones-y...
_token: 4Z7sYgs0OSWVu2qddEiIr7Ss95lIGT505htZUqk1
_previous: array:1 [ "url" => "https://tienedescuento.com/mx/suburbia/c/pantalones-y-jeans/b/weekend-premium"...
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/mx/suburbia/c/pantalones-y-jeans/b/weekend-premium

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▼
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "tienedescuento.com"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "cache-control" => array:1 [▶
    0 => "max-age=0, must-revalidate, no-cache, no-store, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 11 Mar 2025 20:06:05 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "Fri, 01 Jan 1990 00:00:00 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImRxc2htd1NPMEEyN3pLaG90MEF2enc9PSIsInZhbHVlIjoiYTE0YjV4Z0VPVU41ak5vdkVCSmlleDQ0cnpoR2RCN3FWVkR0UWd6NnNpVFRsNDR2ZU9zSmFMMUkrenNTbFNvTnJUV1hVODRsZnRvbVdscG1xbGhzb2lhRE9ValBlcEJjdXcxT1B6SXlLLzdpajBGUUNsNFdiR1JLaUYrOVg5RzAiLCJtYWMiOiJiM2Y0YTdjOGQwZGE2ZTAyYzQ1MjJiYWUxYzRkMDhmYzQ2MzNhNDY3ZGRjYzQzOGU0MGUxZjg5MTcxYTViOTE2IiwidGFnIjoiIn0%3D; expires=Tue, 11 Mar 2025 22:06:05 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImRxc2htd1NPMEEyN3pLaG90MEF2enc9PSIsInZhbHVlIjoiYTE0YjV4Z0VPVU41ak5vdkVCSmlleDQ0cnpoR2RCN3FWVkR0UWd6NnNpVFRsNDR2ZU9zSmFMMUkrenNTbFNvTnJUV1hVO ▶"
    1 => "tiene_descuento_session=eyJpdiI6IkxBUWdNaEthZWVxMHR5U3JhTzNJQVE9PSIsInZhbHVlIjoiVHozUEF2OGUxRStVMXQ4V0xaakFmZnJYLzNxUCtRTWk4TSt3TFZ0ZmZJZUVpSzJXa050anJUVDZtOW5odWhEbm9EVnZ0eWpEKzlZM1BETE9NWmNVS3lrRHZEZHBrbjEzOGJ1OW9TWVdVWmZESk5hblFHNmhLK3JRV3kzY3VuL3UiLCJtYWMiOiIwOGM5NmNlMzVjOGMwYWI1MmM5ZDE1NDMxZGU2OWNiMzY5OTcxOTkyOGYyOWVhYjcxMzZhZGFlMTY4ZWIzNjUxIiwidGFnIjoiIn0%3D; expires=Tue, 11 Mar 2025 22:06:05 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tiene_descuento_session=eyJpdiI6IkxBUWdNaEthZWVxMHR5U3JhTzNJQVE9PSIsInZhbHVlIjoiVHozUEF2OGUxRStVMXQ4V0xaakFmZnJYLzNxUCtRTWk4TSt3TFZ0ZmZJZUVpSzJXa050anJUVDZtOW5o ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImRxc2htd1NPMEEyN3pLaG90MEF2enc9PSIsInZhbHVlIjoiYTE0YjV4Z0VPVU41ak5vdkVCSmlleDQ0cnpoR2RCN3FWVkR0UWd6NnNpVFRsNDR2ZU9zSmFMMUkrenNTbFNvTnJUV1hVODRsZnRvbVdscG1xbGhzb2lhRE9ValBlcEJjdXcxT1B6SXlLLzdpajBGUUNsNFdiR1JLaUYrOVg5RzAiLCJtYWMiOiJiM2Y0YTdjOGQwZGE2ZTAyYzQ1MjJiYWUxYzRkMDhmYzQ2MzNhNDY3ZGRjYzQzOGU0MGUxZjg5MTcxYTViOTE2IiwidGFnIjoiIn0%3D; expires=Tue, 11-Mar-2025 22:06:05 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6ImRxc2htd1NPMEEyN3pLaG90MEF2enc9PSIsInZhbHVlIjoiYTE0YjV4Z0VPVU41ak5vdkVCSmlleDQ0cnpoR2RCN3FWVkR0UWd6NnNpVFRsNDR2ZU9zSmFMMUkrenNTbFNvTnJUV1hVO ▶"
    1 => "tiene_descuento_session=eyJpdiI6IkxBUWdNaEthZWVxMHR5U3JhTzNJQVE9PSIsInZhbHVlIjoiVHozUEF2OGUxRStVMXQ4V0xaakFmZnJYLzNxUCtRTWk4TSt3TFZ0ZmZJZUVpSzJXa050anJUVDZtOW5odWhEbm9EVnZ0eWpEKzlZM1BETE9NWmNVS3lrRHZEZHBrbjEzOGJ1OW9TWVdVWmZESk5hblFHNmhLK3JRV3kzY3VuL3UiLCJtYWMiOiIwOGM5NmNlMzVjOGMwYWI1MmM5ZDE1NDMxZGU2OWNiMzY5OTcxOTkyOGYyOWVhYjcxMzZhZGFlMTY4ZWIzNjUxIiwidGFnIjoiIn0%3D; expires=Tue, 11-Mar-2025 22:06:05 GMT; path=/; secure; httponly ◀tiene_descuento_session=eyJpdiI6IkxBUWdNaEthZWVxMHR5U3JhTzNJQVE9PSIsInZhbHVlIjoiVHozUEF2OGUxRStVMXQ4V0xaakFmZnJYLzNxUCtRTWk4TSt3TFZ0ZmZJZUVpSzJXa050anJUVDZtOW5o ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "app" => array:2 [▶
    "country" => "mx"
    "intended" => "https://tienedescuento.com/mx/suburbia/c/pantalones-y-jeans/b/weekend-premium"
  ]
  "_token" => "4Z7sYgs0OSWVu2qddEiIr7Ss95lIGT505htZUqk1"
  "_previous" => array:1 [▶
    "url" => "https://tienedescuento.com/mx/suburbia/c/pantalones-y-jeans/b/weekend-premium"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-03-11 14:06:05	GET	/mx/suburbia/c/pantalones-y-jeans/b/weekend-premium	132 10 22 2

1 x Application (99.84%)	4.31s
1 x Booting (0.21%)	9.04ms

¡Descubre los precios más bajos!

Pantalones y Jeans / Weekend Premium

Pantalón Relaxed Straight Weekend Premium De Algodón Para Hombre

Pantalón Slim Weekend Premium De Algodón Para Hombre

Pantalón Straight Weekend Premium De Algodón Para Hombre

Pantalón Regular Weekend Premium De Algodón Para Hombre

Bermuda Weekend Premium Para Hombre