Skip to content

Instantly share code, notes, and snippets.

@Cyberiaaxis
Created April 10, 2018 08:51
Show Gist options
  • Save Cyberiaaxis/916806e444e61414af5165088ebb6d11 to your computer and use it in GitHub Desktop.
Save Cyberiaaxis/916806e444e61414af5165088ebb6d11 to your computer and use it in GitHub Desktop.
array:4 [▼
0 => array:3 [▼
"query" => "select * from `questions` where exists (select * from `question_mappers` where `question_mappers`.`question_id` = `questions`.`id` and `category_id` = ? and `designation_id` = ? and `department_id` = ?) and `questions`.`deleted_at` is null order by RAND()"
"bindings" => array:3 [▼
0 => "3"
1 => "1"
2 => "1"
]
"time" => 6.02
]
1 => array:3 [▼
"query" => "select * from `question_mappers` where `question_mappers`.`question_id` in (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
"bindings" => array:32 [▼
0 => 67
1 => 64
2 => 46
3 => 51
4 => 57
5 => 56
6 => 49
7 => 63
8 => 55
9 => 58
10 => 27
11 => 68
12 => 60
13 => 41
14 => 66
15 => 43
16 => 44
17 => 40
18 => 42
19 => 59
20 => 39
21 => 53
22 => 54
23 => 61
24 => 52
25 => 38
26 => 47
27 => 45
28 => 62
29 => 50
30 => 65
31 => 48
]
"time" => 1.84
]
2 => array:3 [▼
"query" => "select * from `designations` where `designations`.`id` in (?)"
"bindings" => array:1 [▼
0 => 1
]
"time" => 0.79
]
3 => array:3 [▼
"query" => "select * from `question_categories` where `question_categories`.`id` in (?, ?, ?)"
"bindings" => array:3 [▼
0 => 3
1 => 4
2 => 5
]
"time" => 28.65
]
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment