Диски LS в Волгограде от 2080₽ в магазине Автошина34

Messages Timeline Exceptions Views1 Route Queries6 Models167 Mails Gate Session Request

7.2.2437.91ms5MBGET cart

Booting (12.1ms)
Application (25.72ms)
1 x Application (67.85%)
25.72ms
1 x Booting (31.91%)
12.10ms

1 templates were rendered

user.minicart (resources/views/user/minicart.blade.php)1blade
Params
0
cart

Params
0	`cart`

uri: GET cart
middleware: web, client, redirects, seo
controller: App\Http\Controllers\Client\CartController@index
namespace: App\Http\Controllers\Client
prefix: /cart
where
file: app/Http/Controllers/Client/CartController.php:24-32

6 statements were executed17.23ms

select * from `categories` where (`parent` = 1 and `tmp` = '0' and `visible` = 1) order by `categories`.`order` asc420μs/app/Models/Product/Category.php:158avtoshina_beta

Metadata
Bindings	0. 1 1. 0 2. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	10. /app/Models/Product/Category.php:158 11. middleware::client:21 12. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 13. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 14. middleware::bindings:41 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 17. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 20. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 23. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590 37. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/fideloper/proxy/src/TrustProxies.php:56 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149

select * from `car_manufacturers` order by `name` asc260μsmiddleware::client:22avtoshina_beta

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	12. middleware::client:22 13. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 14. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 15. middleware::bindings:41 16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 18. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 20. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 21. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 24. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590 38. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/fideloper/proxy/src/TrustProxies.php:56 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30

Hints

Use SELECT * only if you need all columns from table
The SELECT statement has no WHERE clause and could examine many more rows than intended

Backtrace

12. middleware::client:22
13. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
14. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
15. middleware::bindings:41
16. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
17. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
18. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
20. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
21. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
22. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
24. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
27. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
30. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601
37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590
38. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/fideloper/proxy/src/TrustProxies.php:56
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php:30

select * from `seo_redirects` where `page_from` = 'cart' limit 1810μs/app/Models/Redirect.php:33avtoshina_beta

Metadata
Bindings	0. cart
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Models/Redirect.php:33 14. middleware::redirects:23 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 17. middleware::client:27 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 20. middleware::bindings:41 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 23. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590 43. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/fideloper/proxy/src/TrustProxies.php:56 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149

select `title`, `h1`, `description`, `keywords` from `seo` where `page_url` = 'cart' limit 1830μs/app/Models/Seo.php:36avtoshina_beta

Metadata
Bindings	0. cart
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	13. /app/Models/Seo.php:36 14. middleware::seo:23 15. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 16. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 17. middleware::redirects:29 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 20. middleware::client:27 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 23. middleware::bindings:41 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:590 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149

select `id` from `suppliers` where `type` = 'store'190μs/app/Models/Product/Product.php:1323avtoshina_beta

Metadata
Bindings	0. store
Backtrace	12. /app/Models/Product/Product.php:1323 13. /app/Models/Cart.php:57 14. /app/Http/Controllers/Client/CartController.php:29 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 22. middleware::seo:26 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 25. middleware::redirects:29 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 28. middleware::client:27 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. middleware::bindings:41 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102

Metadata

Bindings

0. store

Backtrace

12. /app/Models/Product/Product.php:1323
13. /app/Models/Cart.php:57
14. /app/Http/Controllers/Client/CartController.php:29
17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
22. middleware::seo:26
23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
25. middleware::redirects:29
26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
28. middleware::client:27
29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
31. middleware::bindings:41
32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
34. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
37. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
40. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102

select `product`.`id` as `product_id`, `product`.`alias` as `product_alias`, `product`.`manufacturer_id`, `product`.`card_name` as `product_name`, `product`.`product_type`, `category`.`alias` as `category_alias`, `category`.`name` as `category_name`, `product`.`category_id`, `category`.`parent` as `category_parent`, `manufacturer`.`name` as `manufacturer_name`, `manufacturer`.`alias` as `manufacturer_alias`, `store`.`store_sum`,
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id = 13
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id = 13
)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_store
WHERE product_store.product_id = product.id
AND product_store.supplier_id IN (12,13)
)
THEN
(SELECT LEAST(
COALESCE(NULLIF(price, 0), 9999999),
COALESCE(NULLIF(discount_price, 0), 9999999)
)
FROM product_store
WHERE product_id = product.id
AND supplier_id IN (12,13)
LIMIT 1)
ELSE
CASE
WHEN EXISTS (
SELECT 1
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
)
THEN
FLOOR((store.price * (100 - (SELECT discount
FROM product_redprice
WHERE product_redprice.product_id = store.product_id
AND product_redprice.supplier_id = store.supplier_id
LIMIT 1)) / 100) / 10) * 10
ELSE
store.store_min_price
END
END
END AS main_price
, `suppliers`.`type`, `cart_product`.`quantity` as `cart_quantity`, `cart_product`.`price` as `cart_price`, `cart_product`.`storage` as `cart_storage`, `product_images`.`path` as `image_path`, `product`.`id` as `product_id` from `products` as `product` left join `manufacturers` as `manufacturer` on `product`.`manufacturer_id` = `manufacturer`.`id` inner join `categories` as `category` on `product`.`category_id` = `category`.`id` left join (
SELECT
product_id,
supplier_id,
price, discount_price,
sum(product_store.quantity) as store_sum,
min(product_store.price) as store_min_price
FROM product_store
WHERE quantity > 0 AND price > 0
GROUP BY product_id, supplier_id, price, discount_price) AS store on `product`.`id` = `store`.`product_id` and `product`.`min_price_supplier_id` = `store`.`supplier_id` left join `suppliers` on `supplier_id` = `suppliers`.`id` inner join `carts` as `cart_product` on `product`.`id` = `cart_product`.`product_id` left join (select path, product_id from product_images
join
(select min(id) as id
from product_images
where product_images.order IS NULL OR product_images.order = 1
group by product_id) as img
on product_images.id = img.id) as product_images on `product`.`id` = `product_images`.`product_id` where (`product`.`visible` = 1 and `product`.`tmp` = 0) and (`category`.`tmp` = 0 and `category`.`visible` = 1) and `product`.`manufacturer_id` is not null and (manufacturer.visible IS NULL OR manufacturer.visible = 1) and (store_sum IS NOT NULL AND store_sum > 0) and `session_id` = 'opfZHZMOpcVukSN5c6EQ21ibtnFayziMXCLP0eZb' order by (SELECT quantity
FROM product_store
WHERE product_id = product.id AND supplier_id = 13
LIMIT 1)
DESC, `suppliers`.`type` desc

14.72ms/app/Models/Cart.php:74avtoshina_beta

Metadata
Bindings	0. 1 1. 0 2. 0 3. 1 4. opfZHZMOpcVukSN5c6EQ21ibtnFayziMXCLP0eZb
Backtrace	10. /app/Models/Cart.php:74 11. /app/Http/Controllers/Client/CartController.php:29 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169 17. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658 18. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 19. middleware::seo:26 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 22. middleware::redirects:29 23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 25. middleware::client:27 26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 28. middleware::bindings:41 29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 31. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68 32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 34. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 37. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601

Metadata

Bindings

0. 1
1. 0
2. 0
3. 1
4. opfZHZMOpcVukSN5c6EQ21ibtnFayziMXCLP0eZb

Backtrace

10. /app/Models/Cart.php:74
11. /app/Http/Controllers/Client/CartController.php:29
14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:212
16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:169
17. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:658
18. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
19. middleware::seo:26
20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
21. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
22. middleware::redirects:29
23. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
24. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
25. middleware::client:27
26. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
27. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
28. middleware::bindings:41
29. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
30. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
31. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:68
32. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
33. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
34. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
35. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
37. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:63
38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
40. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:68
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:149
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:102
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:660
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:635
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:601

App\Models\Supplier: 2
App\Models\Car\CarManufacturer: 165

_token: ncxJmyoteSg7CdAav1iQdoBujTilKA5ERXcfZd4o
_previous: array:1 [ "url" => "https://dev.avtoshina34.ru/catalog/wheels/ls/637017" ]
PHPDEBUGBAR_STACK_DATA: []
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/cart

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:19 [▶
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImNOR1wvVzcrTUxjQVpPSnh6OGlvXC9TQT09IiwidmFsdWUiOiJYRzVvcnF1NEhuSFZOTDhYSFFDVmhyeHBsUEg3VDlZR2c1TkdNbjdaaE9sK3BcL1JIYVdHQ3Zla1I0NEZESFQrRCIsIm1hYyI6IjZmYTdhYmNlNDI1YzgwNDQ1YzdlNGY2NDY4MDRkOTcyOWY5ZTZjOWNiNjhiNDRhNmU1ZDI0OTU5MjdkMDJiMWUifQ%3D%3D; laravel_session=eyJpdiI6InUwNHE3Y3NxNnd4NW1kZVZqRlgyR2c9PSIsInZhbHVlIjoiQUMzcE85ZjVDK0U5YzUyMGtYWmNiRWs1RFwvS2NHMTdScmtoaDhIM3dCS05KbkhiTFlTZHFycXlcL1FNanloR3BoTG1yRmlvdmhHUURXblFFWlVYNDkzdkhBUU9iV0VXMHUyT3RkSkhDVlVrekhENGs1MDlEZ04xRlp3NVZjQXBaWiIsIm1hYyI6ImYxODQxZGMyMzQ5NmQ4YTU0ZjU4Y2IwNjMxZGVkYmM1ZjZhN2NmMDUzMjY4NWYwNjliMzhlNDE3NTQzNjFlYmQifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6ImNOR1wvVzcrTUxjQVpPSnh6OGlvXC9TQT09IiwidmFsdWUiOiJYRzVvcnF1NEhuSFZOTDhYSFFDVmhyeHBsUEg3VDlZR2c1TkdNbjdaaE9sK3BcL1JIYVdHQ3Zla1I0NEZESFQrRCIsI ▶"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "referer" => array:1 [▶
    0 => "https://dev.avtoshina34.ru/catalog/tyres/R23/325-35"
  ]
  "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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "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 => "JSVSgMfnoEYAXc6ETvik2wZDvSNKQx0NYEmL2ya3"
  ]
  "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 => ""
  ]
]

request_server

  0 of 0   
array:43 [▶
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6ImNOR1wvVzcrTUxjQVpPSnh6OGlvXC9TQT09IiwidmFsdWUiOiJYRzVvcnF1NEhuSFZOTDhYSFFDVmhyeHBsUEg3VDlZR2c1TkdNbjdaaE9sK3BcL1JIYVdHQ3Zla1I0NEZESFQrRCIsIm1hYyI6IjZmYTdhYmNlNDI1YzgwNDQ1YzdlNGY2NDY4MDRkOTcyOWY5ZTZjOWNiNjhiNDRhNmU1ZDI0OTU5MjdkMDJiMWUifQ%3D%3D; laravel_session=eyJpdiI6InUwNHE3Y3NxNnd4NW1kZVZqRlgyR2c9PSIsInZhbHVlIjoiQUMzcE85ZjVDK0U5YzUyMGtYWmNiRWs1RFwvS2NHMTdScmtoaDhIM3dCS05KbkhiTFlTZHFycXlcL1FNanloR3BoTG1yRmlvdmhHUURXblFFWlVYNDkzdkhBUU9iV0VXMHUyT3RkSkhDVlVrekhENGs1MDlEZ04xRlp3NVZjQXBaWiIsIm1hYyI6ImYxODQxZGMyMzQ5NmQ4YTU0ZjU4Y2IwNjMxZGVkYmM1ZjZhN2NmMDUzMjY4NWYwNjliMzhlNDE3NTQzNjFlYmQifQ%3D%3D ◀XSRF-TOKEN=eyJpdiI6ImNOR1wvVzcrTUxjQVpPSnh6OGlvXC9TQT09IiwidmFsdWUiOiJYRzVvcnF1NEhuSFZOTDhYSFFDVmhyeHBsUEg3VDlZR2c1TkdNbjdaaE9sK3BcL1JIYVdHQ3Zla1I0NEZESFQrRCIsI ▶"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_REFERER" => "https://dev.avtoshina34.ru/catalog/tyres/R23/325-35"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "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" => "JSVSgMfnoEYAXc6ETvik2wZDvSNKQx0NYEmL2ya3"
  "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" => "20497"
  "REMOTE_ADDR" => "3.14.88.3"
  "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" => "/cart"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1743828737.5838
  "REQUEST_TIME" => 1743828737
]

request_cookies

  0 of 0   
array:2 [▶
  "XSRF-TOKEN" => null
  "laravel_session" => "opfZHZMOpcVukSN5c6EQ21ibtnFayziMXCLP0eZb"
]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 05 Apr 2025 04:52:17 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImxtR1Y4WG1sNTJrOWx5eXRYeHppWnc9PSIsInZhbHVlIjoiOWdLdlhjMEc2d3BsRm9YSTF2OEVVS3hDTWVaSFkzSlljK1pFOEtJMXdDcklhU3pISllMaWwrc0xKWm00VTVRZiIsIm1hYyI6IjVhNTMxZmZjMjI2OTI1NjVkNGU4ZjMxODhkMjc3ODkzOTk0MmYzNDIzYjdlZDkzMTc0YjE4Y2MwMTQyYzg4MjIifQ%3D%3D; expires=Sat, 05-Apr-2025 06:52:17 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxtR1Y4WG1sNTJrOWx5eXRYeHppWnc9PSIsInZhbHVlIjoiOWdLdlhjMEc2d3BsRm9YSTF2OEVVS3hDTWVaSFkzSlljK1pFOEtJMXdDcklhU3pISllMaWwrc0xKWm00VTVRZiIsIm1hY ▶"
    1 => "laravel_session=eyJpdiI6Inl6VWNES3lWYWxHS0J3TEV6VzVlTVE9PSIsInZhbHVlIjoiNmxYTUtFXC9Tdkl3dkRFZm1aVytzWTIrTTJvSG5WZGR0RlVuWmU5aERDYktKV01JeDVxNE4rU3FMaVZcL3RNelRnVlJVODRaUkY1eEIwdGpqUjY1UkUwN093YThLaWZxTitjajMxSHF4dEkwdlFhUUhESEhSVm5zbWgzMkpQVTBYMSIsIm1hYyI6IjY2YTc2OGJiYTNiMTBhZWIwOTQwNDM1ZjU4YWM3ZmIwZWRhNmU1ZmFmOWEwYzJiZDZmY2M2NmZjOTk0Y2I4MWYifQ%3D%3D; expires=Sat, 05-Apr-2025 06:52:17 GMT; Max-Age=7200; path=/; httponly ◀laravel_session=eyJpdiI6Inl6VWNES3lWYWxHS0J3TEV6VzVlTVE9PSIsInZhbHVlIjoiNmxYTUtFXC9Tdkl3dkRFZm1aVytzWTIrTTJvSG5WZGR0RlVuWmU5aERDYktKV01JeDVxNE4rU3FMaVZcL3RNelRn ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImxtR1Y4WG1sNTJrOWx5eXRYeHppWnc9PSIsInZhbHVlIjoiOWdLdlhjMEc2d3BsRm9YSTF2OEVVS3hDTWVaSFkzSlljK1pFOEtJMXdDcklhU3pISllMaWwrc0xKWm00VTVRZiIsIm1hYyI6IjVhNTMxZmZjMjI2OTI1NjVkNGU4ZjMxODhkMjc3ODkzOTk0MmYzNDIzYjdlZDkzMTc0YjE4Y2MwMTQyYzg4MjIifQ%3D%3D; expires=Sat, 05-Apr-2025 06:52:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxtR1Y4WG1sNTJrOWx5eXRYeHppWnc9PSIsInZhbHVlIjoiOWdLdlhjMEc2d3BsRm9YSTF2OEVVS3hDTWVaSFkzSlljK1pFOEtJMXdDcklhU3pISllMaWwrc0xKWm00VTVRZiIsIm1hY ▶"
    1 => "laravel_session=eyJpdiI6Inl6VWNES3lWYWxHS0J3TEV6VzVlTVE9PSIsInZhbHVlIjoiNmxYTUtFXC9Tdkl3dkRFZm1aVytzWTIrTTJvSG5WZGR0RlVuWmU5aERDYktKV01JeDVxNE4rU3FMaVZcL3RNelRnVlJVODRaUkY1eEIwdGpqUjY1UkUwN093YThLaWZxTitjajMxSHF4dEkwdlFhUUhESEhSVm5zbWgzMkpQVTBYMSIsIm1hYyI6IjY2YTc2OGJiYTNiMTBhZWIwOTQwNDM1ZjU4YWM3ZmIwZWRhNmU1ZmFmOWEwYzJiZDZmY2M2NmZjOTk0Y2I4MWYifQ%3D%3D; expires=Sat, 05-Apr-2025 06:52:17 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Inl6VWNES3lWYWxHS0J3TEV6VzVlTVE9PSIsInZhbHVlIjoiNmxYTUtFXC9Tdkl3dkRFZm1aVytzWTIrTTJvSG5WZGR0RlVuWmU5aERDYktKV01JeDVxNE4rU3FMaVZcL3RNelRn ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▶
  "_token" => "ncxJmyoteSg7CdAav1iQdoBujTilKA5ERXcfZd4o"
  "_previous" => array:1 [▶
    "url" => "https://dev.avtoshina34.ru/catalog/wheels/ls/637017"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

1 x Application (67.85%)	25.72ms
1 x Booting (31.91%)	12.10ms

Легковые диски LS

Диски LS в Волгограде