Электронная почта:
info@avtoshina34.ru
info@avtoshina34.ru
ПН - ПТ 09:00-18:00 СУББОТА 09:00-15:00
35% скидка на шиномонтаж шин, приобретенных у нас.
Под заказ: 4
Терминал доступный
При оплате картой взимается комиссия 1%
| Ширина: | 7.5 |
| Диаметр: | 17 |
| DIA | 57.1 |
| Вылет ET | 40-50 |
| PCD | 112x5 |
| Тип диска | Легкосплавный |
Replay SK138 7.50x17.00 5/112.00 ET40-50 d57.10
Replay SK203 7.50x17.00 5/112.00 ET40-50 d57.10
Replay SK207 7.50x17.00 5/112.00 ET40-50 d57.10
Введите свой номер и мы перезвоним Вам
Товар был добавлен в корзину. Вы можете продолжить покупки или перейти к оформлению заказа
Вы нашли этот товар дешевле? Расскажите об этом
Условия акции:
Необходимо предоставить ссылку на сайт с данным товаром и конкурент должен быть из
Волгограда.
Чтобы избежать томительного ожидания в очереди около шиномонтажа Вы можете предварительно записаться у нас. Менеджер свяжется с Вами и уточнит все детали.
| 1 x Application (97.4%) | 437.74ms |
| 1 x Booting (2.57%) | 11.54ms |
| Params | |
|---|---|
| 0 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
select * from `categories` where (`parent` = 1 and `tmp` = '0' and `visible` = 1) order by `categories`.`order` asc1.49ms/app/Models/Product/Category.php:158avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `car_manufacturers` order by `name` asc430μsmiddleware::client:22avtoshina_beta| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `seo_redirects` where `page_from` = 'catalog/getPromoBlock' limit 1380μs/app/Models/Redirect.php:33avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `title`, `h1`, `description`, `keywords` from `seo` where `page_url` = 'catalog/getPromoBlock' limit 1230μs/app/Models/Seo.php:36avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `id` from `suppliers` where `type` = 'store'260μs/app/Models/Product/Product.php:1323avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where `id` = '633099' limit 1680μs/app/Models/Product/Product.php:1240avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `wheels` where `product_id` = '633099' limit 1450μs/app/Models/Product/Product.php:1260avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| 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` 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 `wheels` on `product`.`id` = `wheels`.`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 `wheels`.`width` = 7.5 and `wheels`.`diameter` = 17 and `wheels`.`ET` = '40-50' and `wheels`.`DIA` = 57.1 and `wheels`.`pcd` = 5 and `wheels`.`pcd_x` = 112880μs/app/Models/Product/Product.php:1269avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| 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` 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 `wheels` on `product`.`id` = `wheels`.`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 `wheels`.`width` = 7.5 and `wheels`.`diameter` = 17 and `wheels`.`ET` = '40-50' and `wheels`.`DIA` = 57.1 and `wheels`.`pcd` = 5 and `wheels`.`pcd_x` = 112 and `product`.`id` <> '633099' limit 5191ms/app/Models/Product/Product.php:1295avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `product_images` where `product_id` in (621653, 626701, 626704, 633386, 633388)2.36ms/app/Libraries/ProductHelper.php:30avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 621653) limit 1340μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (621653)510μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)280μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'220μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 626701) limit 1200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (626701)180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)390μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'210μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'170μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 626704) limit 1220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (626704)390μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'1.05ms/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'1.37ms/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 633386) limit 1270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (633386)200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)260μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'520μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 633388) limit 1270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (633388)270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)280μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'170μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (621653, 626701, 626704, 633386, 633388) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc450μs/app/Libraries/ProductHelper.php:93avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 621653 order by `suppliers`.`type` desc310μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS518383' and `supplier_id` = 5) and `quantity` > 0 limit 1370μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 621653 and `supplier_id` = 5)180μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS518383' and `supplier_id` = 11) and `quantity` > 0 limit 1150μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 626701 order by `suppliers`.`type` desc180μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS510010' and `supplier_id` = 5) and `quantity` > 0 limit 1270μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 626701 and `supplier_id` = 5)150μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS510010' and `supplier_id` = 11) and `quantity` > 0 limit 1170μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 626704 order by `suppliers`.`type` desc320μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS510014' and `supplier_id` = 5) and `quantity` > 0 limit 1140μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 626704 and `supplier_id` = 5)120μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS510014' and `supplier_id` = 11) and `quantity` > 0 limit 1120μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 633386 order by `suppliers`.`type` desc240μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS205723' and `supplier_id` = 5) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 633386 and `supplier_id` = 5)130μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS205723' and `supplier_id` = 11) and `quantity` > 0 limit 1170μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 633386 and `supplier_id` = 11)200μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 633388 order by `suppliers`.`type` desc220μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS114277' and `supplier_id` = 5) and `quantity` > 0 limit 1150μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 633388 and `supplier_id` = 5)140μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS114277' and `supplier_id` = 11) and `quantity` > 0 limit 1180μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 633388 and `supplier_id` = 11)130μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (11, 11, 11, 13, 14)170μs/app/Libraries/ProductHelper.php:117avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `suppliers` where `type` = 'store'140μs/app/Models/Product/Product.php:1323avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select distinct `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` 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` left join `product_images` on `product`.`id` = `product_images`.`product_id` left join `product_redprice` on `product`.`id` = `product_redprice`.`product_id` left join `product_store` on `product`.`id` = `product_store`.`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 (`product_store`.`discount_price` > 0 and `product_store`.`price` > `product_store`.`discount_price` or `product`.`id` = `product_redprice`.`product_id` and `store`.`supplier_id` = `product_redprice`.`supplier_id`) limit 15770μs/app/Models/Product/Product.php:1197avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `product_images` where `product_id` in (8002, 8120, 357335, 422430, 422442, 422786, 422881, 490215, 490216, 522597, 522598, 522910, 522921, 524218, 524224)180μs/app/Libraries/ProductHelper.php:30avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 8002) limit 1200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (8002)290μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (39, 42)440μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'260μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'290μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 8120) limit 1180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (8120)220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'280μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'170μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 357335) limit 1340μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (357335)640μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'300μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 422430) limit 1190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422430)230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)260μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'150μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'200μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 422442) limit 1330μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422442)230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)350μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'190μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 422786) limit 1190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422786)190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)330μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'170μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'400μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 422881) limit 1230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (422881)200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'280μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'230μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 490215) limit 1390μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (490215)200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (39, 42)570μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'170μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'180μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 490216) limit 1170μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (490216)200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'160μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'260μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 522597) limit 1180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522597)180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'170μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'210μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 522598) limit 1190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522598)180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)210μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'150μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'170μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 522910) limit 1170μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522910)180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)300μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'190μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 522921) limit 1210μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (522921)190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)290μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'410μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 524218) limit 1230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (524218)180μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'140μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'380μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 524224) limit 1240μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (524224)270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (42)290μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (3) and `images`.`imageable_type` = 'App\Models\PromoTag'230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:19' and `to` >= '2025-05-31 02:47:19'230μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (8002, 8120, 357335, 422430, 422442, 422786, 422881, 490215, 490216, 522597, 522598, 522910, 522921, 524218, 524224) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc440μs/app/Libraries/ProductHelper.php:93avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 8002 order by `suppliers`.`type` desc290μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tz-2030' and `supplier_id` = 13) and `quantity` > 0 limit 1180μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 8002 and `supplier_id` = 13)220μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 8120 order by `suppliers`.`type` desc170μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-0435' and `supplier_id` = 13) and `quantity` > 0 limit 1260μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 8120 and `supplier_id` = 13)140μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 357335 order by `suppliers`.`type` desc400μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-40020' and `supplier_id` = 13) and `quantity` > 0 limit 1190μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-40020' and `supplier_id` = 12) and `quantity` > 0 limit 1140μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 357335 and `supplier_id` = 12)180μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS209646' and `supplier_id` = 5) and `quantity` > 0 limit 1460μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS209646' and `supplier_id` = 11) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422430 order by `suppliers`.`type` desc290μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221916' and `supplier_id` = 5) and `quantity` > 0 limit 1210μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 5)300μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221916' and `supplier_id` = 11) and `quantity` > 0 limit 1330μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 11)410μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '000000571' and `supplier_id` = 4) and `quantity` > 0 limit 11.33ms/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422430 and `supplier_id` = 4)350μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422442 order by `suppliers`.`type` desc260μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221899' and `supplier_id` = 5) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '980860' and `supplier_id` = 10) and `quantity` > 0 limit 1160μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221899' and `supplier_id` = 11) and `quantity` > 0 limit 1170μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422442 and `supplier_id` = 11)160μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '137556' and `supplier_id` = 9) and `quantity` > 0 limit 1190μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422786 order by `suppliers`.`type` desc240μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221893' and `supplier_id` = 5) and `quantity` > 0 limit 1530μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422786 and `supplier_id` = 5)250μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221893' and `supplier_id` = 11) and `quantity` > 0 limit 1250μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422786 and `supplier_id` = 11)340μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 422881 order by `suppliers`.`type` desc430μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221898' and `supplier_id` = 5) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS221898' and `supplier_id` = 11) and `quantity` > 0 limit 1240μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 422881 and `supplier_id` = 11)200μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 490215 order by `suppliers`.`type` desc240μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-X40927' and `supplier_id` = 13) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 490215 and `supplier_id` = 13)180μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '000088351' and `supplier_id` = 4) and `quantity` > 0 limit 1190μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 490216 order by `suppliers`.`type` desc220μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-8667' and `supplier_id` = 13) and `quantity` > 0 limit 1210μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 490216 and `supplier_id` = 13)190μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522597 order by `suppliers`.`type` desc230μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500776' and `supplier_id` = 5) and `quantity` > 0 limit 1190μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500776' and `supplier_id` = 11) and `quantity` > 0 limit 1200μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522597 and `supplier_id` = 11)210μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522598 order by `suppliers`.`type` desc320μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00014836' and `supplier_id` = 4) and `quantity` > 0 limit 1220μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 4)190μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '81121' and `supplier_id` = 2) and `quantity` > 0 limit 1310μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 2)210μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS503030' and `supplier_id` = 5) and `quantity` > 0 limit 1260μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 5)170μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS503030' and `supplier_id` = 11) and `quantity` > 0 limit 1210μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522598 and `supplier_id` = 11)250μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522910 order by `suppliers`.`type` desc220μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-7368' and `supplier_id` = 13) and `quantity` > 0 limit 1210μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522910 and `supplier_id` = 13)300μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00007200' and `supplier_id` = 4) and `quantity` > 0 limit 1260μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522910 and `supplier_id` = 4)170μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS083584' and `supplier_id` = 5) and `quantity` > 0 limit 1260μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS083584' and `supplier_id` = 11) and `quantity` > 0 limit 1150μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 522921 order by `suppliers`.`type` desc190μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS229143' and `supplier_id` = 5) and `quantity` > 0 limit 1150μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522921 and `supplier_id` = 5)500μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS229143' and `supplier_id` = 11) and `quantity` > 0 limit 1380μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 522921 and `supplier_id` = 11)190μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 524218 order by `suppliers`.`type` desc230μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-53A35D' and `supplier_id` = 12) and `quantity` > 0 limit 1180μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 524218 and `supplier_id` = 12)150μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'tr-53A35D' and `supplier_id` = 13) and `quantity` > 0 limit 1380μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 524218 and `supplier_id` = 13)310μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS212829' and `supplier_id` = 5) and `quantity` > 0 limit 1270μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS212829' and `supplier_id` = 11) and `quantity` > 0 limit 1510μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '000084078' and `supplier_id` = 4) and `quantity` > 0 limit 1490μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 524218 and `supplier_id` = 4)270μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '84470' and `supplier_id` = 2) and `quantity` > 0 limit 1300μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 524218 and `supplier_id` = 2)320μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '838852' and `supplier_id` = 10) and `quantity` > 0 limit 1250μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '87811325436' and `supplier_id` = 8) and `quantity` > 0 limit 1270μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 524224 order by `suppliers`.`type` desc230μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500128' and `supplier_id` = 5) and `quantity` > 0 limit 1330μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 524224 and `supplier_id` = 5)270μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'WHS500128' and `supplier_id` = 11) and `quantity` > 0 limit 1230μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (21, 255, 23, 21, 21, 21, 21, 23, 23, 21, 21, 23, 23, 23, 23)270μs/app/Libraries/ProductHelper.php:117avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `suppliers` where `type` = 'store'260μ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` 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 `product_to_promo` on `product`.`id` = `product_to_promo`.`product_id` inner join `promo_tags` on `product_to_promo`.`tag_id` = `promo_tags`.`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 `promo_tags`.`code` = 'profit' order by `product`.`profit_order` desc, `product_to_promo`.`created_at` desc limit 51.14ms/app/Models/Product/Product.php:1226avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` in (15416, 540869, 631111, 520524, 721236)330μs/app/Libraries/ProductHelper.php:30avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `season` from `tyres` where `product_id` in (15416, 540869, 631111, 520524, 721236)260μs/app/Libraries/ProductHelper.php:33avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `product_id`, `model`, `width`, `height`, `diameter`, `speed_index`, `is_spike` from `tyres` where `product_id` in (15416, 540869, 631111, 520524, 721236)240μs/app/Libraries/ProductHelper.php:36avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `products` where (`id` = 15416) limit 1190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (15416)220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)1.23ms/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'470μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'540μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 540869) limit 1280μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (540869)370μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)1.13ms/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'470μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'230μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 631111) limit 1260μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (631111)250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)1.03ms/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'320μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 520524) limit 1250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (520524)250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)1.27ms/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'240μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'330μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 721236) limit 1240μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (721236)440μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (37, 38, 39, 44)630μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (2, 8, 11, 12) and `images`.`imageable_type` = 'App\Models\PromoTag'210μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'310μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (15416, 540869, 631111, 520524, 721236) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc400μs/app/Libraries/ProductHelper.php:93avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 15416 order by `suppliers`.`type` desc340μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '69898' and `supplier_id` = 2) and `quantity` > 0 limit 1220μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '821014' and `supplier_id` = 10) and `quantity` > 0 limit 1200μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '15445' and `supplier_id` = 1) and `quantity` > 0 limit 1270μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'УТ-00003166' and `supplier_id` = 9) and `quantity` > 0 limit 1160μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS32252' and `supplier_id` = 11) and `quantity` > 0 limit 1280μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 15416 and `supplier_id` = 11)280μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 540869 order by `suppliers`.`type` desc350μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00025485' and `supplier_id` = 4) and `quantity` > 0 limit 1240μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 540869 and `supplier_id` = 4)270μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 631111 order by `suppliers`.`type` desc350μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS72291' and `supplier_id` = 5) and `quantity` > 0 limit 1280μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'НФ-00029916' and `supplier_id` = 4) and `quantity` > 0 limit 1290μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 631111 and `supplier_id` = 4)210μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 520524 order by `suppliers`.`type` desc290μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '24773' and `supplier_id` = 1) and `quantity` > 0 limit 1300μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '1514527' and `supplier_id` = 10) and `quantity` > 0 limit 1210μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'TS82562' and `supplier_id` = 11) and `quantity` > 0 limit 1200μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 520524 and `supplier_id` = 11)210μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 721236 order by `suppliers`.`type` desc260μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'УТ-00013601' and `supplier_id` = 9) and `quantity` > 0 limit 1190μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 721236 and `supplier_id` = 9)150μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = '69884' and `supplier_id` = 2) and `quantity` > 0 limit 1180μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (64, 64, 64, 64, 64)330μs/app/Libraries/ProductHelper.php:117avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `id` from `suppliers` where `type` = 'store'280μ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` 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 `product_to_promo` on `product`.`id` = `product_to_promo`.`product_id` inner join `promo_tags` on `product_to_promo`.`tag_id` = `promo_tags`.`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 `promo_tags`.`code` = 'recommend' order by `product`.`recommend_order` desc, `product_to_promo`.`created_at` desc limit 5880μs/app/Models/Product/Product.php:1226avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `product_images` where `product_id` in (774840, 774839, 774838, 774837, 774836)270μs/app/Libraries/ProductHelper.php:30avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `categories` where `id` = 7 limit 1560μs/app/Models/Product/Category.php:203avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 774840) limit 1350μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774840)310μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)330μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'290μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'340μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `categories` where `id` = 7 limit 1240μs/app/Models/Product/Category.php:203avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 774839) limit 1240μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774839)220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'360μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'230μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `categories` where `id` = 7 limit 1350μs/app/Models/Product/Category.php:203avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 774838) limit 1220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774838)240μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)420μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'190μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'220μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `categories` where `id` = 7 limit 1220μs/app/Models/Product/Category.php:203avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 774837) limit 1230μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774837)310μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)530μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'250μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'430μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `categories` where `id` = 7 limit 1330μs/app/Models/Product/Category.php:203avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `products` where (`id` = 774836) limit 1220μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `promo_tags`.*, `product_to_promo`.`product_id` from `promo_tags` inner join `product_to_promo` on `product_to_promo`.`tag_id` = `promo_tags`.`id` where `product_to_promo`.`product_id` in (774836)490μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `site_content` where `site_content`.`id` in (43)270μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `images` where `images`.`imageable_id` in (1) and `images`.`imageable_type` = 'App\Models\PromoTag'200μs/app/Libraries/ProductHelper.php:63avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `promocodes` where `activity` = 1 and `used_times` > 0 and `from` <= '2025-05-31 02:47:20' and `to` >= '2025-05-31 02:47:20'170μs/app/Models/Promocode.php:100avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `product_store`.`product_id`, `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`days` as `days`, CASE
WHEN product_redprice.discount IS NOT NULL
THEN
FLOOR((product_store.price * (100 - product_redprice.discount) / 100) / 10) * 10
ELSE
product_store.price
END AS minprice from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` left join `product_redprice` on `product_store`.`product_id` = `product_redprice`.`product_id` and `product_store`.`supplier_id` = `product_redprice`.`supplier_id` where `product_store`.`product_id` in (774840, 774839, 774838, 774837, 774836) and `product_store`.`quantity` > 0 and `product_store`.`price` > 0 order by `minprice` asc400μs/app/Libraries/ProductHelper.php:93avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774840 order by `suppliers`.`type` desc240μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0799' and `supplier_id` = 12) and `quantity` > 0 limit 1240μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774840 and `supplier_id` = 12)260μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774839 order by `suppliers`.`type` desc220μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0589' and `supplier_id` = 12) and `quantity` > 0 limit 1170μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774839 and `supplier_id` = 12)150μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774838 order by `suppliers`.`type` desc200μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0588' and `supplier_id` = 12) and `quantity` > 0 limit 1170μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774838 and `supplier_id` = 12)290μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774837 order by `suppliers`.`type` desc310μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-1815' and `supplier_id` = 12) and `quantity` > 0 limit 1220μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774837 and `supplier_id` = 12)160μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_store`.`id`, `product_store`.`code`, `product_store`.`price`, `product_store`.`discount_price`, `product_store`.`quantity`, `product_store`.`supplier_id`, `suppliers`.`type`, `suppliers`.`name` as `supplier_name`, `suppliers`.`type` as `type`, `suppliers`.`self_delivery_point_id` as `sdp_id` from `product_store` inner join `suppliers` on `product_store`.`supplier_id` = `suppliers`.`id` where `product_id` = 774836 order by `suppliers`.`type` desc190μs/app/Models/Product/ProductStore.php:51avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `product_id`, `supplier_id`, `price`, `discount_price` from `product_store` where (`code` = 'zo-0401' and `supplier_id` = 12) and `quantity` > 0 limit 1250μs/app/Models/Product/ProductStore.php:172avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `discount` from `product_redprice` where (`product_id` = 774836 and `supplier_id` = 12)170μs/app/Models/Product/ProductStore.php:178avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `path`, `manufacturer_id` from `manufacturer_images` where `manufacturer_images`.`manufacturer_id` in (443, 443, 443, 443, 443)350μs/app/Libraries/ProductHelper.php:117avtoshina_beta| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
200
0 of 0array:1 [▶ "id" => "633099" ]
0 of 0array:1 [▶ "id" => "633099" ]
0 of 0array:19 [▶ "cookie" => array:1 [▶ 0 => "self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu0438%5Cu043c.+%5Cu041c%5Cu0435%5Cu043d%5Cu0434%5Cu0435%5Cu043b%5Cu0435%5Cu0435%5Cu0432%5Cu0430%2C+51%22%7D%2C%7B%22id%22%3A13%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu041d.+%5Cu041a%5Cu0438%5Cu0431%5Cu0430%5Cu043b%5Cu044c%5Cu0447%5Cu0438%5Cu0447%5Cu0430%2C+18%22%7D%5D%2C%22pickup%22%3A%5B%7B%22id%22%3A15%2C%22address%22%3A%22%5Cu0433.+%5Cu0421%5Cu0443%5Cu0440%5Cu043e%5Cu0432%5Cu0438%5Cu043a%5Cu0438%5Cu043d%5Cu043e%2C+%5Cu0443%5Cu043b.+%5Cu0428%5Cu043e%5Cu0441%5Cu0441%5Cu0435%5Cu0439%5Cu043d%5Cu0430%5Cu044f%2C+37%5C%2F1%22%7D%2C%7B%22id%22%3A16%2C%22address%22%3A%22%5Cu0433.+%5Cu041c%5Cu043e%5Cu0441%5Cu043a%5Cu0432%5Cu0430%2C+%5Cu0443%5Cu043b.+%5Cu041f%5Cu043b%5Cu043e%5Cu0449%5Cu0430%5Cu0434%5Cu044c+%5Cu041f%5Cu043e%5Cu0431%5Cu0435%5Cu0434%5Cu044b%2C+1+%5Cu043a%5Cu0415%22%7D%5D%7D; self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu0438%5Cu043c.+%5Cu041c%5Cu0435%5Cu043d%5Cu0434%5Cu0435%5Cu043b%5Cu0435%5Cu0435%5Cu0432%5Cu0430%2C+51%22%7D%2C%7B%22id%22%3A13%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu041d.+%5Cu041a%5Cu0438%5Cu0431%5Cu0430%5Cu043b%5Cu044c%5Cu0447%5Cu0438%5Cu0447%5Cu0430%2C+18%22%7D%5D%2C%22pickup%22%3A%5B%7B%22id%22%3A15%2C%22address%22%3A%22%5Cu0433.+%5Cu0421%5Cu0443%5Cu0440%5Cu043e%5Cu0432%5Cu0438%5Cu043a%5Cu0438%5Cu043d%5Cu043e%2C+%5Cu0443%5Cu043b.+%5Cu0428%5Cu043e%5Cu0441%5Cu0441%5Cu0435%5Cu0439%5Cu043d%5Cu0430%5Cu044f%2C+37%5C%2F1%22%7D%2C%7B%22id%22%3A16%2C%22address%22%3A%22%5Cu0433.+%5Cu041c%5Cu043e%5Cu0441%5Cu043a%5Cu0432%5Cu0430%2C+%5Cu0443%5Cu043b.+%5Cu041f%5Cu043b%5Cu043e%5Cu0449%5Cu0430%5Cu0434%5Cu044c+%5Cu041f%5Cu043e%5Cu0431%5Cu0435%5Cu0434%5Cu044b%2C+1+%5Cu043a%5Cu0415%22%7D%5D%7D; XSRF-TOKEN=eyJpdiI6Ikd3XC84aTlleU0wT0JVQVwvZWxMWFVHUT09IiwidmFsdWUiOiIzUkxxMzNXQW81U3VXaU1nXC9ablpkSUxrQjJyT2JpU0pBeHVXZ3hwaDgrQ2tOc1g4TDg3S05ncUl6WVRWNUNMbCIsIm1hYyI6Ijg4MzJjZjRjYmYyYTI5ZjcyYWQxMmM4NjdjYWVmYzAzODgwNjRkZmE3NDhjMzRkOWFkODcwYTIyYmRkYTlkY2EifQ%3D%3D; laravel_session=eyJpdiI6InNwYWFDS1NWRGpnV0RyV0IzbmIyaEE9PSIsInZhbHVlIjoiNUFUZVYzV0pJTEQ0WEE4a0xJZHlCOW1ucGh3VDYyR2lBVWh2UVU1ak1nMWVaV25ibGtNWnJFczNMdkw1RzM0RnEyem1RcTVXRkFRNHdhZXRLSFl4aUN4QTJDVUtsR2hjNlA5UWpwVHBGNWg1TVNtWkpHSXp1M2wyRU95WWZMeDgiLCJtYWMiOiIyNmZjZWRkYTI0ZTVlOGE4ZDEzMjhkYWM2YzlkZTQ2MTkzZjA0NmYwNGJkZDRmM2M3NTcyZDMzY2ZmYmI0MWQ2In0%3D ◀self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu04 ▶" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "referer" => array:1 [▶ 0 => "https://dev.avtoshina34.ru/catalog/wheels/k-i-k/633099?page=31" ] "sec-fetch-dest" => array:1 [▶ 0 => "empty" ] "sec-fetch-mode" => array:1 [▶ 0 => "cors" ] "sec-fetch-site" => array:1 [▶ 0 => "same-origin" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "accept" => array:1 [▶ 0 => "text/html, */*; q=0.01" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "x-requested-with" => array:1 [▶ 0 => "XMLHttpRequest" ] "x-csrf-token" => array:1 [▶ 0 => "OgfN7bbC5g8Bh4KS1BYhtJ5n1cczxWPiw6lowD8C" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "dev.avtoshina34.ru" ] "content-length" => array:1 [▶ 0 => "" ] "content-type" => array:1 [▶ 0 => "" ] ]
0 of 0array:43 [▶ "USER" => "www-data" "HOME" => "/var/www" "HTTP_COOKIE" => "self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu0438%5Cu043c.+%5Cu041c%5Cu0435%5Cu043d%5Cu0434%5Cu0435%5Cu043b%5Cu0435%5Cu0435%5Cu0432%5Cu0430%2C+51%22%7D%2C%7B%22id%22%3A13%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu041d.+%5Cu041a%5Cu0438%5Cu0431%5Cu0430%5Cu043b%5Cu044c%5Cu0447%5Cu0438%5Cu0447%5Cu0430%2C+18%22%7D%5D%2C%22pickup%22%3A%5B%7B%22id%22%3A15%2C%22address%22%3A%22%5Cu0433.+%5Cu0421%5Cu0443%5Cu0440%5Cu043e%5Cu0432%5Cu0438%5Cu043a%5Cu0438%5Cu043d%5Cu043e%2C+%5Cu0443%5Cu043b.+%5Cu0428%5Cu043e%5Cu0441%5Cu0441%5Cu0435%5Cu0439%5Cu043d%5Cu0430%5Cu044f%2C+37%5C%2F1%22%7D%2C%7B%22id%22%3A16%2C%22address%22%3A%22%5Cu0433.+%5Cu041c%5Cu043e%5Cu0441%5Cu043a%5Cu0432%5Cu0430%2C+%5Cu0443%5Cu043b.+%5Cu041f%5Cu043b%5Cu043e%5Cu0449%5Cu0430%5Cu0434%5Cu044c+%5Cu041f%5Cu043e%5Cu0431%5Cu0435%5Cu0434%5Cu044b%2C+1+%5Cu043a%5Cu0415%22%7D%5D%7D; self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu0438%5Cu043c.+%5Cu041c%5Cu0435%5Cu043d%5Cu0434%5Cu0435%5Cu043b%5Cu0435%5Cu0435%5Cu0432%5Cu0430%2C+51%22%7D%2C%7B%22id%22%3A13%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu0434%2C+%5Cu0443%5Cu043b.+%5Cu041d.+%5Cu041a%5Cu0438%5Cu0431%5Cu0430%5Cu043b%5Cu044c%5Cu0447%5Cu0438%5Cu0447%5Cu0430%2C+18%22%7D%5D%2C%22pickup%22%3A%5B%7B%22id%22%3A15%2C%22address%22%3A%22%5Cu0433.+%5Cu0421%5Cu0443%5Cu0440%5Cu043e%5Cu0432%5Cu0438%5Cu043a%5Cu0438%5Cu043d%5Cu043e%2C+%5Cu0443%5Cu043b.+%5Cu0428%5Cu043e%5Cu0441%5Cu0441%5Cu0435%5Cu0439%5Cu043d%5Cu0430%5Cu044f%2C+37%5C%2F1%22%7D%2C%7B%22id%22%3A16%2C%22address%22%3A%22%5Cu0433.+%5Cu041c%5Cu043e%5Cu0441%5Cu043a%5Cu0432%5Cu0430%2C+%5Cu0443%5Cu043b.+%5Cu041f%5Cu043b%5Cu043e%5Cu0449%5Cu0430%5Cu0434%5Cu044c+%5Cu041f%5Cu043e%5Cu0431%5Cu0435%5Cu0434%5Cu044b%2C+1+%5Cu043a%5Cu0415%22%7D%5D%7D; XSRF-TOKEN=eyJpdiI6Ikd3XC84aTlleU0wT0JVQVwvZWxMWFVHUT09IiwidmFsdWUiOiIzUkxxMzNXQW81U3VXaU1nXC9ablpkSUxrQjJyT2JpU0pBeHVXZ3hwaDgrQ2tOc1g4TDg3S05ncUl6WVRWNUNMbCIsIm1hYyI6Ijg4MzJjZjRjYmYyYTI5ZjcyYWQxMmM4NjdjYWVmYzAzODgwNjRkZmE3NDhjMzRkOWFkODcwYTIyYmRkYTlkY2EifQ%3D%3D; laravel_session=eyJpdiI6InNwYWFDS1NWRGpnV0RyV0IzbmIyaEE9PSIsInZhbHVlIjoiNUFUZVYzV0pJTEQ0WEE4a0xJZHlCOW1ucGh3VDYyR2lBVWh2UVU1ak1nMWVaV25ibGtNWnJFczNMdkw1RzM0RnEyem1RcTVXRkFRNHdhZXRLSFl4aUN4QTJDVUtsR2hjNlA5UWpwVHBGNWg1TVNtWkpHSXp1M2wyRU95WWZMeDgiLCJtYWMiOiIyNmZjZWRkYTI0ZTVlOGE4ZDEzMjhkYWM2YzlkZTQ2MTkzZjA0NmYwNGJkZDRmM2M3NTcyZDMzY2ZmYmI0MWQ2In0%3D ◀self_delivery_points=%7B%22stores%22%3A%5B%7B%22id%22%3A12%2C%22address%22%3A%22%5Cu0433.+%5Cu0412%5Cu043e%5Cu043b%5Cu0433%5Cu043e%5Cu0433%5Cu0440%5Cu0430%5Cu04 ▶" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_REFERER" => "https://dev.avtoshina34.ru/catalog/wheels/k-i-k/633099?page=31" "HTTP_SEC_FETCH_DEST" => "empty" "HTTP_SEC_FETCH_MODE" => "cors" "HTTP_SEC_FETCH_SITE" => "same-origin" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_ACCEPT" => "text/html, */*; q=0.01" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_X_REQUESTED_WITH" => "XMLHttpRequest" "HTTP_X_CSRF_TOKEN" => "OgfN7bbC5g8Bh4KS1BYhtJ5n1cczxWPiw6lowD8C" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "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" => "59942" "REMOTE_ADDR" => "18.217.226.1" "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" => "/catalog/getPromoBlock?id=633099" "SCRIPT_NAME" => "/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "id=633099" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1748648839.6908 "REQUEST_TIME" => 1748648839 ]
0 of 0array:3 [▶ "self_delivery_points" => null "XSRF-TOKEN" => null "laravel_session" => "j7Y1vymxxignImGBZANrzdV3WQA1T9Hj66fYU67V" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 30 May 2025 23:47:20 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxZRndwMmhCeE5wMXJ3ZDlPVE1zWmc9PSIsInZhbHVlIjoiWTN5ZndLZkJrTnZIVnpMM21QNUFJa2tMWldZYWhhQ3hPeWt0ZkxOSWh2RVwvMnViYU80SytXZ1RjQ1dOTnVwV0giLCJtYWMiOiJkZGM5YWYyZjQ1MTBiZjY3NGVlMGIwMzI5ODFjZWRiNmU2YWEyYTg1MTJlY2NiZjdkODI3MmRhNTNhOGRiZTVkIn0%3D; expires=Sat, 31-May-2025 01:47:20 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxZRndwMmhCeE5wMXJ3ZDlPVE1zWmc9PSIsInZhbHVlIjoiWTN5ZndLZkJrTnZIVnpMM21QNUFJa2tMWldZYWhhQ3hPeWt0ZkxOSWh2RVwvMnViYU80SytXZ1RjQ1dOTnVwV0giLCJtY ▶" 1 => "laravel_session=eyJpdiI6ImtGdkRjeFwvRm1udCt6cGZRbjlGXC9qUT09IiwidmFsdWUiOiJIQzVXMXV2Q2tLMFVXTDVnODRWcHFWekNZc25ISVJ3TXorNHNENVFUem1EZHBkU3M3dnFDUHhBU0ZweWdHU1dyTDNqUG1LM1hcLzY5SnpxWHZwRG0zdDVvc3lMTjQzODRZSmo0YjEzcllqbFdRWndTS3EzVFdWTXUydktMb0pmdm0iLCJtYWMiOiJjYjViYTE4YmE0NjNmNTE0NzYzNWIzYTk1ZWIxZmYzYWZkNzMyMDkxOWU4YzQ2MjRhN2ExNzQ4YjcxOGExMzAyIn0%3D; expires=Sat, 31-May-2025 01:47:20 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6ImtGdkRjeFwvRm1udCt6cGZRbjlGXC9qUT09IiwidmFsdWUiOiJIQzVXMXV2Q2tLMFVXTDVnODRWcHFWekNZc25ISVJ3TXorNHNENVFUem1EZHBkU3M3dnFDUHhBU0ZweWdHU1dy ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxZRndwMmhCeE5wMXJ3ZDlPVE1zWmc9PSIsInZhbHVlIjoiWTN5ZndLZkJrTnZIVnpMM21QNUFJa2tMWldZYWhhQ3hPeWt0ZkxOSWh2RVwvMnViYU80SytXZ1RjQ1dOTnVwV0giLCJtYWMiOiJkZGM5YWYyZjQ1MTBiZjY3NGVlMGIwMzI5ODFjZWRiNmU2YWEyYTg1MTJlY2NiZjdkODI3MmRhNTNhOGRiZTVkIn0%3D; expires=Sat, 31-May-2025 01:47:20 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxZRndwMmhCeE5wMXJ3ZDlPVE1zWmc9PSIsInZhbHVlIjoiWTN5ZndLZkJrTnZIVnpMM21QNUFJa2tMWldZYWhhQ3hPeWt0ZkxOSWh2RVwvMnViYU80SytXZ1RjQ1dOTnVwV0giLCJtY ▶" 1 => "laravel_session=eyJpdiI6ImtGdkRjeFwvRm1udCt6cGZRbjlGXC9qUT09IiwidmFsdWUiOiJIQzVXMXV2Q2tLMFVXTDVnODRWcHFWekNZc25ISVJ3TXorNHNENVFUem1EZHBkU3M3dnFDUHhBU0ZweWdHU1dyTDNqUG1LM1hcLzY5SnpxWHZwRG0zdDVvc3lMTjQzODRZSmo0YjEzcllqbFdRWndTS3EzVFdWTXUydktMb0pmdm0iLCJtYWMiOiJjYjViYTE4YmE0NjNmNTE0NzYzNWIzYTk1ZWIxZmYzYWZkNzMyMDkxOWU4YzQ2MjRhN2ExNzQ4YjcxOGExMzAyIn0%3D; expires=Sat, 31-May-2025 01:47:20 GMT; path=/; httponly ◀laravel_session=eyJpdiI6ImtGdkRjeFwvRm1udCt6cGZRbjlGXC9qUT09IiwidmFsdWUiOiJIQzVXMXV2Q2tLMFVXTDVnODRWcHFWekNZc25ISVJ3TXorNHNENVFUem1EZHBkU3M3dnFDUHhBU0ZweWdHU1dy ▶" ] ]
0 of 0array:4 [▶ "_token" => "srte0kuUGCsQj83jv8Q6xzOpCnbzn6ZqJhKuoFuK" "_previous" => array:1 [▶ "url" => "https://dev.avtoshina34.ru/catalog/tyres/yokohama/97293" ] "PHPDEBUGBAR_STACK_DATA" => [] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]