|
COPY
SELECT COUNT(*) AS `aggregate` FROM `products` WHERE EXISTS (SELECT * FROM `collections` JOIN `collection_product` ON `collections`.`id` = `collection_product`.`collection_id` WHERE `collection_product`.`product_id` = products.id AND `collections`.`id` = ?)
ProductController.php:111 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:83 (run) DB.php:40 (select) Builder.php:180 (select) Builder.php:195 (count) ProductController.php:111 (paginate) Router.php:302 (collection) Router.php:280 (invokeController) Router.php:230 (executeRoute) Kernel.php:75 (dispatch) Kernel.php:60 (dispatchToRouter) AddSecurityHeaders.php:15 (Nexa\{closure}) Kernel.php:54 (handle) VerifyCsrfToken.php:24 (Nexa\{closure})
|
0.46ms |
|
COPY
SELECT * FROM `products` WHERE EXISTS (SELECT * FROM `collections` JOIN `collection_product` ON `collections`.`id` = `collection_product`.`collection_id` WHERE `collection_product`.`product_id` = products.id AND `collections`.`id` = ?) LIMIT 8 OFFSET 0
ProductController.php:111 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:83 (run) DB.php:40 (select) Builder.php:213 (select) Builder.php:199 (fetch) ProductController.php:111 (paginate) Router.php:302 (collection) Router.php:280 (invokeController) Router.php:230 (executeRoute) Kernel.php:75 (dispatch) Kernel.php:60 (dispatchToRouter) AddSecurityHeaders.php:15 (Nexa\{closure}) Kernel.php:54 (handle) VerifyCsrfToken.php:24 (Nexa\{closure})
|
0.42ms |
|
COPY
SELECT * FROM product_variants WHERE product_id IN (?,?,?,?,?,?,?,?)
ProductController.php:111 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:83 (run) DB.php:40 (select) Relation.php:190 (select) Builder.php:257 (eagerLoad) Builder.php:219 (eagerLoadRelations) Builder.php:199 (fetch) ProductController.php:111 (paginate) Router.php:302 (collection) Router.php:280 (invokeController) Router.php:230 (executeRoute) Kernel.php:75 (dispatch) Kernel.php:60 (dispatchToRouter) AddSecurityHeaders.php:15 (Nexa\{closure})
|
1.21ms |
|
COPY
SELECT * FROM media WHERE id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ProductController.php:111 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:83 (run) DB.php:40 (select) Relation.php:217 (select) Builder.php:257 (eagerLoad) Builder.php:274 (eagerLoadRelations) Builder.php:219 (eagerLoadRelations) Builder.php:199 (fetch) ProductController.php:111 (paginate) Router.php:302 (collection) Router.php:280 (invokeController) Router.php:230 (executeRoute) Kernel.php:75 (dispatch) Kernel.php:60 (dispatchToRouter)
|
0.59ms |
|
COPY
SELECT * FROM product_options WHERE product_id IN (?,?,?,?,?,?,?,?)
ProductController.php:111 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:83 (run) DB.php:40 (select) Relation.php:190 (select) Builder.php:257 (eagerLoad) Builder.php:219 (eagerLoadRelations) Builder.php:199 (fetch) ProductController.php:111 (paginate) Router.php:302 (collection) Router.php:280 (invokeController) Router.php:230 (executeRoute) Kernel.php:75 (dispatch) Kernel.php:60 (dispatchToRouter) AddSecurityHeaders.php:15 (Nexa\{closure})
|
0.53ms |
|
COPY
INSERT INTO `carts` (`token`, `currency`, `last_active_at`) VALUES (?, ?, ?)
CartService.php:56 (Click for trace)
DebugBar.php:42 (getFilteredTrace) Connection.php:71 (logQuery) Connection.php:92 (run) DB.php:48 (insert) Builder.php:323 (insert) Model.php:260 (insert) CartService.php:56 (save) CartService.php:39 (createCart) CartService.php:142 (getCart) CartService.php:157 (getItems) aa62ebd6a0cfe858cac61190dcd434ac.php:56 (getCartData) Filesystem.php:123 (require) Filesystem.php:124 (Illuminate\Filesystem\{closure}) PhpEngine.php:58 (getRequire) CompilerEngine.php:75 (evaluatePath)
|
2.19ms |