Avatar Frontiers Of Pandora Edición Limitada Para PS5

Avatar Frontiers Of Pandora Edición Limitada Para PS5

$1,125.00
(precio regular)
Actualizado hace 11 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.

Request history8.3.14PHP Version260msRequest Duration3MBMemory UsageGET {countryCode}/{storeSlug}/p/{productSku}/{productSlug}Route
  • infoProduct ID: 931536ShowProduct.php#29
  • Booting (10.61ms)time
  • Application (253ms)time
  • 1 x Application (96.99%)
    253ms
    1 x Booting (4.07%)
    10.61ms
    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 duplicates65.04ms
    • 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.2msselect * 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#24descuento4.48msselect * 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#89descuento3.42msselect 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#55descuento2.87msupdate `products` set `views` = `views` + 1, `products`.`updated_at` = '2025-03-15 10:41:48' where `id` = 931536
      Bindings
      • 0: 2025-03-15 10:41:48
      • 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#56descuento2.21msupdate `stores` set `views` = `views` + 1, `stores`.`updated_at` = '2025-03-15 10:41:48' where `stores`.`id` = 1
      Bindings
      • 0: 2025-03-15 10:41:48
      • 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#57descuento6.11msupdate `categories` inner join `category_product` on `categories`.`id` = `category_product`.`category_id` set `views` = `views` + 1, `categories`.`updated_at` = '2025-03-15 10:41:48' where `category_product`.`product_id` = 931536
      Bindings
      • 0: 2025-03-15 10:41:48
      • 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#237descuento3.14msselect * 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#63descuento820μ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#32descuento2.32msselect * 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#192descuento2.34msselect `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#21descuento1.58msselect * 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.97msWITH 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#21descuento8.58msWITH 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 #0C90l1wPQeufh2cnXuky
    array:4 [ "data" => array:2 [ "store" => App\Models\Store {#1903 #connection: "mysql" ...
    web.track-product #L6gFH8lZVXfevXppZs72
    array:4 [ "data" => array:3 [ "product" => App\Models\Product {#1929 #connection: "mysql...
    navigation-menu #BZjSZNsx7bDqHGIoedQZ
    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
        VajOKxQPjFNnNJ8Ib21N6CroadoZXmTgAYgMQeld
        _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 16:41:48 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=eyJpdiI6IkxhNmpsRjJ2WU9NYU5vNk9ZYS9aL2c9PSIsInZhbHVlIjoiV0xickx6UkJtWU1Mdmt0WERKam9hc0ZZR1dPVnZEUVdnbW1oSkg2T2kveDJQcWlyejY1OTc2d2VlOU5SWnVQVUNxU3NCTi90YXo3UWw5RDM2cGFYQ3Z5M05yQloxcjdyRFZvVXB0d01YUS8raTlGeDMreVNNYjZKTmNPcFNwQXYiLCJtYWMiOiIxNWNjZTE4OGI2YjJjNDBlMmNmZTQyMTRjOGE0YzU3ZjRjYTYyNDg1MTE1MTNjMWNmYjZiZWQwOGFhMDBkYWM1IiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:41:48 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6IkxhNmpsRjJ2WU9NYU5vNk9ZYS9aL2c9PSIsInZhbHVlIjoiV0xickx6UkJtWU1Mdmt0WERKam9hc0ZZR1dPVnZEUVdnbW1oSkg2T2kveDJQcWlyejY1OTc2d2VlOU5SWnVQVUNxU3NCT" 1 => "tiene_descuento_session=eyJpdiI6Impqeld5c1l6VU02WDlLUjl4L0pHSVE9PSIsInZhbHVlIjoiZE1qS2VCWVU1WkNmaXFjbEZya3BmUmJPYmZ1L2dQQlhCb0t6b0F2WnJUdXNFOUxMNTZ1VklXR1BBQ1dFd2VvWnpwVXh4YzcxQTZoanFhUGltUGlQbDVKNmdPbThtQkdUOFNiWlVnSXV5ZmJIZUtha3ZWMHREdENiUVp6S2xnVk8iLCJtYWMiOiI5NWYzZDA4YWU1YmY4MWRkM2RhYWUzNmViMzBhZDE3NjExZmE4MmUwYTcxZmViY2Q3OGM3Y2NhYzJlZGMzYzI4IiwidGFnIjoiIn0%3D; expires=Sat, 15 Mar 2025 18:41:48 GMT; Max-Age=7200; path=/; secure; httponly; samesite=laxtiene_descuento_session=eyJpdiI6Impqeld5c1l6VU02WDlLUjl4L0pHSVE9PSIsInZhbHVlIjoiZE1qS2VCWVU1WkNmaXFjbEZya3BmUmJPYmZ1L2dQQlhCb0t6b0F2WnJUdXNFOUxMNTZ1VklXR1BBQ1dF" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkxhNmpsRjJ2WU9NYU5vNk9ZYS9aL2c9PSIsInZhbHVlIjoiV0xickx6UkJtWU1Mdmt0WERKam9hc0ZZR1dPVnZEUVdnbW1oSkg2T2kveDJQcWlyejY1OTc2d2VlOU5SWnVQVUNxU3NCTi90YXo3UWw5RDM2cGFYQ3Z5M05yQloxcjdyRFZvVXB0d01YUS8raTlGeDMreVNNYjZKTmNPcFNwQXYiLCJtYWMiOiIxNWNjZTE4OGI2YjJjNDBlMmNmZTQyMTRjOGE0YzU3ZjRjYTYyNDg1MTE1MTNjMWNmYjZiZWQwOGFhMDBkYWM1IiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:41:48 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkxhNmpsRjJ2WU9NYU5vNk9ZYS9aL2c9PSIsInZhbHVlIjoiV0xickx6UkJtWU1Mdmt0WERKam9hc0ZZR1dPVnZEUVdnbW1oSkg2T2kveDJQcWlyejY1OTc2d2VlOU5SWnVQVUNxU3NCT" 1 => "tiene_descuento_session=eyJpdiI6Impqeld5c1l6VU02WDlLUjl4L0pHSVE9PSIsInZhbHVlIjoiZE1qS2VCWVU1WkNmaXFjbEZya3BmUmJPYmZ1L2dQQlhCb0t6b0F2WnJUdXNFOUxMNTZ1VklXR1BBQ1dFd2VvWnpwVXh4YzcxQTZoanFhUGltUGlQbDVKNmdPbThtQkdUOFNiWlVnSXV5ZmJIZUtha3ZWMHREdENiUVp6S2xnVk8iLCJtYWMiOiI5NWYzZDA4YWU1YmY4MWRkM2RhYWUzNmViMzBhZDE3NjExZmE4MmUwYTcxZmViY2Q3OGM3Y2NhYzJlZGMzYzI4IiwidGFnIjoiIn0%3D; expires=Sat, 15-Mar-2025 18:41:48 GMT; path=/; secure; httponlytiene_descuento_session=eyJpdiI6Impqeld5c1l6VU02WDlLUjl4L0pHSVE9PSIsInZhbHVlIjoiZE1qS2VCWVU1WkNmaXFjbEZya3BmUmJPYmZ1L2dQQlhCb0t6b0F2WnJUdXNFOUxMNTZ1VklXR1BBQ1dF" ] ]
        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" => "VajOKxQPjFNnNJ8Ib21N6CroadoZXmTgAYgMQeld" "_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 10:41:48GET/mx/liverpool/p/1174133286/avatar-frontiers-of-pandora-edicion-limitada-para-ps5110213263