Электронная почта:
info@avtoshina34.ru
info@avtoshina34.ru
ПН - ПТ 09:00-18:00 СУББОТА 09:00-15:00
В нашем каталоге вы можете найти ABRO и купить в Волгограде в магазине Автошина 34 по адресу: . Чтобы узнать о проходящих акция и распродажах или узнать актуальную цену на ABRO свяжитесь с нашим менеджером по телефону: .
Введите свой номер и мы перезвоним Вам
Товар был добавлен в корзину. Вы можете продолжить покупки или перейти к оформлению заказа
Вы нашли этот товар дешевле? Расскажите об этом
Условия акции:
Необходимо предоставить ссылку на сайт с данным товаром и конкурент должен быть из
Волгограда.
Чтобы избежать томительного ожидания в очереди около шиномонтажа Вы можете предварительно записаться у нас. Менеджер свяжется с Вами и уточнит все детали.
| 1 x Application (51.25%) | 10.36ms |
| 1 x Booting (48.37%) | 9.78ms |
select * from `categories` where (`parent` = 1 and `tmp` = '0' and `visible` = 1) order by `categories`.`order` asc560μs/app/Models/Product/Category.php:158avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `car_manufacturers` order by `name` asc330μsmiddleware::client:22avtoshina_beta| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `seo_redirects` where `page_from` = 'promocodes/refresh' limit 1300μs/app/Models/Redirect.php:33avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `title`, `h1`, `description`, `keywords` from `seo` where `page_url` = 'promocodes/refresh' limit 1200μs/app/Models/Seo.php:36avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `id` from `suppliers` where `type` = 'store'150μs/app/Models/Product/Product.php:1323avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
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` = 'xRnGBm9svvsPv2wZfW9H8ZtkbwyzL228kaC86P7M' order by (SELECT quantity
FROM product_store
WHERE product_id = product.id AND supplier_id = 13
LIMIT 1)
DESC, `suppliers`.`type` desc710μs/app/Models/Cart.php:74avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:19 [▶ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFjM2YyYjhmNTFkMmVlNTA3MTRlZDU5N2U0YTIxZWJhNjNlZWYyMGRkNjUwNWQ1MjZlYmIyOWU0NzZiOTlhIn0%3D; laravel_session=eyJpdiI6IkFlMWZqRUhjSnlvbkFBcXFLRTFjXC9BPT0iLCJ2YWx1ZSI6IkRjMk10WjgzNk9pNFBZazl5c21BdGJNT2tpOXR6eTFvWkE5XC9nWWRVR3VtSVAzbGRvTmVXWUdyYmUwdDIyMWZydHJidTRVeXNKQ1BRdUxhYTgrc3hYQzFyOEJsdkYwa3FiUDhOblNWR2xCcHBJaklmODNGTVR1YlJkdEtSWVlkcSIsIm1hYyI6IjYyYWNhYWM2MjJmZjk3YjgwZDEyNWI1ODEwYmIyZmY3OTU1ZTljNDE4M2FjOTIwMjA2NmUwOGRlNjUyZWViMzEifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtY ▶" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "referer" => array:1 [▶ 0 => "https://dev.avtoshina34.ru/catalog/winter-tyres/cordiant/272666?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 => "eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFjM2YyYjhmNTFkMmVlNTA3MTRlZDU5N2U0YTIxZWJhNjNlZWYyMGRkNjUwNWQ1MjZlYmIyOWU0NzZiOTlhIn0= ◀eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFj ▶" ] "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" ] ]
0 of 0array:45 [▶ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFjM2YyYjhmNTFkMmVlNTA3MTRlZDU5N2U0YTIxZWJhNjNlZWYyMGRkNjUwNWQ1MjZlYmIyOWU0NzZiOTlhIn0%3D; laravel_session=eyJpdiI6IkFlMWZqRUhjSnlvbkFBcXFLRTFjXC9BPT0iLCJ2YWx1ZSI6IkRjMk10WjgzNk9pNFBZazl5c21BdGJNT2tpOXR6eTFvWkE5XC9nWWRVR3VtSVAzbGRvTmVXWUdyYmUwdDIyMWZydHJidTRVeXNKQ1BRdUxhYTgrc3hYQzFyOEJsdkYwa3FiUDhOblNWR2xCcHBJaklmODNGTVR1YlJkdEtSWVlkcSIsIm1hYyI6IjYyYWNhYWM2MjJmZjk3YjgwZDEyNWI1ODEwYmIyZmY3OTU1ZTljNDE4M2FjOTIwMjA2NmUwOGRlNjUyZWViMzEifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtY ▶" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_REFERER" => "https://dev.avtoshina34.ru/catalog/winter-tyres/cordiant/272666?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" => "eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFjM2YyYjhmNTFkMmVlNTA3MTRlZDU5N2U0YTIxZWJhNjNlZWYyMGRkNjUwNWQ1MjZlYmIyOWU0NzZiOTlhIn0= ◀eyJpdiI6IjJnTTZXV2l6SGNnTlcwMElcL3U5YnpnPT0iLCJ2YWx1ZSI6IkZ4NU16VnFLU3VEMk5HckptTGVuR2tuVEdGa1o1SFQydHExUEZBcmhFc3d0QXRkbFAzTGFrTDJqdVRIaXlYS20iLCJtYWMiOiJjMmFj ▶" "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" => "1701" "REMOTE_ADDR" => "18.191.255.240" "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" => 1744313155.4406 "REQUEST_TIME" => 1744313155 ]
0 of 0array:2 [▶ "XSRF-TOKEN" => null "laravel_session" => "xRnGBm9svvsPv2wZfW9H8ZtkbwyzL228kaC86P7M" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 10 Apr 2025 19:25:55 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImRkMFwvU29RWFdKSGl2N1ZZQ1lQV2t3PT0iLCJ2YWx1ZSI6IllhcjlNYzdLUGFTa3JCS1NOKzluemtsaW85YlhQUStcL0RwT010NG1jN0JyQ1BGaGMrSmM3NWlnRHFsc0ljUzRjIiwibWFjIjoiMzNhODVhZTEwNjZjYmJjNTMwOTMwNzc3ZDhlZGZjMGE1ZjBlZDdhYzU2ZTEwYTVmODU0ZmUwZjI4ODUwZmI2ZCJ9; expires=Thu, 10-Apr-2025 21:25:55 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImRkMFwvU29RWFdKSGl2N1ZZQ1lQV2t3PT0iLCJ2YWx1ZSI6IllhcjlNYzdLUGFTa3JCS1NOKzluemtsaW85YlhQUStcL0RwT010NG1jN0JyQ1BGaGMrSmM3NWlnRHFsc0ljUzRjIiwib ▶" 1 => "laravel_session=eyJpdiI6IkVOYnU5c2V3b0hPTnZNa2lGRWQxR1E9PSIsInZhbHVlIjoia3VhQnhSNncrQWtlNHh6RUVqR3h6YVwvSmR3bzBINzlwN3BZRmpNS283MW8zWWoraElqZzBGa1krNVBkM3UwQWIydXlmOFJ3dzk5WE5LdVwvdWJmYkU5Vk83bEIyTE9uaU81MmNcL1V4Z3lzMEtlOE1sWVZXRVpySXJIMVwvTkhlU3hjIiwibWFjIjoiZDYzNDFlMmJiMmI4YWZkOTU5ZmMyM2IzNWMzMTViY2Q0MDFjNzc0ZjViZjRiM2QwMzAwYjk4ZmY2YTU0NTk5NSJ9; expires=Thu, 10-Apr-2025 21:25:55 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6IkVOYnU5c2V3b0hPTnZNa2lGRWQxR1E9PSIsInZhbHVlIjoia3VhQnhSNncrQWtlNHh6RUVqR3h6YVwvSmR3bzBINzlwN3BZRmpNS283MW8zWWoraElqZzBGa1krNVBkM3UwQWIy ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImRkMFwvU29RWFdKSGl2N1ZZQ1lQV2t3PT0iLCJ2YWx1ZSI6IllhcjlNYzdLUGFTa3JCS1NOKzluemtsaW85YlhQUStcL0RwT010NG1jN0JyQ1BGaGMrSmM3NWlnRHFsc0ljUzRjIiwibWFjIjoiMzNhODVhZTEwNjZjYmJjNTMwOTMwNzc3ZDhlZGZjMGE1ZjBlZDdhYzU2ZTEwYTVmODU0ZmUwZjI4ODUwZmI2ZCJ9; expires=Thu, 10-Apr-2025 21:25:55 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImRkMFwvU29RWFdKSGl2N1ZZQ1lQV2t3PT0iLCJ2YWx1ZSI6IllhcjlNYzdLUGFTa3JCS1NOKzluemtsaW85YlhQUStcL0RwT010NG1jN0JyQ1BGaGMrSmM3NWlnRHFsc0ljUzRjIiwib ▶" 1 => "laravel_session=eyJpdiI6IkVOYnU5c2V3b0hPTnZNa2lGRWQxR1E9PSIsInZhbHVlIjoia3VhQnhSNncrQWtlNHh6RUVqR3h6YVwvSmR3bzBINzlwN3BZRmpNS283MW8zWWoraElqZzBGa1krNVBkM3UwQWIydXlmOFJ3dzk5WE5LdVwvdWJmYkU5Vk83bEIyTE9uaU81MmNcL1V4Z3lzMEtlOE1sWVZXRVpySXJIMVwvTkhlU3hjIiwibWFjIjoiZDYzNDFlMmJiMmI4YWZkOTU5ZmMyM2IzNWMzMTViY2Q0MDFjNzc0ZjViZjRiM2QwMzAwYjk4ZmY2YTU0NTk5NSJ9; expires=Thu, 10-Apr-2025 21:25:55 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IkVOYnU5c2V3b0hPTnZNa2lGRWQxR1E9PSIsInZhbHVlIjoia3VhQnhSNncrQWtlNHh6RUVqR3h6YVwvSmR3bzBINzlwN3BZRmpNS283MW8zWWoraElqZzBGa1krNVBkM3UwQWIy ▶" ] ]
0 of 0array:4 [▶ "_token" => "o7AzRCtodMMphi1Myder4m7aLynhiTIVzhSIyQva" "_previous" => array:1 [▶ "url" => "https://dev.avtoshina34.ru/catalog/winter-tyres/bobrujsk/413591?page=1" ] "PHPDEBUGBAR_STACK_DATA" => [] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]