Avatar Frontiers Of Pandora Edición Limitada Para PS5
Liverpool / Juegos PlayStation / Playstation

Avatar Frontiers Of Pandora Edición Limitada Para PS5

SKU: 1174133286 - Comprarlo en Liverpool
$1,125.00
(precio regular)
Actualizado hace 9 horas

Rastreo de precios 2024-2025

¿Tiene descuento "Avatar Frontiers Of Pandora Edición Limitada Para PS5"?

¡Este es el mejor precio de los últimos 90 días! Su precio normal suele estar entre $1,068.75 y $1,181.25, por lo que $1,125.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.

Productos Similares

¡Compara precios antes de comprar!
Avatar Frontiers Of Pandora Edición Limitada Para PS5
Suburbia

Avatar Frontiers Of Pandora Edición Limitada Para PS5

$1,125.00
Avatar Frontiers of Pandora Limited Edition Ps5
Sears

Avatar Frontiers of Pandora Limited Edition Ps5

$1,079.00
Avatar: Frontiers Of Pandora Para Xbox Series X Físico
-11%
Liverpool

Avatar: Frontiers Of Pandora Para Xbox Series X Físico

$903.20 $1,016.10
Avatar: Frontiers Of Pandora Para PS5 Físico
Liverpool

Avatar: Frontiers Of Pandora Para PS5 Físico

$1,439.10
Xbox Avatar: Frontiers of Pandora Xbox Series X
Podría no estar disponible
El Palacio

Xbox Avatar: Frontiers of Pandora Xbox Series X

$1,599.00
PlayStation Avatar: Frontiers of Pandora PS5
El Palacio

PlayStation Avatar: Frontiers of Pandora PS5

$639.60
Messages1TimelineExceptionsViews102RouteQueries13Models26Livewire3MailsGateSessionRequest
Request history8.3.14PHP Version213msRequest Duration3MBMemory UsageGET {countryCode}/{storeSlug}/p/{productSku}/{productSlug}Route
  • infoProduct ID: 931536ShowProduct.php#29
  • Booting (16.45ms)time
  • Application (204ms)time
  • 1 x Application (96.12%)
    204ms
    1 x Booting (7.74%)
    16.45ms
    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 duplicates42.31ms
    • 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#21descuento5.31msselect * 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#24descuento1.36msselect * from `products` where `store_id` = 1 and `sku` = '1174133286' limit 1
      Bindings
      • 0: 1
      • 1: 1174133286
      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#89descuento6.22msselect date_format(priced_date, '%d-%b-%y') as date, priced_date, min(price) as aggregate from `prices` where `product_id` = 931536 and `priced_date` >= '2024-12-15 00:00:00' group by `date`, `priced_date` order by `priced_date` asc
      Bindings
      • 0: 931536
      • 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#55descuento1.36msupdate `products` set `views` = `views` + 1, `products`.`updated_at` = '2025-03-15 08:59:05' where `id` = 931536
      Bindings
      • 0: 2025-03-15 08:59:05
      • 1: 931536
      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#56descuento3.2msupdate `stores` set `views` = `views` + 1, `stores`.`updated_at` = '2025-03-15 08:59:05' where `stores`.`id` = 1
      Bindings
      • 0: 2025-03-15 08:59:05
      • 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.92msupdate `categories` inner join `category_product` on `categories`.`id` = `category_product`.`category_id` set `views` = `views` + 1, `categories`.`updated_at` = '2025-03-15 08:59:05' where `category_product`.`product_id` = 931536
      Bindings
      • 0: 2025-03-15 08:59:05
      • 1: 931536
      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.79msselect * from `products` where `products`.`id` in (931536, 931880, 886225, 885355, 907057, 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.78msselect * 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.3msselect * 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#192descuento880μsselect `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` = 931536
      Bindings
      • 0: 931536
      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#21descuento4.33msselect * 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#21descuento3.18msWITH 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.68msWITH 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
    2Price.php#?
    App\Models\Category
    2Category.php#?
    web.show-product #A9Cl105S2GkgxLqaSPpf
    array:4 [ "data" => array:2 [ "store" => App\Models\Store {#1903 #connection: "mysql" ...
    web.track-product #N4ZJLUPPgnFldo11pbhe
    array:4 [ "data" => array:3 [ "product" => App\Models\Product {#1929 #connection: "mysql...
    navigation-menu #82ZlnPoUvaWQ4k1qZlIv
    array:4 [ "data" => [] "name" => "navigation-menu" "component" => "Laravel\Jetstream\Http\Live...
        app
        array:2 [ "country" => "mx" "intended" => "https://tienedescuento.com/mx/liverpool/p/1174133286/...
        _token
        PWs1F8Sv49qhuIrcncFQEAsYSMHUUlQWK3cIFHl6
        _previous
        array:1 [ "url" => "https://tienedescuento.com/mx/liverpool/p/1174133286/avatar-frontiers-of-pando...
        _flash
        array:2 [ "old" => [] "new" => [] ]
        path_info
        /mx/liverpool/p/1174133286/avatar-frontiers-of-pandora-edicion-limitada-para-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: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 => "Sat, 15 Mar 2025 14:59:06 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=eyJpdiI6InJ3WWZTZGVZR1RzQWU0SVVCbjlId0E9PSIsInZhbHVlIjoiMFhUcXhjbmhiN3daZ2ZjRTdOaDZxcXUzU09kc2JQN01WYUtJZ2ViYlc2UjVtM2tNSmg4N0FPYjdCeXo0bFZ2dUc0alFTWWlRWU5VRTdhRWNId2x4RFhpTmJDZ2lETHl0WkpkbGRTNjZkMjJ2clB6Z1F0SXo4d01mb1BBWjUrN2wiLCJtYWMiOiJiMTZlZmYzMmY4ZTJmMGY1YmEzMjJiZDFhMmViYzQ2ZmY3MjA4NDg0ZjU4MmRjN2Q3ZjZhYTgzNjY3YzI5ZjZkIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 16:59:06 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJ3WWZTZGVZR1RzQWU0SVVCbjlId0E9PSIsInZhbHVlIjoiMFhUcXhjbmhiN3daZ2ZjRTdOaDZxcXUzU09kc2JQN01WYUtJZ2ViYlc2UjVtM2tNSmg4N0FPYjdCeXo0bFZ2dUc0alFTW ▶"
    1 => "tiene_descuento_session=eyJpdiI6IjUxQlFqcFY4MFFIbjBYbE03c2lxdkE9PSIsInZhbHVlIjoiNUdPdkNPMGxIWmhZZU5ZV2gvSW8wZFA2UW1Qa3RwV1U2OFlRTnRJUVlROHlHV1pQWTFuUlphMVpNYWJBSndmY01KYlhJRm1zam9aSUJzUDRpS1BqTE1FM2ZRSjkya3QzbnRSNXZLYm1neHNiT21KWk1TK0lWR1RndnlyR2RKeFMiLCJtYWMiOiIwMDQwMmEwYjE0Yzk3MDAwNGFlN2RmODMzOTE1ODg2YTZmMGVmNzA4ZjQ0ZjkzYjcyNmE2ZTgyYjk4YjFlNzUzIiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 16:59:06 GMT; Max-Age=7200; path=/; secure; httponly; samesite=lax ◀tiene_descuento_session=eyJpdiI6IjUxQlFqcFY4MFFIbjBYbE03c2lxdkE9PSIsInZhbHVlIjoiNUdPdkNPMGxIWmhZZU5ZV2gvSW8wZFA2UW1Qa3RwV1U2OFlRTnRJUVlROHlHV1pQWTFuUlphMVpNYWJB ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InJ3WWZTZGVZR1RzQWU0SVVCbjlId0E9PSIsInZhbHVlIjoiMFhUcXhjbmhiN3daZ2ZjRTdOaDZxcXUzU09kc2JQN01WYUtJZ2ViYlc2UjVtM2tNSmg4N0FPYjdCeXo0bFZ2dUc0alFTWWlRWU5VRTdhRWNId2x4RFhpTmJDZ2lETHl0WkpkbGRTNjZkMjJ2clB6Z1F0SXo4d01mb1BBWjUrN2wiLCJtYWMiOiJiMTZlZmYzMmY4ZTJmMGY1YmEzMjJiZDFhMmViYzQ2ZmY3MjA4NDg0ZjU4MmRjN2Q3ZjZhYTgzNjY3YzI5ZjZkIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 16:59:06 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6InJ3WWZTZGVZR1RzQWU0SVVCbjlId0E9PSIsInZhbHVlIjoiMFhUcXhjbmhiN3daZ2ZjRTdOaDZxcXUzU09kc2JQN01WYUtJZ2ViYlc2UjVtM2tNSmg4N0FPYjdCeXo0bFZ2dUc0alFTW ▶"
    1 => "tiene_descuento_session=eyJpdiI6IjUxQlFqcFY4MFFIbjBYbE03c2lxdkE9PSIsInZhbHVlIjoiNUdPdkNPMGxIWmhZZU5ZV2gvSW8wZFA2UW1Qa3RwV1U2OFlRTnRJUVlROHlHV1pQWTFuUlphMVpNYWJBSndmY01KYlhJRm1zam9aSUJzUDRpS1BqTE1FM2ZRSjkya3QzbnRSNXZLYm1neHNiT21KWk1TK0lWR1RndnlyR2RKeFMiLCJtYWMiOiIwMDQwMmEwYjE0Yzk3MDAwNGFlN2RmODMzOTE1ODg2YTZmMGVmNzA4ZjQ0ZjkzYjcyNmE2ZTgyYjk4YjFlNzUzIiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 16:59:06 GMT; path=/; secure; httponly ◀tiene_descuento_session=eyJpdiI6IjUxQlFqcFY4MFFIbjBYbE03c2lxdkE9PSIsInZhbHVlIjoiNUdPdkNPMGxIWmhZZU5ZV2gvSW8wZFA2UW1Qa3RwV1U2OFlRTnRJUVlROHlHV1pQWTFuUlphMVpNYWJB ▶"
  ]
]
        session_attributes
          0 of 0   
        array:4 [▼
  "app" => array:2 [▶
    "country" => "mx"
    "intended" => "https://tienedescuento.com/mx/liverpool/p/1174133286/avatar-frontiers-of-pandora-edicion-limitada-para-ps5"
  ]
  "_token" => "PWs1F8Sv49qhuIrcncFQEAsYSMHUUlQWK3cIFHl6"
  "_previous" => array:1 [▶
    "url" => "https://tienedescuento.com/mx/liverpool/p/1174133286/avatar-frontiers-of-pandora-edicion-limitada-para-ps5"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]
        ClearShow all
        Date ↕MethodURLData
        #12025-03-15 08:59:06GET/mx/liverpool/p/1174133286/avatar-frontiers-of-pandora-edicion-limitada-para-ps5110213263