Avatar Frontiers of Pandora Limited Edition Ps5

Avatar Frontiers of Pandora Limited Edition Ps5

$1,079.00
(precio regular)
Actualizado hace 7 horas

Rastreo de precios 2024-2025

¿Tiene descuento " Avatar Frontiers of Pandora Limited Edition Ps5"?

¡Este es el mejor precio de los últimos 90 días! Su precio normal suele estar entre $1,025.05 y $1,132.95, por lo que $1,079.00 en marzo 2025 es la mejor oferta que vas a encontrar. ¡Aprovéchala antes de que termine!

¿Cómo se calcula el descuento real en Tiene Descuento?

Algunas marcas cometen la mala práctica de subir sus precios antes de una venta especial. El algoritmo de Tiene Descuento es capaz de identificar el rango de precios en el que suele encontrarse el producto y eliminar esos "falsos descuentos" que las tiendas te quieren hacer creer. El descuento real indicado aquí, considera factores estadísticos para decirte la verdad.

Request history8.3.14PHP Version270msRequest Duration3MBMemory UsageGET {countryCode}/{storeSlug}/p/{productSku}/{productSlug}Route
  • infoProduct ID: 886225ShowProduct.php#29
  • Booting (60.95ms)time
  • Application (218ms)time
  • 1 x Application (80.9%)
    218ms
    1 x Booting (22.58%)
    60.95ms
    102 templates were rendered
    • 1x livewire.web.show-productshow-product.blade.php#?blade
    • 7x components.product-thumbproduct-thumb.blade.php#?blade
    • 65x components.linklink.blade.php#?blade
    • 1x livewire.web.track-producttrack-product.blade.php#?blade
    • 2x components.link-buttonlink-button.blade.php#?blade
    • 6x components.product-cardproduct-card.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.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
    • 2x components.taxonomy-treetaxonomy-tree.blade.php#?blade
    • 4x components.responsive-nav-linkresponsive-nav-link.blade.php#?blade
    uri
    GET {countryCode}/{storeSlug}/p/{productSku}/{productSlug}
    middleware
    web, App\Http\Middleware\StoreIntendedUrl
    uses
    App\Livewire\Web\ShowProduct@__invoke
    controller
    App\Livewire\Web\ShowProduct@render
    namespace
    prefix
    /{countryCode}
    where
    as
    products.show
    file
    app/Livewire/Web/ShowProduct.php:42-74
    13 statements were executed (2 duplicates)Show only duplicates69.78ms
    • 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
    • ShowProduct.php#21descuento18.07msselect * from `stores` where `country` = 'mx' and `slug` = 'sears' limit 1
      Bindings
      • 0: mx
      • 1: sears
      Backtrace
      • app/Livewire/Web/ShowProduct.php:21
      • 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
    • ShowProduct.php#24descuento1.5msselect * from `products` where `store_id` = 5 and `sku` = '3476487' limit 1
      Bindings
      • 0: 5
      • 1: 3476487
      Backtrace
      • app/Livewire/Web/ShowProduct.php:24
      • 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
    • ShowProduct.php#89descuento9.97msselect date_format(priced_date, '%d-%b-%y') as date, priced_date, min(price) as aggregate from `prices` where `product_id` = 886225 and `priced_date` >= '2024-12-15 00:00:00' group by `date`, `priced_date` order by `priced_date` asc
      Bindings
      • 0: 886225
      • 1: 2024-12-15 00:00:00
      Backtrace
      • app/Livewire/Web/ShowProduct.php:89
      • app/Livewire/Web/ShowProduct.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
    • ShowProduct.php#55descuento4.76msupdate `products` set `views` = `views` + 1, `products`.`updated_at` = '2025-03-15 10:11:29' where `id` = 886225
      Bindings
      • 0: 2025-03-15 10:11:29
      • 1: 886225
      Backtrace
      • app/Livewire/Web/ShowProduct.php:55
      • 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
    • ShowProduct.php#56descuento1.54msupdate `stores` set `views` = `views` + 1, `stores`.`updated_at` = '2025-03-15 10:11:29' where `stores`.`id` = 5
      Bindings
      • 0: 2025-03-15 10:11:29
      • 1: 5
      Backtrace
      • app/Livewire/Web/ShowProduct.php:56
      • 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
    • ShowProduct.php#57descuento4.83msupdate `categories` inner join `category_product` on `categories`.`id` = `category_product`.`category_id` set `views` = `views` + 1, `categories`.`updated_at` = '2025-03-15 10:11:29' where `category_product`.`product_id` = 886225
      Bindings
      • 0: 2025-03-15 10:11:29
      • 1: 886225
      Backtrace
      • app/Livewire/Web/ShowProduct.php:57
      • 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
    • Searchable.php#237descuento2.23msselect * from `products` where `products`.`id` in (886225, 885355, 907057, 931536, 931880, 474731, 701478, 70198, 163533, 175113)
      Backtrace
      • vendor/laravel/scout/src/Searchable.php:237
      • vendor/laravel/scout/src/Engines/MeilisearchEngine.php:292
      • vendor/laravel/scout/src/Engines/Engine.php:135
      • vendor/laravel/scout/src/Builder.php:331
      • app/Livewire/Web/ShowProduct.php:62
    • ShowProduct.php#63descuento840μsselect * from `stores` where `stores`.`id` in (1, 3, 4, 5)
      Backtrace
      • app/Livewire/Web/ShowProduct.php:63
      • 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-thumb.blade.php#32descuento990μsselect * from `stores` where `stores`.`id` = 5 limit 1
      Bindings
      • 0: 5
      Backtrace
      • view::components.product-thumb:32
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:38
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:16
      • vendor/sentry/sentry-laravel/src/Sentry/Laravel/Tracing/ViewEngineDecorator.php:47
    • Product.php#192descuento1.9msselect `categories`.*, `category_product`.`product_id` as `pivot_product_id`, `category_product`.`category_id` as `pivot_category_id` from `categories` inner join `category_product` on `categories`.`id` = `category_product`.`category_id` where `category_product`.`product_id` = 886225
      Bindings
      • 0: 886225
      Backtrace
      • app/Models/Product.php:192
      • view::livewire.web.show-product:48
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:38
      • vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:75
      • vendor/livewire/livewire/src/Mechanisms/ExtendBlade/ExtendedCompilerEngine.php:16
    • CatalogMenu.php#21descuento1.39msselect * 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#21descuento15.49msWITH 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#21descuento6.27msWITH 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\Price
    20Price.php#?
    App\Models\Store
    11Store.php#?
    App\Models\Product
    11Product.php#?
    App\Models\Category
    1Category.php#?
    web.show-product #zgMnzHmJGLkihKz8YSU8
    array:4 [ "data" => array:2 [ "store" => App\Models\Store {#1903 #connection: "mysql" ...
    web.track-product #G4vknfvlDo6C6EUhOm58
    array:4 [ "data" => array:3 [ "product" => App\Models\Product {#1929 #connection: "mysql...
    navigation-menu #wseXdL5RU6MVScqn78xQ
    array:4 [ "data" => [] "name" => "navigation-menu" "component" => "Laravel\Jetstream\Http\Live...
        app
        array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/sears/p/3476487/avatar-...
        _token
        jLpkDhcYWsilHb4JqA2adrTrNUvsN8hNb4IxvSeZ
        _previous
        array:1 [ "url" => "https://tienedescuento.com/mx/sears/p/3476487/avatar-frontiers-of-pandora-limi...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /mx/sears/p/3476487/avatar-frontiers-of-pandora-limited-edition-ps5
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:16 [ "cookie" => array:1 [ 0 => "XSRF-TOKEN=eyJpdiI6InQ1b1BqV1hNUDN3MzI0NDIydnVWTWc9PSIsInZhbHVlIjoib2YvcUJLZEN4OUJPeGFOaW1IZmhJWktkcWt0bEJUUTlWaHRZbmRTa3hGYko2ZFZaTlhheE1DMW1Sd2IwMDArRlZDUDlxcnpGV0ZtVG8vL2dGRWROU0I4TDdKbDM1OGFSQkcyQ1MzSVkxSTBjOUdiMDI4MVlLRzl5dGhaQXY4Q3UiLCJtYWMiOiJlYTZlYmE2OTZiMzc0NzFkMDU0ZTNkOGQ1NzczNmEwNzNiMTBjMjdiYjc1ZDRlMmFmMDZmMWY3OGE3ZmI4NmZiIiwidGFnIjoiIn0%3D; tiene_descuento_session=eyJpdiI6Ik5YQ01qMWVBZU16YXRERjQ1MTRsOUE9PSIsInZhbHVlIjoid3FjWG8zKytmOWVVTXNScDIydHovWitCOTJMUkNOYzFDWkg4ekdUWmVqTmpsRVBDa2k0TkNINDVya2ZEY3BVZVZSdnFvL3h1M041RzNHTUFCc203djRHME1VbUQ4ZGdXRGU5MEpWc3NqNGsvTU5TS1ZpNUNJQ2t4TVl0WHFmYW0iLCJtYWMiOiJiNzgyNjlmNDAwMjg0MjJkY2I0ZjYwN2Y5NGVmNDk1YzQxYmVjYzhlMTQzYTcwNWUzMjE0NWJkZTAzM2MwMmY3IiwidGFnIjoiIn0%3DXSRF-TOKEN=eyJpdiI6InQ1b1BqV1hNUDN3MzI0NDIydnVWTWc9PSIsInZhbHVlIjoib2YvcUJLZEN4OUJPeGFOaW1IZmhJWktkcWt0bEJUUTlWaHRZbmRTa3hGYko2ZFZaTlhheE1DMW1Sd2IwMDArRlZDUDlxc" ] "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
        0 of 0
        array:2 [ "XSRF-TOKEN" => "jLpkDhcYWsilHb4JqA2adrTrNUvsN8hNb4IxvSeZ" "tiene_descuento_session" => "pANazhlnhqMzlksWWlRMfgnpS5olGFxPfr4MEEpP" ]
        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 => "Sat, 15 Mar 2025 16:11:29 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=eyJpdiI6IlBqQjAzTVF5M0VzTVJXVlE5RnBDWEE9PSIsInZhbHVlIjoiaWhScFZYZlZJRGpyUVFvaTRPZExKL21Xa0VIYUN0WTJpN01hTkl1WW13TWZTTVRIUWpNY1pRZm90M0ZyWlZRbnFHWUpWT0xCTkVjRTZVRGhFeFFNc1VsMlo2M1F0SUJYSUV0WTdyeVpWelFTTVQrSFdwWFVNSXYxWnRwVktyYUgiLCJtYWMiOiIxMmE4YTlhOTU4ZDVmNzllOGRkMjE4OWM0ZjQ4YTJkNTQ0MWU1NjQzM2RmZjU2NTE5ZTg1NTNkNmM4ZGZiM2NiIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:11:29 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IlBqQjAzTVF5M0VzTVJXVlE5RnBDWEE9PSIsInZhbHVlIjoiaWhScFZYZlZJRGpyUVFvaTRPZExKL21Xa0VIYUN0WTJpN01hTkl1WW13TWZTTVRIUWpNY1pRZm90M0ZyWlZRbnFHWUpWT" 1 => "tiene_descuento_session=eyJpdiI6IkhmWnJZM1dkUkxTTEJMUzFDZVVOTlE9PSIsInZhbHVlIjoiNVRpRHJBa2FNQWswMEEycEZzdFpJcGU1SnlGdEEzVmlnOStLZWxLWHRNYXRaQ3d6cjE4eVBoRVdabVpIVlJOZGJjM0Y3R0g0N3VvbU56S3phMmErNVZsMWZwbFZVTHFEdFhFSjBSZlZabG5KZUR6TGhIb2VnTG1kQUVTLzIxVlUiLCJtYWMiOiI4ZTBhNDBmNGZjZDViMWQ3NjhlZjI5MDhlNWE0ZmIwZTdkODViOWRmZDZhMzE3ZmNjNjNhMDE0NzFmNjJkZjNiIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:11:29 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxtiene_descuento_session=eyJpdiI6IkhmWnJZM1dkUkxTTEJMUzFDZVVOTlE9PSIsInZhbHVlIjoiNVRpRHJBa2FNQWswMEEycEZzdFpJcGU1SnlGdEEzVmlnOStLZWxLWHRNYXRaQ3d6cjE4eVBoRVdabVpI" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IlBqQjAzTVF5M0VzTVJXVlE5RnBDWEE9PSIsInZhbHVlIjoiaWhScFZYZlZJRGpyUVFvaTRPZExKL21Xa0VIYUN0WTJpN01hTkl1WW13TWZTTVRIUWpNY1pRZm90M0ZyWlZRbnFHWUpWT0xCTkVjRTZVRGhFeFFNc1VsMlo2M1F0SUJYSUV0WTdyeVpWelFTTVQrSFdwWFVNSXYxWnRwVktyYUgiLCJtYWMiOiIxMmE4YTlhOTU4ZDVmNzllOGRkMjE4OWM0ZjQ4YTJkNTQ0MWU1NjQzM2RmZjU2NTE5ZTg1NTNkNmM4ZGZiM2NiIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:11:29 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IlBqQjAzTVF5M0VzTVJXVlE5RnBDWEE9PSIsInZhbHVlIjoiaWhScFZYZlZJRGpyUVFvaTRPZExKL21Xa0VIYUN0WTJpN01hTkl1WW13TWZTTVRIUWpNY1pRZm90M0ZyWlZRbnFHWUpWT" 1 => "tiene_descuento_session=eyJpdiI6IkhmWnJZM1dkUkxTTEJMUzFDZVVOTlE9PSIsInZhbHVlIjoiNVRpRHJBa2FNQWswMEEycEZzdFpJcGU1SnlGdEEzVmlnOStLZWxLWHRNYXRaQ3d6cjE4eVBoRVdabVpIVlJOZGJjM0Y3R0g0N3VvbU56S3phMmErNVZsMWZwbFZVTHFEdFhFSjBSZlZabG5KZUR6TGhIb2VnTG1kQUVTLzIxVlUiLCJtYWMiOiI4ZTBhNDBmNGZjZDViMWQ3NjhlZjI5MDhlNWE0ZmIwZTdkODViOWRmZDZhMzE3ZmNjNjNhMDE0NzFmNjJkZjNiIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:11:29 GMT; path=/; secure; httponlytiene_descuento_session=eyJpdiI6IkhmWnJZM1dkUkxTTEJMUzFDZVVOTlE9PSIsInZhbHVlIjoiNVRpRHJBa2FNQWswMEEycEZzdFpJcGU1SnlGdEEzVmlnOStLZWxLWHRNYXRaQ3d6cjE4eVBoRVdabVpI" ] ]
        session_attributes
        0 of 0
        array:4 [ "app" => array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/sears/p/3476487/avatar-frontiers-of-pandora-limited-edition-ps5" ] "_token" => "jLpkDhcYWsilHb4JqA2adrTrNUvsN8hNb4IxvSeZ" "_previous" => array:1 [ "url" => "https://tienedescuento.com/mx/sears/p/3476487/avatar-frontiers-of-pandora-limited-edition-ps5" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-03-15 10:11:29GET/mx/sears/p/3476487/avatar-frontiers-of-pandora-limited-edition-ps5110213433