Заказать звонок
Электронная почта:
info@avtoshina34.ru
ПН - ПТ 09:00-18:00 СУББОТА 09:00-15:00
Мой заказ: 0₽
0
basket
0 на сумму 0 ₽
Подбор Показать категории
Производитель
Модель
Год
Комплектация
Подобрать
Сезон
Ширина
Высота
Диаметр
Производитель
Тип
Подобрать
Нужна помощь? Нужна помощь?
Ширина
Высота
Диаметр
Ось
Производитель
Подобрать
Нужна помощь? Нужна помощь?
Диаметр
Ширина
Кол-во отверстий
PCD
DIA
Вылет ET
Тип диска
Производитель
Подобрать
Полярность
Емкость
Тип клемм
Производитель
Подобрать
Тип
Объем
Вязкость
Производитель
Вид масла
Подобрать
Производитель
Модель
Модификации
Подобрать
Калькулятор

Показать категории

Шина летняя Hankook K127 Ventus S1 Evo3 245/50 R19 105Y

← Назад
Купить Hankook K127 Ventus S1 Evo3 245/50 R19 105Y в Волгограде

35% скидка на шиномонтаж шин, приобретенных у нас.

Запись на шиномонтаж
Купить Hankook K127 Ventus S1 Evo3 245/50 R19 105Y в Волгограде
Купить Hankook K127 Ventus S1 Evo3 245/50 R19 105Y в Волгограде
Купить Hankook K127 Ventus S1 Evo3 245/50 R19 105Y в Волгограде

Под заказ: 18

Модель: K127 Ventus S1 Evo3
Производитель: Hankook
Внимание!
Данного товара нет в наличии в магазине, доступен предзаказ с удаленного склада!
Наличие: 18 шт.
Склад №11
Артикул 1026266
Срок: >от 2 дней
23710₽
-
1
+
Купить
Заказать по телефону
Жду звонка
Менеджер перезвонит вам, узнает все детали и оформит заказ на Ваше имя.
Поторгуемся?
Запросить промокод
Самовывоз:
ул. Кибальчича, д.18
О доставке и оплате
Доступные терминалы

Терминал доступный

При оплате картой взимается комиссия 1%


Описание

Характеристики шины Hankook K127 Ventus S1 Evo3 245/50 R19 105Y

Ширина: 245
Высота: 50
Диаметр: 19
Индекс скорости: 105Y
Сезонность: Летняя
Шипы: Не шипованная

Аналоги
Michelin
Michelin Latitude Sport 3 245/50 R19 105W

Michelin Latitude Sport 3 245/50 R19 105W

Под заказ 1 шт.
Артикул: 88431053702 Склад №8 Самовывоз: г. Волгоград, ул. им. Менделеева, 51 Срок: 3 дня
42690 ₽
-
1
+
В корзину
Michelin
Michelin Pilot Sport 4 SUV 245/50 R19 105W

Michelin Pilot Sport 4 SUV 245/50 R19 105W

Под заказ 1 шт.
Артикул: 112122551807 Склад №8 Самовывоз: г. Волгоград, ул. им. Менделеева, 51 Срок: 3 дня
38720 ₽
-
1
+
В корзину
Pirelli
Pirelli Cinturato P7 (P7C2) 245/50 R19 105W

Pirelli Cinturato P7 (P7C2) 245/50 R19 105W

Под заказ 1 шт.
Артикул: 3381900 Склад №5 Самовывоз: г. Волгоград, ул. им. Менделеева, 51 Срок: 4 дня
28160 ₽
-
1
+
В корзину
Pirelli
Pirelli Cinturato P7 (P7C2) 245/50 R19 105W

Pirelli Cinturato P7 (P7C2) 245/50 R19 105W

Под заказ 1 шт.
Артикул: 3111100 Склад №5 Самовывоз: г. Волгоград, ул. им. Менделеева, 51 Срок: 4 дня
35790 ₽
-
1
+
В корзину
GoodRide
GoodRide Solmax1 245/50 R19 105W

GoodRide Solmax1 245/50 R19 105W

Под заказ 3 шт.
Артикул: CTS277538 Склад №11 Самовывоз: г. Волгоград, ул. им. Менделеева, 51 Срок: 7 дней
12170 ₽
-
1
+
В корзину
Гарантия Оплата Услуги Информация Калькулятор Запись на шиномонтаж Акции Контакты
Легковые шины Грузовые и с/х шины Диски Аккумуляторы Масла Автохимия Автотовары
+7 (906) 40-666-04 | ул. Кибальчича, д.18, | info@avtoshina34.ru
Разработка и продвижение сайта — Mono
MessagesTimelineExceptionsViews0RouteQueries6Models167MailsGateSessionRequest
7.2.24Version34.74msRequest Duration5MBMemory UsagePOST promocodes/refreshRoute
    • Booting (18.65ms)
    • Application (16ms)
    • 1 x Booting (53.67%)
      18.65ms
      1 x Application (46.06%)
      16.00ms
      0 templates were rendered
        uri
        POST promocodes/refresh
        middleware
        web, client, redirects, seo
        controller
        App\Http\Controllers\Client\PromocodeController@refreshTotal
        namespace
        App\Http\Controllers\Client
        prefix
        /promocodes
        where
        file
        app/Http/Controllers/Client/PromocodeController.php:120-127
        6 statements were executed4.87ms
        avtoshina_beta
        • select * from `categories` where (`parent` = 1 and `tmp` = '0' and `visible` = 1) order by `categories`.`order` asc610μs/app/Models/Product/Category.php:158avtoshina_beta
          Metadata
          Bindings
          • 0. 1
          • 1. 0
          • 2. 1
          Hints
          • Use SELECT * only if you need all columns from table
          Backtrace
          • 10. /app/Models/Product/Category.php:158
          • 11. middleware::client:21
          • 12. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 13. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 14. middleware::bindings:41
          • 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 17. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 20. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 23. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 26. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 29. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
          • 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
          • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
          • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
          • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
          • 37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
          • 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 42. /vendor/fideloper/proxy/src/TrustProxies.php:56
          • 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
          • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
          • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
        • select * from `car_manufacturers` order by `name` asc590μsmiddleware::client:22avtoshina_beta
          Metadata
          Hints
          • Use SELECT * only if you need all columns from table
          • The SELECT statement has no WHERE clause and could examine many more rows than intended
          Backtrace
          • 12. middleware::client:22
          • 13. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 14. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 15. middleware::bindings:41
          • 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 21. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 24. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 27. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
          • 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
          • 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
          • 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
          • 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
          • 38. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
          • 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 43. /vendor/fideloper/proxy/src/TrustProxies.php:56
          • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
          • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
        • select * from `seo_redirects` where `page_from` = 'promocodes/refresh' limit 1760μs/app/Models/Redirect.php:33avtoshina_beta
          Metadata
          Bindings
          • 0. promocodes/refresh
          Hints
          • Use SELECT * only if you need all columns from table
          • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
          Backtrace
          • 13. /app/Models/Redirect.php:33
          • 14. middleware::redirects:23
          • 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 17. middleware::client:27
          • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 20. middleware::bindings:41
          • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 35. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
          • 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
          • 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
          • 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
          • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
          • 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
          • 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 48. /vendor/fideloper/proxy/src/TrustProxies.php:56
          • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
        • select `title`, `h1`, `description`, `keywords` from `seo` where `page_url` = 'promocodes/refresh' limit 11.27ms/app/Models/Seo.php:36avtoshina_beta
          Metadata
          Bindings
          • 0. promocodes/refresh
          Hints
          • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
          Backtrace
          • 13. /app/Models/Seo.php:36
          • 14. middleware::seo:23
          • 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 17. middleware::redirects:29
          • 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 20. middleware::client:27
          • 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 23. middleware::bindings:41
          • 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 26. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 29. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 32. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 35. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
          • 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
          • 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
          • 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
          • 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
          • 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
          • 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
        • select `id` from `suppliers` where `type` = 'store'310μs/app/Models/Product/Product.php:1323avtoshina_beta
          Metadata
          Bindings
          • 0. store
          Backtrace
          • 12. /app/Models/Product/Product.php:1323
          • 13. /app/Models/Cart.php:57
          • 14. /app/Http/Controllers/Client/PromocodeController.php:125
          • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
          • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
          • 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 22. middleware::seo:26
          • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 25. middleware::redirects:29
          • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 28. middleware::client:27
          • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 31. middleware::bindings:41
          • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 34. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 37. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 40. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
        • select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`, CASE WHEN EXISTS ( SELECT 1 FROM product_store WHERE product_store.product_id = product.id AND product_store.supplier_id = 13 ) THEN (SELECT LEAST( COALESCE(NULLIF(price, 0), 9999999), COALESCE(NULLIF(discount_price, 0), 9999999) ) FROM product_store WHERE product_id = product.id AND supplier_id = 13 ) ELSE CASE WHEN EXISTS ( SELECT 1 FROM product_store WHERE product_store.product_id = product.id AND product_store.supplier_id IN (12,13) ) THEN (SELECT LEAST( COALESCE(NULLIF(price, 0), 9999999), COALESCE(NULLIF(discount_price, 0), 9999999) ) FROM product_store WHERE product_id = product.id AND supplier_id IN (12,13) LIMIT 1) ELSE CASE WHEN EXISTS ( SELECT 1 FROM product_redprice WHERE product_redprice.product_id = store.product_id AND product_redprice.supplier_id = store.supplier_id ) THEN FLOOR((store.price * (100 - (SELECT discount FROM product_redprice WHERE product_redprice.product_id = store.product_id AND product_redprice.supplier_id = store.supplier_id LIMIT 1)) / 100) / 10) * 10 ELSE store.store_min_price END END END AS main_price , `suppliers`.`type`, `cart_product`.`quantity` as `cart_quantity`, `cart_product`.`price` as `cart_price`, `cart_product`.`storage` as `cart_storage`, `product_images`.`path` as `image_path`, `product`.`id` as `product_id` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join ( SELECT product_id, supplier_id, price, discount_price, sum(product_store.quantity) as store_sum, min(product_store.price) as store_min_price FROM product_store WHERE quantity > 0 AND price > 0 GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `carts` as `cart_product` on `product`.`id` = `cart_product`.`product_id` left join (select path, product_id from product_images join (select min(id) as id from product_images where product_images.order IS NULL OR product_images.order = 1 group by product_id) as img on product_images.id = img.id) as product_images on `product`.`id` = `product_images`.`product_id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `session_id` = 'NUiqIFuCCHUAyqK0T7v1jdC6hEEealokVTLpg8YR' order by (SELECT quantity FROM product_store WHERE product_id = product.id AND supplier_id = 13 LIMIT 1) DESC, `suppliers`.`type` desc1.33ms/app/Models/Cart.php:74avtoshina_beta
          Metadata
          Bindings
          • 0. 1
          • 1. 0
          • 2. 0
          • 3. 1
          • 4. NUiqIFuCCHUAyqK0T7v1jdC6hEEealokVTLpg8YR
          Backtrace
          • 10. /app/Models/Cart.php:74
          • 11. /app/Http/Controllers/Client/PromocodeController.php:125
          • 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
          • 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
          • 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
          • 17. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
          • 18. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
          • 19. middleware::seo:26
          • 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 22. middleware::redirects:29
          • 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 25. middleware::client:27
          • 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 28. middleware::bindings:41
          • 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 31. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
          • 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 34. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
          • 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 37. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
          • 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 40. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
          • 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
          • 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
          • 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
          • 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
          • 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
          • 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
          • 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
        App\Models\Supplier
        2
        App\Models\Car\CarManufacturer
        165
            _token
            zAhSikVWS2BdvceBInLNbtgGBxgGCBh424C60rBO
            _previous
            array:1 [ "url" => "https://dev.avtoshina34.ru/catalog/tyres/hankook/706743?page=5" ]
            PHPDEBUGBAR_STACK_DATA
            []
            _flash
            array:2 [ "old" => [] "new" => [] ]
            path_info
            /promocodes/refresh
            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:19 [▶
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVhYjAzNGEwYzM5ZDlhYTkyNDA0OGEzMjNiMjRkMzY4MjA4YzI0MGIwMTM4NGMyN2I3NTgzMDExOTJmYjc1In0%3D; laravel_session=eyJpdiI6Im9VeVdCVGNoV0w1MnR2MmJsak9Mb2c9PSIsInZhbHVlIjoiaTF6eVBDeWx0eFFqcVwvZExmanlNXC9xYkdXUHRvem5zU0hJMXJ1dHVvUGFHaVFMMndxazJiUWt5WUgwRHN2SnBNMWNqOUpvZ3FXUVBcL3F1c05MejR6aGRSTkc2TEhPb2kwNUlTWHNWZ3JsQkdRMWh0TUFEeml6TXdNaGswNnoxOGYiLCJtYWMiOiJhN2VjYjE3ZmJjYmI2NDYxOGZmNGFhYmNmNGM1MjIxMzBkMWMyMmQxNGU1MDhmZWUwMGU2ZjViMDdhZGQ5MTQ2In0%3D ◀XSRF-TOKEN=eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtY ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "referer" => array:1 [▶
    0 => "https://dev.avtoshina34.ru/catalog/tyres/hankook/780376?page=5"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "empty"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "cors"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "same-origin"
  ]
  "origin" => array:1 [▶
    0 => "https://dev.avtoshina34.ru"
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "content-type" => array:1 [▶
    0 => "application/json;charset=UTF-8"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "accept" => array:1 [▶
    0 => "application/json, text/plain, */*"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "x-xsrf-token" => array:1 [▶
    0 => "eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVhYjAzNGEwYzM5ZDlhYTkyNDA0OGEzMjNiMjRkMzY4MjA4YzI0MGIwMTM4NGMyN2I3NTgzMDExOTJmYjc1In0= ◀eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVh ▶"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "content-length" => array:1 [▶
    0 => "2"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "dev.avtoshina34.ru"
  ]
]
            request_server
              0 of 0   
            array:45 [▶
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVhYjAzNGEwYzM5ZDlhYTkyNDA0OGEzMjNiMjRkMzY4MjA4YzI0MGIwMTM4NGMyN2I3NTgzMDExOTJmYjc1In0%3D; laravel_session=eyJpdiI6Im9VeVdCVGNoV0w1MnR2MmJsak9Mb2c9PSIsInZhbHVlIjoiaTF6eVBDeWx0eFFqcVwvZExmanlNXC9xYkdXUHRvem5zU0hJMXJ1dHVvUGFHaVFMMndxazJiUWt5WUgwRHN2SnBNMWNqOUpvZ3FXUVBcL3F1c05MejR6aGRSTkc2TEhPb2kwNUlTWHNWZ3JsQkdRMWh0TUFEeml6TXdNaGswNnoxOGYiLCJtYWMiOiJhN2VjYjE3ZmJjYmI2NDYxOGZmNGFhYmNmNGM1MjIxMzBkMWMyMmQxNGU1MDhmZWUwMGU2ZjViMDdhZGQ5MTQ2In0%3D ◀XSRF-TOKEN=eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtY ▶"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://dev.avtoshina34.ru/catalog/tyres/hankook/780376?page=5"
  "HTTP_SEC_FETCH_DEST" => "empty"
  "HTTP_SEC_FETCH_MODE" => "cors"
  "HTTP_SEC_FETCH_SITE" => "same-origin"
  "HTTP_ORIGIN" => "https://dev.avtoshina34.ru"
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_CONTENT_TYPE" => "application/json;charset=UTF-8"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_ACCEPT" => "application/json, text/plain, */*"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_X_XSRF_TOKEN" => "eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVhYjAzNGEwYzM5ZDlhYTkyNDA0OGEzMjNiMjRkMzY4MjA4YzI0MGIwMTM4NGMyN2I3NTgzMDExOTJmYjc1In0= ◀eyJpdiI6IlphY1dyU2VIaWNWVVI3NFlacVdnWEE9PSIsInZhbHVlIjoiR1B1UStiZkx0ZnJOUXFOcFwvNHU1S01ZS3k0b3VoMGVpdW5EODFVZVJFZ0EyejZTRzNNNjVtdVVmR1B5Y1JTbUciLCJtYWMiOiJkOTVh ▶"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONTENT_LENGTH" => "2"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "dev.avtoshina34.ru"
  "SCRIPT_FILENAME" => "/var/www/avtoshina_beta/public/index.php"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "dev.avtoshina34.ru"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "89.223.120.242"
  "REMOTE_PORT" => "38161"
  "REMOTE_ADDR" => "18.188.83.180"
  "SERVER_SOFTWARE" => "nginx/1.14.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/var/www/avtoshina_beta/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/promocodes/refresh"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => "2"
  "CONTENT_TYPE" => "application/json;charset=UTF-8"
  "REQUEST_METHOD" => "POST"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1745439977.1935
  "REQUEST_TIME" => 1745439977
]
            request_cookies
              0 of 0   
            array:2 [▶
  "XSRF-TOKEN" => null
  "laravel_session" => "NUiqIFuCCHUAyqK0T7v1jdC6hEEealokVTLpg8YR"
]
            response_headers
              0 of 0   
            array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 23 Apr 2025 20:26:17 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImFXN3FZblwvTHVrWloxUXRjQXpBa2ZBPT0iLCJ2YWx1ZSI6IjJPUFwvUWN4eElTRUg5MFgrdElHbFNYZEV2bVwvdEt4UUhBeGVYS1E5WTFmMFNcL3ZsR1RndXRCWCtDWWtSU3Q2R0IiLCJtYWMiOiJlZmRjMmYwZmI4ZTcyMGZmYjM0ZGM4ZDk3ZjEzNTJlYjYwODM2YTEzZGRhYjRhOWM4NDUzYTUzZWEwNzExODJhIn0%3D; expires=Wed, 23-Apr-2025 22:26:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImFXN3FZblwvTHVrWloxUXRjQXpBa2ZBPT0iLCJ2YWx1ZSI6IjJPUFwvUWN4eElTRUg5MFgrdElHbFNYZEV2bVwvdEt4UUhBeGVYS1E5WTFmMFNcL3ZsR1RndXRCWCtDWWtSU3Q2R0IiL ▶"
    1 => "laravel_session=eyJpdiI6ImtBRVJZUytYR0hHSzZvRmZtclV3bnc9PSIsInZhbHVlIjoiODEzUWJMdVRicXlPU0FEZ0VRbmVMWGFybmVnNU9JRVc2TldkYjRrNTNwUnFZakZmMFpxWlVGRkdUUVVHeGRCY2hEMis5MmRtbWpka0hJczFlXC9qNHJsK1NRU3VkK3dOdVlwVFpWbGN2Q1JTY09QdkQ1YktmK05nZFwvUFZqMmFtSyIsIm1hYyI6IjBjODFiYmVlZTU5ODBiMTZiYjA5NTY3ZDBjODQ5ZTYwNmU0MjA0Y2RkMTQwNzAyODQyZTUzNTlkZmMwMTEwZGIifQ%3D%3D; expires=Wed, 23-Apr-2025 22:26:17 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImtBRVJZUytYR0hHSzZvRmZtclV3bnc9PSIsInZhbHVlIjoiODEzUWJMdVRicXlPU0FEZ0VRbmVMWGFybmVnNU9JRVc2TldkYjRrNTNwUnFZakZmMFpxWlVGRkdUUVVHeGRCY2hE ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImFXN3FZblwvTHVrWloxUXRjQXpBa2ZBPT0iLCJ2YWx1ZSI6IjJPUFwvUWN4eElTRUg5MFgrdElHbFNYZEV2bVwvdEt4UUhBeGVYS1E5WTFmMFNcL3ZsR1RndXRCWCtDWWtSU3Q2R0IiLCJtYWMiOiJlZmRjMmYwZmI4ZTcyMGZmYjM0ZGM4ZDk3ZjEzNTJlYjYwODM2YTEzZGRhYjRhOWM4NDUzYTUzZWEwNzExODJhIn0%3D; expires=Wed, 23-Apr-2025 22:26:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImFXN3FZblwvTHVrWloxUXRjQXpBa2ZBPT0iLCJ2YWx1ZSI6IjJPUFwvUWN4eElTRUg5MFgrdElHbFNYZEV2bVwvdEt4UUhBeGVYS1E5WTFmMFNcL3ZsR1RndXRCWCtDWWtSU3Q2R0IiL ▶"
    1 => "laravel_session=eyJpdiI6ImtBRVJZUytYR0hHSzZvRmZtclV3bnc9PSIsInZhbHVlIjoiODEzUWJMdVRicXlPU0FEZ0VRbmVMWGFybmVnNU9JRVc2TldkYjRrNTNwUnFZakZmMFpxWlVGRkdUUVVHeGRCY2hEMis5MmRtbWpka0hJczFlXC9qNHJsK1NRU3VkK3dOdVlwVFpWbGN2Q1JTY09QdkQ1YktmK05nZFwvUFZqMmFtSyIsIm1hYyI6IjBjODFiYmVlZTU5ODBiMTZiYjA5NTY3ZDBjODQ5ZTYwNmU0MjA0Y2RkMTQwNzAyODQyZTUzNTlkZmMwMTEwZGIifQ%3D%3D; expires=Wed, 23-Apr-2025 22:26:17 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImtBRVJZUytYR0hHSzZvRmZtclV3bnc9PSIsInZhbHVlIjoiODEzUWJMdVRicXlPU0FEZ0VRbmVMWGFybmVnNU9JRVc2TldkYjRrNTNwUnFZakZmMFpxWlVGRkdUUVVHeGRCY2hE ▶"
  ]
]
            session_attributes
              0 of 0   
            array:4 [▶
  "_token" => "zAhSikVWS2BdvceBInLNbtgGBxgGCBh424C60rBO"
  "_previous" => array:1 [▶
    "url" => "https://dev.avtoshina34.ru/catalog/tyres/hankook/706743?page=5"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]