Skip to content

Instantly share code, notes, and snippets.

@doug7410
Created May 16, 2018 20:11
Show Gist options
  • Save doug7410/9c33d5a22488118e5aeb326731b6242b to your computer and use it in GitHub Desktop.
Save doug7410/9c33d5a22488118e5aeb326731b6242b to your computer and use it in GitHub Desktop.
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