Avatar: Frontiers Of Pandora Para PS5 Físico

Avatar: Frontiers Of Pandora Para PS5 Físico

$1,439.10
(precio regular)
Actualizado en 5 horas

Rastreo de precios 2024-2025

¿Tiene descuento "Avatar: Frontiers Of Pandora Para PS5 Físico"?

¡Este es el mejor precio de los últimos 90 días! Su precio normal suele estar entre $1,367.15 y $1,511.06, por lo que $1,439.10 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 Version282msRequest Duration3MBMemory UsageGET {countryCode}/{storeSlug}/p/{productSku}/{productSlug}Route
  • infoProduct ID: 907057ShowProduct.php#29
  • Booting (21.74ms)time
  • Application (264ms)time
  • 1 x Application (93.74%)
    264ms
    1 x Booting (7.71%)
    21.74ms
    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 duplicates51.55ms
    • 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#21descuento6.33msselect * from `stores` where `country` = 'mx' and `slug` = 'liverpool' limit 1
      Bindings
      • 0: mx
      • 1: liverpool
      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#24descuento3.31msselect * from `products` where `store_id` = 1 and `sku` = '1144929264' limit 1
      Bindings
      • 0: 1
      • 1: 1144929264
      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#89descuento3.4msselect date_format(priced_date, '%d-%b-%y') as date, priced_date, min(price) as aggregate from `prices` where `product_id` = 907057 and `priced_date` >= '2024-12-14 00:00:00' group by `date`, `priced_date` order by `priced_date` asc
      Bindings
      • 0: 907057
      • 1: 2024-12-14 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#55descuento2.14msupdate `products` set `views` = `views` + 1, `products`.`updated_at` = '2025-03-14 17:36:50' where `id` = 907057
      Bindings
      • 0: 2025-03-14 17:36:50
      • 1: 907057
      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.56msupdate `stores` set `views` = `views` + 1, `stores`.`updated_at` = '2025-03-14 17:36:50' where `stores`.`id` = 1
      Bindings
      • 0: 2025-03-14 17:36:50
      • 1: 1
      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#57descuento2.31msupdate `categories` inner join `category_product` on `categories`.`id` = `category_product`.`category_id` set `views` = `views` + 1, `categories`.`updated_at` = '2025-03-14 17:36:50' where `category_product`.`product_id` = 907057
      Bindings
      • 0: 2025-03-14 17:36:50
      • 1: 907057
      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#237descuento5.09msselect * from `products` where `products`.`id` in (907057, 931536, 931880, 885355, 886225, 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#63descuento1.56msselect * 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#32descuento2.75msselect * from `stores` where `stores`.`id` = 1 limit 1
      Bindings
      • 0: 1
      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#192descuento3.15msselect `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` = 907057
      Bindings
      • 0: 907057
      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#21descuento3.92msselect * 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#21descuento8.52msWITH 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#21descuento7.51msWITH 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\Store
    11Store.php#?
    App\Models\Product
    11Product.php#?
    App\Models\Price
    10Price.php#?
    App\Models\Category
    2Category.php#?
    web.show-product #NETdkqRZSqtF7UGrki6V
    array:4 [ "data" => array:2 [ "store" => App\Models\Store {#1903 #connection: "mysql" ...
    web.track-product #lXRY5FcTig0aFYrJlkDW
    array:4 [ "data" => array:3 [ "product" => App\Models\Product {#1929 #connection: "mysql...
    navigation-menu #Y8v43ciR1sdzh7DhEHvT
    array:4 [ "data" => [] "name" => "navigation-menu" "component" => "Laravel\Jetstream\Http\Live...
        app
        array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/liverpool/p/1144929264/...
        _token
        VCLKO9XBxuUVUPcOd4Pysmg6c39jYktpiDKe1Rvf
        _previous
        array:1 [ "url" => "https://tienedescuento.com/mx/liverpool/p/1144929264/avatar-frontiers-of-pando...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /mx/liverpool/p/1144929264/avatar-frontiers-of-pandora-para-ps5-fisico
        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: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 => "Fri, 14 Mar 2025 23:36:50 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=eyJpdiI6IitUNEJCcVRVbmxpU0FoNmFxYlNpTEE9PSIsInZhbHVlIjoieU9MZGNOTUV3NllWR3hKZUtwS3JURGZNWXN1elF0RDk5SWV5c04zSWVaU1Q2VE1VbUdyRkE3bnRpeFJuSkNDOExYbFU1TVM3NjFhbVZYZXliSWNuN2VQZHBKbFFXMHJLcXVzZ3p6aDBaMkxLTEFLSDA1ckZCR1FZT3BxSEEyRXkiLCJtYWMiOiIwNzU0NTVhMDA1MDkwNzBkODJhYjIzNmViMTBjZDY0YzY5Mjc2ZGZmYjBhYTk1NjRkNzJkODE5ODhhOWM3MDhiIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 01:36:50 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IitUNEJCcVRVbmxpU0FoNmFxYlNpTEE9PSIsInZhbHVlIjoieU9MZGNOTUV3NllWR3hKZUtwS3JURGZNWXN1elF0RDk5SWV5c04zSWVaU1Q2VE1VbUdyRkE3bnRpeFJuSkNDOExYbFU1T" 1 => "tiene_descuento_session=eyJpdiI6InpCMm1yWmR1Z0ZKUWswSkFDdC9tcEE9PSIsInZhbHVlIjoiTUVyL0tWZnczdmpZRWM0dEVZWUF0WitzS0NETmRuUVVkS1lYQkgrSkR1UjZzblN4b3J4dFdKU3QvQ3pDZW5pUUI2MnQ2Qmlkb1NENVpveVB0L1BtTFRxUmFrVlpJM3N5SEVXd3Bva2krV0VDQWxQYUl6VVd1blRVK3hMUEJmczIiLCJtYWMiOiI3NGU0Njg0MDA1MWE4ZDNmMjJlY2NlNGEyMGNhNDdmNWYzMDZmMGNmYTU4NWViMjVlOTkzY2YwYzZlZjk2MGYxIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 01:36:50 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxtiene_descuento_session=eyJpdiI6InpCMm1yWmR1Z0ZKUWswSkFDdC9tcEE9PSIsInZhbHVlIjoiTUVyL0tWZnczdmpZRWM0dEVZWUF0WitzS0NETmRuUVVkS1lYQkgrSkR1UjZzblN4b3J4dFdKU3QvQ3pD" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IitUNEJCcVRVbmxpU0FoNmFxYlNpTEE9PSIsInZhbHVlIjoieU9MZGNOTUV3NllWR3hKZUtwS3JURGZNWXN1elF0RDk5SWV5c04zSWVaU1Q2VE1VbUdyRkE3bnRpeFJuSkNDOExYbFU1TVM3NjFhbVZYZXliSWNuN2VQZHBKbFFXMHJLcXVzZ3p6aDBaMkxLTEFLSDA1ckZCR1FZT3BxSEEyRXkiLCJtYWMiOiIwNzU0NTVhMDA1MDkwNzBkODJhYjIzNmViMTBjZDY0YzY5Mjc2ZGZmYjBhYTk1NjRkNzJkODE5ODhhOWM3MDhiIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 01:36:50 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IitUNEJCcVRVbmxpU0FoNmFxYlNpTEE9PSIsInZhbHVlIjoieU9MZGNOTUV3NllWR3hKZUtwS3JURGZNWXN1elF0RDk5SWV5c04zSWVaU1Q2VE1VbUdyRkE3bnRpeFJuSkNDOExYbFU1T" 1 => "tiene_descuento_session=eyJpdiI6InpCMm1yWmR1Z0ZKUWswSkFDdC9tcEE9PSIsInZhbHVlIjoiTUVyL0tWZnczdmpZRWM0dEVZWUF0WitzS0NETmRuUVVkS1lYQkgrSkR1UjZzblN4b3J4dFdKU3QvQ3pDZW5pUUI2MnQ2Qmlkb1NENVpveVB0L1BtTFRxUmFrVlpJM3N5SEVXd3Bva2krV0VDQWxQYUl6VVd1blRVK3hMUEJmczIiLCJtYWMiOiI3NGU0Njg0MDA1MWE4ZDNmMjJlY2NlNGEyMGNhNDdmNWYzMDZmMGNmYTU4NWViMjVlOTkzY2YwYzZlZjk2MGYxIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 01:36:50 GMT; path=/; secure; httponlytiene_descuento_session=eyJpdiI6InpCMm1yWmR1Z0ZKUWswSkFDdC9tcEE9PSIsInZhbHVlIjoiTUVyL0tWZnczdmpZRWM0dEVZWUF0WitzS0NETmRuUVVkS1lYQkgrSkR1UjZzblN4b3J4dFdKU3QvQ3pD" ] ]
        session_attributes
        0 of 0
        array:4 [ "app" => array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/liverpool/p/1144929264/avatar-frontiers-of-pandora-para-ps5-fisico" ] "_token" => "VCLKO9XBxuUVUPcOd4Pysmg6c39jYktpiDKe1Rvf" "_previous" => array:1 [ "url" => "https://tienedescuento.com/mx/liverpool/p/1144929264/avatar-frontiers-of-pandora-para-ps5-fisico" ] "_flash" => array:2 [ "old" => [] "new" => [] ] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-03-14 17:36:50GET/mx/liverpool/p/1144929264/avatar-frontiers-of-pandora-para-ps5-fisico110213343