Created
May 16, 2018 20:11
-
-
Save doug7410/9c33d5a22488118e5aeb326731b6242b to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| array:213 [ | |
| 0 => array:3 [ | |
| "query" => "select count(*) as aggregate from `order_items` where `status` = ? and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => "new" | |
| ] | |
| "time" => 27.15 | |
| ] | |
| 1 => array:3 [ | |
| "query" => "select * from `order_items` where `status` = ? and `order_items`.`deleted_at` is null order by `id` asc limit 40 offset 0" | |
| "bindings" => array:1 [ | |
| 0 => "new" | |
| ] | |
| "time" => 88.95 | |
| ] | |
| 2 => array:3 [ | |
| "query" => "select * from `orders` where `orders`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `orders`.`deleted_at` is null" | |
| "bindings" => array:32 [ | |
| 0 => 26023 | |
| 1 => 26026 | |
| 2 => 26039 | |
| 3 => 26044 | |
| 4 => 26047 | |
| 5 => 26049 | |
| 6 => 26052 | |
| 7 => 26054 | |
| 8 => 26055 | |
| 9 => 26056 | |
| 10 => 26057 | |
| 11 => 26058 | |
| 12 => 26059 | |
| 13 => 26060 | |
| 14 => 26061 | |
| 15 => 26062 | |
| 16 => 26063 | |
| 17 => 26064 | |
| 18 => 26065 | |
| 19 => 26066 | |
| 20 => 26067 | |
| 21 => 26068 | |
| 22 => 26069 | |
| 23 => 26070 | |
| 24 => 26071 | |
| 25 => 26072 | |
| 26 => 26073 | |
| 27 => 26074 | |
| 28 => 26075 | |
| 29 => 26076 | |
| 30 => 26077 | |
| 31 => 26078 | |
| ] | |
| "time" => 1.58 | |
| ] | |
| 3 => array:3 [ | |
| "query" => "select * from `meta` where `meta`.`metable_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `meta`.`metable_type` = ?" | |
| "bindings" => array:33 [ | |
| 0 => 26023 | |
| 1 => 26026 | |
| 2 => 26039 | |
| 3 => 26044 | |
| 4 => 26047 | |
| 5 => 26049 | |
| 6 => 26052 | |
| 7 => 26054 | |
| 8 => 26055 | |
| 9 => 26056 | |
| 10 => 26057 | |
| 11 => 26058 | |
| 12 => 26059 | |
| 13 => 26060 | |
| 14 => 26061 | |
| 15 => 26062 | |
| 16 => 26063 | |
| 17 => 26064 | |
| 18 => 26065 | |
| 19 => 26066 | |
| 20 => 26067 | |
| 21 => 26068 | |
| 22 => 26069 | |
| 23 => 26070 | |
| 24 => 26071 | |
| 25 => 26072 | |
| 26 => 26073 | |
| 27 => 26074 | |
| 28 => 26075 | |
| 29 => 26076 | |
| 30 => 26077 | |
| 31 => 26078 | |
| 32 => "App\Models\Order\Order" | |
| ] | |
| "time" => 1.4 | |
| ] | |
| 4 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 8280 | |
| ] | |
| "time" => 0.46 | |
| ] | |
| 5 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 2110 | |
| ] | |
| "time" => 0.24 | |
| ] | |
| 6 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 0.6 | |
| ] | |
| 7 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `users`.`deleted_at` is null" | |
| "bindings" => array:31 [ | |
| 0 => 21328 | |
| 1 => 21655 | |
| 2 => 24407 | |
| 3 => 25191 | |
| 4 => 25736 | |
| 5 => 25739 | |
| 6 => 25751 | |
| 7 => 25756 | |
| 8 => 25759 | |
| 9 => 25761 | |
| 10 => 25764 | |
| 11 => 25765 | |
| 12 => 25766 | |
| 13 => 25767 | |
| 14 => 25768 | |
| 15 => 25769 | |
| 16 => 25770 | |
| 17 => 25771 | |
| 18 => 25772 | |
| 19 => 25773 | |
| 20 => 25774 | |
| 21 => 25775 | |
| 22 => 25776 | |
| 23 => 25777 | |
| 24 => 25778 | |
| 25 => 25779 | |
| 26 => 25780 | |
| 27 => 25781 | |
| 28 => 25782 | |
| 29 => 25783 | |
| 30 => 25784 | |
| ] | |
| "time" => 2.95 | |
| ] | |
| 8 => array:3 [ | |
| "query" => "select * from `activity_log` where `activity_log`.`subject_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `activity_log`.`subject_type` = ? order by `id` desc" | |
| "bindings" => array:41 [ | |
| 0 => 32585 | |
| 1 => 32589 | |
| 2 => 32607 | |
| 3 => 32613 | |
| 4 => 32620 | |
| 5 => 32623 | |
| 6 => 32627 | |
| 7 => 32630 | |
| 8 => 32631 | |
| 9 => 32632 | |
| 10 => 32633 | |
| 11 => 32634 | |
| 12 => 32635 | |
| 13 => 32636 | |
| 14 => 32637 | |
| 15 => 32638 | |
| 16 => 32639 | |
| 17 => 32640 | |
| 18 => 32641 | |
| 19 => 32642 | |
| 20 => 32643 | |
| 21 => 32644 | |
| 22 => 32645 | |
| 23 => 32646 | |
| 24 => 32647 | |
| 25 => 32648 | |
| 26 => 32649 | |
| 27 => 32650 | |
| 28 => 32651 | |
| 29 => 32652 | |
| 30 => 32653 | |
| 31 => 32654 | |
| 32 => 32655 | |
| 33 => 32656 | |
| 34 => 32657 | |
| 35 => 32658 | |
| 36 => 32659 | |
| 37 => 32660 | |
| 38 => 32661 | |
| 39 => 32662 | |
| 40 => "App\Models\Order\OrderItem" | |
| ] | |
| "time" => 27.18 | |
| ] | |
| 9 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" | |
| "bindings" => array:30 [ | |
| 0 => 32662 | |
| 1 => 32661 | |
| 2 => 32660 | |
| 3 => 32659 | |
| 4 => 32658 | |
| 5 => 32656 | |
| 6 => 32655 | |
| 7 => 32654 | |
| 8 => 32653 | |
| 9 => 32651 | |
| 10 => 32650 | |
| 11 => 32649 | |
| 12 => 32648 | |
| 13 => 32647 | |
| 14 => 32646 | |
| 15 => 32644 | |
| 16 => 32643 | |
| 17 => 32641 | |
| 18 => 32640 | |
| 19 => 32639 | |
| 20 => 32638 | |
| 21 => 32637 | |
| 22 => 32636 | |
| 23 => 32635 | |
| 24 => 32634 | |
| 25 => 32633 | |
| 26 => 32632 | |
| 27 => 32631 | |
| 28 => 32630 | |
| 29 => 32627 | |
| ] | |
| "time" => 1.53 | |
| ] | |
| 10 => array:3 [ | |
| "query" => "select * from `comments` where `type` = ? and `comments`.`content_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `comments`.`content_type` = ? and `comments`.`deleted_at` is null" | |
| "bindings" => array:42 [ | |
| 0 => "escalation" | |
| 1 => 32585 | |
| 2 => 32589 | |
| 3 => 32607 | |
| 4 => 32613 | |
| 5 => 32620 | |
| 6 => 32623 | |
| 7 => 32627 | |
| 8 => 32630 | |
| 9 => 32631 | |
| 10 => 32632 | |
| 11 => 32633 | |
| 12 => 32634 | |
| 13 => 32635 | |
| 14 => 32636 | |
| 15 => 32637 | |
| 16 => 32638 | |
| 17 => 32639 | |
| 18 => 32640 | |
| 19 => 32641 | |
| 20 => 32642 | |
| 21 => 32643 | |
| 22 => 32644 | |
| 23 => 32645 | |
| 24 => 32646 | |
| 25 => 32647 | |
| 26 => 32648 | |
| 27 => 32649 | |
| 28 => 32650 | |
| 29 => 32651 | |
| 30 => 32652 | |
| 31 => 32653 | |
| 32 => 32654 | |
| 33 => 32655 | |
| 34 => 32656 | |
| 35 => 32657 | |
| 36 => 32658 | |
| 37 => 32659 | |
| 38 => 32660 | |
| 39 => 32661 | |
| 40 => 32662 | |
| 41 => "App\Models\Order\OrderItem" | |
| ] | |
| "time" => 147.82 | |
| ] | |
| 11 => array:3 [ | |
| "query" => "select * from `comments` where `type` = ? and (not exists (select * from `meta` where `comments`.`id` = `meta`.`metable_id` and `meta`.`metable_type` = ? and `key` = ?) or (exists (select * from `meta` where `comments`.`id` = `meta`.`metable_id` and `meta`.`metable_type` = ? and `key` = ? and `value` = ?))) and `comments`.`content_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `comments`.`content_type` = ? and `comments`.`deleted_at` is null" | |
| "bindings" => array:47 [ | |
| 0 => "escalation" | |
| 1 => "App\Models\Comment" | |
| 2 => "resolved" | |
| 3 => "App\Models\Comment" | |
| 4 => "resolved" | |
| 5 => "" | |
| 6 => 32585 | |
| 7 => 32589 | |
| 8 => 32607 | |
| 9 => 32613 | |
| 10 => 32620 | |
| 11 => 32623 | |
| 12 => 32627 | |
| 13 => 32630 | |
| 14 => 32631 | |
| 15 => 32632 | |
| 16 => 32633 | |
| 17 => 32634 | |
| 18 => 32635 | |
| 19 => 32636 | |
| 20 => 32637 | |
| 21 => 32638 | |
| 22 => 32639 | |
| 23 => 32640 | |
| 24 => 32641 | |
| 25 => 32642 | |
| 26 => 32643 | |
| 27 => 32644 | |
| 28 => 32645 | |
| 29 => 32646 | |
| 30 => 32647 | |
| 31 => 32648 | |
| 32 => 32649 | |
| 33 => 32650 | |
| 34 => 32651 | |
| 35 => 32652 | |
| 36 => 32653 | |
| 37 => 32654 | |
| 38 => 32655 | |
| 39 => 32656 | |
| 40 => 32657 | |
| 41 => 32658 | |
| 42 => 32659 | |
| 43 => 32660 | |
| 44 => 32661 | |
| 45 => 32662 | |
| 46 => "App\Models\Order\OrderItem" | |
| ] | |
| "time" => 615.45 | |
| ] | |
| 12 => array:3 [ | |
| "query" => "select * from `comments` where `type` = ? and `comments`.`content_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `comments`.`content_type` = ? and `comments`.`deleted_at` is null order by `id` desc" | |
| "bindings" => array:42 [ | |
| 0 => "fix_request" | |
| 1 => 32585 | |
| 2 => 32589 | |
| 3 => 32607 | |
| 4 => 32613 | |
| 5 => 32620 | |
| 6 => 32623 | |
| 7 => 32627 | |
| 8 => 32630 | |
| 9 => 32631 | |
| 10 => 32632 | |
| 11 => 32633 | |
| 12 => 32634 | |
| 13 => 32635 | |
| 14 => 32636 | |
| 15 => 32637 | |
| 16 => 32638 | |
| 17 => 32639 | |
| 18 => 32640 | |
| 19 => 32641 | |
| 20 => 32642 | |
| 21 => 32643 | |
| 22 => 32644 | |
| 23 => 32645 | |
| 24 => 32646 | |
| 25 => 32647 | |
| 26 => 32648 | |
| 27 => 32649 | |
| 28 => 32650 | |
| 29 => 32651 | |
| 30 => 32652 | |
| 31 => 32653 | |
| 32 => 32654 | |
| 33 => 32655 | |
| 34 => 32656 | |
| 35 => 32657 | |
| 36 => 32658 | |
| 37 => 32659 | |
| 38 => 32660 | |
| 39 => 32661 | |
| 40 => 32662 | |
| 41 => "App\Models\Order\OrderItem" | |
| ] | |
| "time" => 163.23 | |
| ] | |
| 13 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 5.85 | |
| ] | |
| 14 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 5.95 | |
| ] | |
| 15 => array:3 [ | |
| "query" => "select * from `resub_reasons` where `resub_reasons`.`id` in (?) and `resub_reasons`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 1.19 | |
| ] | |
| 16 => array:3 [ | |
| "query" => "select `files`.*, `order_item_file_relations`.`order_item_id` as `pivot_order_item_id`, `order_item_file_relations`.`file_id` as `pivot_file_id` from `files` inner join `order_item_file_relations` on `files`.`id` = `order_item_file_relations`.`file_id` where `files`.`type` = ? and `order_item_file_relations`.`order_item_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `files`.`deleted_at` is null order by `id` desc" | |
| "bindings" => array:41 [ | |
| 0 => "order_item_original" | |
| 1 => 32585 | |
| 2 => 32589 | |
| 3 => 32607 | |
| 4 => 32613 | |
| 5 => 32620 | |
| 6 => 32623 | |
| 7 => 32627 | |
| 8 => 32630 | |
| 9 => 32631 | |
| 10 => 32632 | |
| 11 => 32633 | |
| 12 => 32634 | |
| 13 => 32635 | |
| 14 => 32636 | |
| 15 => 32637 | |
| 16 => 32638 | |
| 17 => 32639 | |
| 18 => 32640 | |
| 19 => 32641 | |
| 20 => 32642 | |
| 21 => 32643 | |
| 22 => 32644 | |
| 23 => 32645 | |
| 24 => 32646 | |
| 25 => 32647 | |
| 26 => 32648 | |
| 27 => 32649 | |
| 28 => 32650 | |
| 29 => 32651 | |
| 30 => 32652 | |
| 31 => 32653 | |
| 32 => 32654 | |
| 33 => 32655 | |
| 34 => 32656 | |
| 35 => 32657 | |
| 36 => 32658 | |
| 37 => 32659 | |
| 38 => 32660 | |
| 39 => 32661 | |
| 40 => 32662 | |
| ] | |
| "time" => 1.18 | |
| ] | |
| 17 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `users`.`deleted_at` is null" | |
| "bindings" => array:25 [ | |
| 0 => 21328 | |
| 1 => 21655 | |
| 2 => 24407 | |
| 3 => 25191 | |
| 4 => 25764 | |
| 5 => 25765 | |
| 6 => 25766 | |
| 7 => 25767 | |
| 8 => 25768 | |
| 9 => 25769 | |
| 10 => 25770 | |
| 11 => 25771 | |
| 12 => 25772 | |
| 13 => 25773 | |
| 14 => 25774 | |
| 15 => 25775 | |
| 16 => 25776 | |
| 17 => 25777 | |
| 18 => 25778 | |
| 19 => 25779 | |
| 20 => 25780 | |
| 21 => 25781 | |
| 22 => 25782 | |
| 23 => 25783 | |
| 24 => 25784 | |
| ] | |
| "time" => 0.63 | |
| ] | |
| 18 => array:3 [ | |
| "query" => "select * from `files` where `files`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `files`.`deleted_at` is null" | |
| "bindings" => array:31 [ | |
| 0 => null | |
| 1 => 158239 | |
| 2 => 158250 | |
| 3 => 158266 | |
| 4 => 158269 | |
| 5 => 158309 | |
| 6 => 158321 | |
| 7 => 158322 | |
| 8 => 158323 | |
| 9 => 158325 | |
| 10 => 158330 | |
| 11 => 158343 | |
| 12 => 158354 | |
| 13 => 158365 | |
| 14 => 158367 | |
| 15 => 158369 | |
| 16 => 158376 | |
| 17 => 158391 | |
| 18 => 158406 | |
| 19 => 158413 | |
| 20 => 158436 | |
| 21 => 158448 | |
| 22 => 158459 | |
| 23 => 158480 | |
| 24 => 158481 | |
| 25 => 158510 | |
| 26 => 158521 | |
| 27 => 158540 | |
| 28 => 158541 | |
| 29 => 158542 | |
| 30 => 158547 | |
| ] | |
| "time" => 1.71 | |
| ] | |
| 19 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `users`.`deleted_at` is null" | |
| "bindings" => array:25 [ | |
| 0 => 21328 | |
| 1 => 21655 | |
| 2 => 24407 | |
| 3 => 25191 | |
| 4 => 25764 | |
| 5 => 25765 | |
| 6 => 25766 | |
| 7 => 25767 | |
| 8 => 25768 | |
| 9 => 25769 | |
| 10 => 25770 | |
| 11 => 25771 | |
| 12 => 25772 | |
| 13 => 25773 | |
| 14 => 25774 | |
| 15 => 25775 | |
| 16 => 25776 | |
| 17 => 25777 | |
| 18 => 25778 | |
| 19 => 25779 | |
| 20 => 25780 | |
| 21 => 25781 | |
| 22 => 25782 | |
| 23 => 25783 | |
| 24 => 25784 | |
| ] | |
| "time" => 0.83 | |
| ] | |
| 20 => array:3 [ | |
| "query" => "select * from `files` where `files`.`id` in (?) and `files`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 0.35 | |
| ] | |
| 21 => array:3 [ | |
| "query" => "select * from `files` where `files`.`id` in (?) and `files`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => null | |
| ] | |
| "time" => 0.6 | |
| ] | |
| 22 => array:3 [ | |
| "query" => "select * from `meta` where `meta`.`metable_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `meta`.`metable_type` = ?" | |
| "bindings" => array:41 [ | |
| 0 => 32585 | |
| 1 => 32589 | |
| 2 => 32607 | |
| 3 => 32613 | |
| 4 => 32620 | |
| 5 => 32623 | |
| 6 => 32627 | |
| 7 => 32630 | |
| 8 => 32631 | |
| 9 => 32632 | |
| 10 => 32633 | |
| 11 => 32634 | |
| 12 => 32635 | |
| 13 => 32636 | |
| 14 => 32637 | |
| 15 => 32638 | |
| 16 => 32639 | |
| 17 => 32640 | |
| 18 => 32641 | |
| 19 => 32642 | |
| 20 => 32643 | |
| 21 => 32644 | |
| 22 => 32645 | |
| 23 => 32646 | |
| 24 => 32647 | |
| 25 => 32648 | |
| 26 => 32649 | |
| 27 => 32650 | |
| 28 => 32651 | |
| 29 => 32652 | |
| 30 => 32653 | |
| 31 => 32654 | |
| 32 => 32655 | |
| 33 => 32656 | |
| 34 => 32657 | |
| 35 => 32658 | |
| 36 => 32659 | |
| 37 => 32660 | |
| 38 => 32661 | |
| 39 => 32662 | |
| 40 => "App\Models\Order\OrderItem" | |
| ] | |
| "time" => 2.81 | |
| ] | |
| 23 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26023 | |
| ] | |
| "time" => 0.69 | |
| ] | |
| 24 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.21 | |
| ] | |
| 25 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32585 | |
| ] | |
| "time" => 125.51 | |
| ] | |
| 26 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32585 | |
| ] | |
| "time" => 119.45 | |
| ] | |
| 27 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.36 | |
| ] | |
| 28 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.64 | |
| ] | |
| 29 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.88 | |
| ] | |
| 30 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32589 | |
| ] | |
| "time" => 103.91 | |
| ] | |
| 31 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32589 | |
| ] | |
| "time" => 112.16 | |
| ] | |
| 32 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 33 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.69 | |
| ] | |
| 34 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32607 | |
| ] | |
| "time" => 110.3 | |
| ] | |
| 35 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32607 | |
| ] | |
| "time" => 108.51 | |
| ] | |
| 36 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 3.49 | |
| ] | |
| 37 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 38 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32613 | |
| ] | |
| "time" => 101.29 | |
| ] | |
| 39 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32613 | |
| ] | |
| "time" => 99.96 | |
| ] | |
| 40 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26044 | |
| ] | |
| "time" => 0.51 | |
| ] | |
| 41 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.73 | |
| ] | |
| 42 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.42 | |
| ] | |
| 43 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.59 | |
| ] | |
| 44 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32620 | |
| ] | |
| "time" => 107.55 | |
| ] | |
| 45 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32620 | |
| ] | |
| "time" => 102.67 | |
| ] | |
| 46 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26047 | |
| ] | |
| "time" => 0.62 | |
| ] | |
| 47 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 3.36 | |
| ] | |
| 48 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.55 | |
| ] | |
| 49 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.57 | |
| ] | |
| 50 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32623 | |
| ] | |
| "time" => 107.13 | |
| ] | |
| 51 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32623 | |
| ] | |
| "time" => 107.13 | |
| ] | |
| 52 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.33 | |
| ] | |
| 53 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.6 | |
| ] | |
| 54 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32627 | |
| ] | |
| "time" => 126.17 | |
| ] | |
| 55 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32627 | |
| ] | |
| "time" => 107.49 | |
| ] | |
| 56 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.39 | |
| ] | |
| 57 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.17 | |
| ] | |
| 58 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32630 | |
| ] | |
| "time" => 121.94 | |
| ] | |
| 59 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32630 | |
| ] | |
| "time" => 107.8 | |
| ] | |
| 60 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26054 | |
| ] | |
| "time" => 2.44 | |
| ] | |
| 61 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.3 | |
| ] | |
| 62 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.2 | |
| ] | |
| 63 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.77 | |
| ] | |
| 64 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32631 | |
| ] | |
| "time" => 131.27 | |
| ] | |
| 65 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32631 | |
| ] | |
| "time" => 156.8 | |
| ] | |
| 66 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26055 | |
| ] | |
| "time" => 0.49 | |
| ] | |
| 67 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.33 | |
| ] | |
| 68 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 3.07 | |
| ] | |
| 69 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.48 | |
| ] | |
| 70 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32632 | |
| ] | |
| "time" => 150.22 | |
| ] | |
| 71 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32632 | |
| ] | |
| "time" => 149.2 | |
| ] | |
| 72 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.42 | |
| ] | |
| 73 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.84 | |
| ] | |
| 74 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32633 | |
| ] | |
| "time" => 106.98 | |
| ] | |
| 75 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32633 | |
| ] | |
| "time" => 104.76 | |
| ] | |
| 76 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 77 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.6 | |
| ] | |
| 78 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32634 | |
| ] | |
| "time" => 115.9 | |
| ] | |
| 79 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32634 | |
| ] | |
| "time" => 114.9 | |
| ] | |
| 80 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26057 | |
| ] | |
| "time" => 0.5 | |
| ] | |
| 81 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.33 | |
| ] | |
| 82 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.49 | |
| ] | |
| 83 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.68 | |
| ] | |
| 84 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32635 | |
| ] | |
| "time" => 110.05 | |
| ] | |
| 85 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32635 | |
| ] | |
| "time" => 119.31 | |
| ] | |
| 86 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.46 | |
| ] | |
| 87 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.61 | |
| ] | |
| 88 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32636 | |
| ] | |
| "time" => 137.4 | |
| ] | |
| 89 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32636 | |
| ] | |
| "time" => 121.76 | |
| ] | |
| 90 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.7 | |
| ] | |
| 91 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.35 | |
| ] | |
| 92 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32637 | |
| ] | |
| "time" => 133.95 | |
| ] | |
| 93 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32637 | |
| ] | |
| "time" => 127.17 | |
| ] | |
| 94 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26058 | |
| ] | |
| "time" => 0.73 | |
| ] | |
| 95 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 2.94 | |
| ] | |
| 96 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 97 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.16 | |
| ] | |
| 98 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32638 | |
| ] | |
| "time" => 118.72 | |
| ] | |
| 99 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32638 | |
| ] | |
| "time" => 115.86 | |
| ] | |
| 100 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26059 | |
| ] | |
| "time" => 0.44 | |
| ] | |
| 101 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 8.69 | |
| ] | |
| 102 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.44 | |
| ] | |
| 103 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.69 | |
| ] | |
| 104 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32639 | |
| ] | |
| "time" => 118.52 | |
| ] | |
| 105 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32639 | |
| ] | |
| "time" => 130.82 | |
| ] | |
| 106 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 7.73 | |
| ] | |
| 107 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.99 | |
| ] | |
| 108 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32640 | |
| ] | |
| "time" => 94.15 | |
| ] | |
| 109 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32640 | |
| ] | |
| "time" => 60.21 | |
| ] | |
| 110 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.39 | |
| ] | |
| 111 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.68 | |
| ] | |
| 112 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32641 | |
| ] | |
| "time" => 113.83 | |
| ] | |
| 113 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32641 | |
| ] | |
| "time" => 119.09 | |
| ] | |
| 114 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26062 | |
| ] | |
| "time" => 8.55 | |
| ] | |
| 115 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.3 | |
| ] | |
| 116 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 3.26 | |
| ] | |
| 117 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.62 | |
| ] | |
| 118 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32642 | |
| ] | |
| "time" => 109.04 | |
| ] | |
| 119 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32642 | |
| ] | |
| "time" => 112.21 | |
| ] | |
| 120 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26063 | |
| ] | |
| "time" => 0.48 | |
| ] | |
| 121 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.28 | |
| ] | |
| 122 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.37 | |
| ] | |
| 123 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.59 | |
| ] | |
| 124 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32643 | |
| ] | |
| "time" => 116.87 | |
| ] | |
| 125 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32643 | |
| ] | |
| "time" => 113.18 | |
| ] | |
| 126 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.4 | |
| ] | |
| 127 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 128 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32644 | |
| ] | |
| "time" => 111.12 | |
| ] | |
| 129 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32644 | |
| ] | |
| "time" => 117.04 | |
| ] | |
| 130 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 8.01 | |
| ] | |
| 131 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.6 | |
| ] | |
| 132 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32645 | |
| ] | |
| "time" => 56.36 | |
| ] | |
| 133 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32645 | |
| ] | |
| "time" => 61.38 | |
| ] | |
| 134 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.41 | |
| ] | |
| 135 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.57 | |
| ] | |
| 136 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32646 | |
| ] | |
| "time" => 56.92 | |
| ] | |
| 137 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32646 | |
| ] | |
| "time" => 59.29 | |
| ] | |
| 138 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.95 | |
| ] | |
| 139 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 140 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32647 | |
| ] | |
| "time" => 54.9 | |
| ] | |
| 141 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32647 | |
| ] | |
| "time" => 56.82 | |
| ] | |
| 142 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26066 | |
| ] | |
| "time" => 0.5 | |
| ] | |
| 143 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.23 | |
| ] | |
| 144 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.42 | |
| ] | |
| 145 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.63 | |
| ] | |
| 146 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32648 | |
| ] | |
| "time" => 54.46 | |
| ] | |
| 147 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32648 | |
| ] | |
| "time" => 58.54 | |
| ] | |
| 148 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.43 | |
| ] | |
| 149 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.61 | |
| ] | |
| 150 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32649 | |
| ] | |
| "time" => 59.57 | |
| ] | |
| 151 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32649 | |
| ] | |
| "time" => 53.95 | |
| ] | |
| 152 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26068 | |
| ] | |
| "time" => 0.47 | |
| ] | |
| 153 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.34 | |
| ] | |
| 154 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.7 | |
| ] | |
| 155 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.54 | |
| ] | |
| 156 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32650 | |
| ] | |
| "time" => 55.28 | |
| ] | |
| 157 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32650 | |
| ] | |
| "time" => 53.41 | |
| ] | |
| 158 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 159 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.08 | |
| ] | |
| 160 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32651 | |
| ] | |
| "time" => 54.14 | |
| ] | |
| 161 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32651 | |
| ] | |
| "time" => 54.35 | |
| ] | |
| 162 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.39 | |
| ] | |
| 163 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.68 | |
| ] | |
| 164 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32652 | |
| ] | |
| "time" => 53.71 | |
| ] | |
| 165 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32652 | |
| ] | |
| "time" => 53.88 | |
| ] | |
| 166 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 167 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.66 | |
| ] | |
| 168 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32653 | |
| ] | |
| "time" => 54.41 | |
| ] | |
| 169 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32653 | |
| ] | |
| "time" => 53.17 | |
| ] | |
| 170 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.38 | |
| ] | |
| 171 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 172 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32654 | |
| ] | |
| "time" => 54.01 | |
| ] | |
| 173 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32654 | |
| ] | |
| "time" => 56.19 | |
| ] | |
| 174 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.48 | |
| ] | |
| 175 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 176 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32655 | |
| ] | |
| "time" => 54.87 | |
| ] | |
| 177 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32655 | |
| ] | |
| "time" => 54.08 | |
| ] | |
| 178 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.48 | |
| ] | |
| 179 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.55 | |
| ] | |
| 180 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32656 | |
| ] | |
| "time" => 57.54 | |
| ] | |
| 181 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32656 | |
| ] | |
| "time" => 56.46 | |
| ] | |
| 182 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.39 | |
| ] | |
| 183 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.0 | |
| ] | |
| 184 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32657 | |
| ] | |
| "time" => 60.72 | |
| ] | |
| 185 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32657 | |
| ] | |
| "time" => 56.86 | |
| ] | |
| 186 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.42 | |
| ] | |
| 187 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.57 | |
| ] | |
| 188 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32658 | |
| ] | |
| "time" => 56.16 | |
| ] | |
| 189 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32658 | |
| ] | |
| "time" => 61.03 | |
| ] | |
| 190 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 191 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.06 | |
| ] | |
| 192 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32659 | |
| ] | |
| "time" => 59.33 | |
| ] | |
| 193 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32659 | |
| ] | |
| "time" => 58.35 | |
| ] | |
| 194 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26076 | |
| ] | |
| "time" => 0.49 | |
| ] | |
| 195 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.53 | |
| ] | |
| 196 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.53 | |
| ] | |
| 197 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.71 | |
| ] | |
| 198 => array:3 [ | |
| "query" => "select * from `order_items` where `order_items`.`order_id` = ? and `order_items`.`order_id` is not null and `order_items`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 26077 | |
| ] | |
| "time" => 0.54 | |
| ] | |
| 199 => array:3 [ | |
| "query" => "select * from `users` where `users`.`id` is null and `users`.`deleted_at` is null limit 1" | |
| "bindings" => [] | |
| "time" => 0.33 | |
| ] | |
| 200 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32660 | |
| ] | |
| "time" => 57.22 | |
| ] | |
| 201 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32660 | |
| ] | |
| "time" => 55.74 | |
| ] | |
| 202 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.46 | |
| ] | |
| 203 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.62 | |
| ] | |
| 204 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32661 | |
| ] | |
| "time" => 76.59 | |
| ] | |
| 205 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32661 | |
| ] | |
| "time" => 61.06 | |
| ] | |
| 206 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.57 | |
| ] | |
| 207 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 1.08 | |
| ] | |
| 208 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32662 | |
| ] | |
| "time" => 66.33 | |
| ] | |
| 209 => array:3 [ | |
| "query" => "select count(*) as aggregate from `users` where exists (select * from `order_item_batches` where `users`.`id` = `order_item_batches`.`user_id` and exists (select * from `order_items` inner join `order_item_batch_relations` on `order_items`.`id` = `order_item_batch_relations`.`item_id` where `order_item_batches`.`id` = `order_item_batch_relations`.`batch_id` and `order_items`.`id` = ? and `order_items`.`deleted_at` is null)) and `users`.`deleted_at` is null" | |
| "bindings" => array:1 [ | |
| 0 => 32662 | |
| ] | |
| "time" => 66.57 | |
| ] | |
| 210 => array:3 [ | |
| "query" => "select * from `collection_items` where `collection_items`.`id` = ? and `collection_items`.`id` is not null limit 1" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.41 | |
| ] | |
| 211 => array:3 [ | |
| "query" => "select * from `collection_item_images` where `collection_item_images`.`item_id` = ? and `collection_item_images`.`item_id` is not null" | |
| "bindings" => array:1 [ | |
| 0 => 98 | |
| ] | |
| "time" => 0.58 | |
| ] | |
| 212 => array:3 [ | |
| "query" => "select `orders`.`id` as `order_id`, COUNT(notifications.id) as counter from `orders` left join `notifications` on `notifications`.`order_id` = `orders`.`id` where `orders`.`id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and `notifications`.`read_at` is null and `notifiable_type` = ? and `notifiable_id` = ? and `orders`.`deleted_at` is null group by `orders`.`id`" | |
| "bindings" => array:42 [ | |
| 0 => 26023 | |
| 1 => 26026 | |
| 2 => 26039 | |
| 3 => 26044 | |
| 4 => 26047 | |
| 5 => 26049 | |
| 6 => 26052 | |
| 7 => 26054 | |
| 8 => 26055 | |
| 9 => 26055 | |
| 10 => 26056 | |
| 11 => 26057 | |
| 12 => 26057 | |
| 13 => 26057 | |
| 14 => 26058 | |
| 15 => 26059 | |
| 16 => 26060 | |
| 17 => 26061 | |
| 18 => 26062 | |
| 19 => 26063 | |
| 20 => 26063 | |
| 21 => 26064 | |
| 22 => 26065 | |
| 23 => 26065 | |
| 24 => 26066 | |
| 25 => 26067 | |
| 26 => 26068 | |
| 27 => 26069 | |
| 28 => 26070 | |
| 29 => 26071 | |
| 30 => 26071 | |
| 31 => 26072 | |
| 32 => 26073 | |
| 33 => 26074 | |
| 34 => 26075 | |
| 35 => 26075 | |
| 36 => 26076 | |
| 37 => 26077 | |
| 38 => 26077 | |
| 39 => 26078 | |
| 40 => "App\Models\User" | |
| 41 => 2351 | |
| ] | |
| "time" => 0.96 | |
| ] | |
| ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment