· 7 years ago · Dec 21, 2018, 08:18 PM
1RuleSet Load (140.9ms) SELECT `rule_sets`.* FROM `rule_sets` WHERE `rule_sets`.`id` = 701 LIMIT 1
2 Client Load (142.9ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 26 LIMIT 1
3INFO : (12-21 18:08:49) rule configurations: Weekends
4 - 'Days Between Same Assignment' applied {} weight:10
5 - 'Cumulative Assignment Targets' not applied
6 - 'Cumulative Combined Assignment Targets' not applied
7 - 'Cumulative Daily Assignment Targets' not applied
8 - 'Cumulative Day of Week Targets' not applied
9 - 'Cumulative Hour Targets' not applied
10 - 'Cumulative Point Targets' not applied
11 - 'Cumulative Weekend / Weekday Assignment Targets' not applied
12 - 'Cumulative Weekend / Weekday Combined Assignment Targets' not applied
13 - 'Cumulative Weekend / Weekday Hour Targets' not applied
14 - 'Cumulative Weekend / Weekday Point Targets' not applied
15 - 'Current Assignment Targets' not applied
16 - 'Current Combined Assignment Targets' not applied
17 - 'Current Daily Assignment Targets' not applied
18 - 'Current Day of Week Targets' not applied
19 - 'Current Hour Targets' not applied
20 - 'Current Point Targets' not applied
21 - 'Current Weekend / Weekday Assignment Targets' not applied
22 - 'Current Weekend / Weekday Combined Assignment Targets' not applied
23 - 'Current Weekend / Weekday Hour Targets' not applied
24 - 'Current Weekend / Weekday Point Targets' not applied
25 - 'Pending Call Requests' not applied
26 - 'Pending No-call Requests' not applied
27 - 'Assignments Per Day' not applied
28 - 'Days Between Assignments' not applied
29 - 'Unassigned Days' not applied
30 - 'Weeks Between Same Assignment On Same Day Of Week' not applied
31 - 'Weeks Between Same Day Of Week' not applied
32INFO : (12-21 18:08:49) started: Scheduler::Cache::Collector.collect_all
33INFO : (12-21 18:08:49) collect_staffs
34 Staff Load (143.4ms) SELECT DISTINCT `staffs`.* FROM `staffs` INNER JOIN `staff_entities` `staff_entities_staffs` ON `staff_entities_staffs`.`staff_id` = `staffs`.`id` INNER JOIN `assign_staff_types` ON `assign_staff_types`.`staff_id` = `staffs`.`id` INNER JOIN `staff_types` ON `staff_types`.`id` = `assign_staff_types`.`staff_type_id` INNER JOIN `staff_entities` ON `staffs`.`id` = `staff_entities`.`staff_id` WHERE `staff_entities`.`entity_id` = 26 AND `staffs`.`take_call` = 1 AND `staffs`.`active` = 1 ORDER BY staff_entities.entity_id, staff_entities.display_order, last_name, first_name
35 Client Load (143.7ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 26
36 StaffSpecialization Load (141.0ms) SELECT `staff_specializations`.* FROM `staff_specializations` WHERE `staff_specializations`.`staff_id` IN (828, 829, 831, 832, 833, 834, 12736, 9364, 835)
37 StaffCallType Load (142.5ms) SELECT `staff_call_types`.* FROM `staff_call_types` WHERE `staff_call_types`.`staff_id` IN (828, 829, 831, 832, 833, 834, 12736, 9364, 835)
38INFO : (12-21 18:08:51) initial eligibles: [828,829,831,832,833,834,12736,9364,835]
39INFO : (12-21 18:08:51) collect_call_types
40 CallType Load (142.5ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`client_id` = 26 AND `call_types`.`active` = 1 ORDER BY `call_types`.`display_order` ASC
41INFO : (12-21 18:08:51) initial call types: [11456,11457,308,303,304,5502,305,306]
42INFO : (12-21 18:08:51) collect_chain_links
43 ChainLink Load (141.8ms) SELECT `chain_links`.* FROM `chain_links` WHERE `chain_links`.`client_id` = 26
44 CallType Load (142.1ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`id` IN (11457, 308, 11456, 306)
45 CallType Load (142.2ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`id` IN (308, 11457, 306, 11456)
46INFO : (12-21 18:08:52) collect_linkages
47INFO : (12-21 18:08:52) collect_schedules
48 Schedule Load (141.4ms) SELECT `schedules`.* FROM `schedules` WHERE `schedules`.`client_id` = 26 AND (`schedules`.`schedule_on` BETWEEN '2018-01-01' AND '2018-03-31')
49INFO : (12-21 18:08:52) collect_slots
50INFO : (12-21 18:08:52) collect_approved_call_requests
51 Request Load (142.2ms) SELECT `requests`.* FROM `requests` INNER JOIN `staffs` ON `staffs`.`id` = `requests`.`staff_id` WHERE `requests`.`client_id` = 26 AND `requests`.`request_type` = 1 AND `requests`.`status` = 1 AND (`requests`.`schedule_on` BETWEEN '2018-01-01' AND '2018-03-31') ORDER BY requests.schedule_on ASC, staffs.request_priority ASC, requests.created_at ASC
52INFO : (12-21 18:08:53) collect_approved_no_call_requests
53 Request Load (141.8ms) SELECT `requests`.* FROM `requests` WHERE `requests`.`client_id` = 26 AND `requests`.`request_type` = 0 AND `requests`.`status` = 1 AND (`requests`.`schedule_on` BETWEEN '2018-01-01' AND '2018-03-31') ORDER BY requests.schedule_on asc, requests.created_at asc
54INFO : (12-21 18:08:53) finished: Scheduler::Cache::Collector.collect_all
55INFO : (12-21 18:08:53) == begin to process requests
56 CallType Load (142.7ms) SELECT `call_types`.* FROM `call_types` WHERE `call_types`.`calendar_schedule_id` = 26 AND `call_types`.`active` = 1
57 (144.8ms) SELECT MAX(blocks.end_date) FROM `published_blocks` INNER JOIN `blocks` ON `blocks`.`id` = `published_blocks`.`block_id` WHERE `published_blocks`.`calendar_schedule_id` = 26 AND ((published_blocks.assignment_ids IS NULL) AND (published_blocks.days_of_week_mask = 127))
58 Request Load (142.5ms) SELECT distinct requests.* FROM `requests` INNER JOIN `request_call_types` ON `request_call_types`.`request_id` = `requests`.`id` WHERE `requests`.`client_id` = 26 AND `requests`.`status` = 1 AND `requests`.`request_type` = 1 AND `request_call_types`.`call_type_id` IN (303, 304, 305, 306, 308, 5502, 11456, 11457) AND (requests.schedule_on > '2017-03-31')
59 SQL (146.9ms) UPDATE `schedules` SET `schedules`.`populate_method` = 'auto_approved_request', `schedules`.`creator_id` = 834 WHERE `schedules`.`client_id` = 26 AND 1=0
60INFO : (12-21 18:08:54) == end of requests processing
61INFO : (12-21 18:08:54) == begin prepopulate process
62 Block Load (141.9ms) SELECT `blocks`.* FROM `blocks` INNER JOIN `block_schedules` ON `blocks`.`block_schedule_id` = `block_schedules`.`id` WHERE `block_schedules`.`id` = 26 AND (blocks.start_date <= '2018-03-31' AND blocks.end_date >= '2018-03-31') ORDER BY start_date asc, end_date asc LIMIT 1
63 Block Load (145.1ms) SELECT `blocks`.* FROM `blocks` WHERE `blocks`.`client_id` = 26 AND `blocks`.`block_schedule_id` = 26 AND (blocks.end_date < '2018-03-01') AND (blocks.id != 19128) ORDER BY start_date desc
64 Client Load (168.8ms) SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 26 LIMIT 1
65INFO : (12-21 18:08:55) <-- clear: 0 - Scheduler::AutoPopulate::Queries::CreateTables
66INFO : (12-21 18:08:55) <-- clear: 1 - Scheduler::AutoPopulate::Queries::Query001_PR_01
67INFO : (12-21 18:08:55) <-- clear: 2 - Scheduler::AutoPopulate::Queries::Query001_PR_02
68INFO : (12-21 18:08:55) <-- clear: 3 - Scheduler::AutoPopulate::Queries::Query001_PR_03
69INFO : (12-21 18:08:55) <-- clear: 4 - Scheduler::AutoPopulate::Queries::Query001_PR_04
70INFO : (12-21 18:08:55) <-- clear: 5 - Scheduler::AutoPopulate::Queries::Query001_PR_05
71INFO : (12-21 18:08:55) <-- clear: 6 - Scheduler::AutoPopulate::Queries::Query005
72INFO : (12-21 18:08:55) <-- clear: 7 - Scheduler::AutoPopulate::Queries::Query01
73INFO : (12-21 18:08:55) <-- clear: 8 - Scheduler::AutoPopulate::Queries::Query012
74INFO : (12-21 18:08:55) <-- clear: 9 - Scheduler::AutoPopulate::Queries::QueryTargets
75INFO : (12-21 18:08:55) <-- clear: 10 - Scheduler::AutoPopulate::Queries::Query013
76INFO : (12-21 18:08:55) <-- clear: 11 - Scheduler::AutoPopulate::Queries::Query014
77INFO : (12-21 18:08:55) <-- clear: 12 - Scheduler::AutoPopulate::Queries::Query015_PR
78INFO : (12-21 18:08:55) <-- clear: 13 - Scheduler::AutoPopulate::Queries::Query016
79INFO : (12-21 18:08:55) <-- clear: 14 - Scheduler::AutoPopulate::Queries::Query02
80INFO : (12-21 18:08:55) <-- clear: 15 - Scheduler::AutoPopulate::Queries::Query03
81INFO : (12-21 18:08:55) <-- clear: 16 - Scheduler::AutoPopulate::Queries::Query04
82INFO : (12-21 18:08:55) <-- clear: 17 - Scheduler::AutoPopulate::Queries::Query045
83INFO : (12-21 18:08:55) <-- clear: 18 - Scheduler::AutoPopulate::Queries::QueryA
84INFO : (12-21 18:08:55) <-- clear: 19 - Scheduler::AutoPopulate::Queries::QueryB
85INFO : (12-21 18:08:55) <-- clear: 20 - Scheduler::AutoPopulate::Queries::Query05
86INFO : (12-21 18:08:55) <-- clear: 21 - Scheduler::AutoPopulate::Queries::Query06
87INFO : (12-21 18:08:55) <-- clear: 22 - Scheduler::AutoPopulate::Queries::Query07
88INFO : (12-21 18:08:55) <-- clear: 23 - Scheduler::AutoPopulate::Queries::Query0702
89INFO : (12-21 18:08:55) <-- clear: 24 - Scheduler::AutoPopulate::Queries::Query0705
90INFO : (12-21 18:08:55) <-- clear: 25 - Scheduler::AutoPopulate::Queries::Query0706
91INFO : (12-21 18:08:55) <-- clear: 26 - Scheduler::AutoPopulate::Queries::Query0707
92INFO : (12-21 18:08:55) <-- clear: 27 - Scheduler::AutoPopulate::Queries::Query0708
93INFO : (12-21 18:08:55) <-- clear: 28 - Scheduler::AutoPopulate::Queries::Query0709
94INFO : (12-21 18:08:55) <-- clear: 29 - Scheduler::AutoPopulate::Queries::Query08
95INFO : (12-21 18:08:55) <-- clear: 30 - Scheduler::AutoPopulate::Queries::Query085
96INFO : (12-21 18:08:55) <-- clear: 31 - Scheduler::AutoPopulate::Queries::Query09_PR
97INFO : (12-21 18:08:55) <-- clear: 32 - Scheduler::AutoPopulate::Queries::Query092
98INFO : (12-21 18:08:55) <-- clear: 33 - Scheduler::AutoPopulate::Queries::Query093
99INFO : (12-21 18:08:55) <-- clear: 34 - Scheduler::AutoPopulate::Queries::Query095
100INFO : (12-21 18:08:55) <-- clear: 35 - Scheduler::AutoPopulate::Queries::Query097
101INFO : (12-21 18:08:55) <-- clear: 36 - Scheduler::AutoPopulate::Queries::Query098
102INFO : (12-21 18:08:55) <-- clear: 37 - Scheduler::AutoPopulate::Queries::Query09_09_AL
103INFO : (12-21 18:08:55) <-- clear: 38 - Scheduler::AutoPopulate::Queries::AssignmentLimitApplicability
104INFO : (12-21 18:08:55) <-- clear: 39 - Scheduler::AutoPopulate::Queries::Query09_09_AL_01
105INFO : (12-21 18:08:55) <-- clear: 40 - Scheduler::AutoPopulate::Queries::Query09_09_AL_02
106INFO : (12-21 18:08:55) <-- clear: 41 - Scheduler::AutoPopulate::Queries::Query09_09_AL_03
107INFO : (12-21 18:08:55) <-- clear: 42 - Scheduler::AutoPopulate::Queries::Query09_09_AL_04
108INFO : (12-21 18:08:55) <-- clear: 43 - Scheduler::AutoPopulate::Queries::Query09_09_AL_05
109INFO : (12-21 18:08:55) <-- clear: 44 - Scheduler::AutoPopulate::Queries::Query09_09_AL_06
110INFO : (12-21 18:08:55) <-- clear: 45 - Scheduler::AutoPopulate::Queries::Query09_12_Points
111INFO : (12-21 18:08:55) <-- clear: 46 - Scheduler::AutoPopulate::Queries::Query09_12_Hours
112INFO : (12-21 18:08:55) <-- clear: 47 - Scheduler::AutoPopulate::Queries::Query10
113INFO : (12-21 18:08:55) <-- clear: 48 - Scheduler::AutoPopulate::Queries::QueryScore02
114INFO : (12-21 18:08:55) <-- clear: 49 - Scheduler::AutoPopulate::Queries::QueryScore03
115INFO : (12-21 18:08:55) <-- clear: 50 - Scheduler::AutoPopulate::Queries::QueryScore04
116INFO : (12-21 18:08:55) <-- clear: 51 - Scheduler::AutoPopulate::Queries::Query11
117INFO : (12-21 18:08:55) <-- clear: 52 - Scheduler::AutoPopulate::Queries::DropTables
118 (143.5ms) DROP TABLE IF EXISTS buffer_annual_hour_targets_2146882400
119 (142.5ms) DROP TABLE IF EXISTS buffer_annual_point_targets_2146882400
120 (142.9ms) DROP TABLE IF EXISTS buffer_annual_targets_staff_totals_2146882400
121 (142.5ms) DROP TABLE IF EXISTS buffer_auto_populate_slots_2146882400
122 (142.3ms) DROP TABLE IF EXISTS buffer_call_days_targets_2146882400
123 (144.8ms) DROP TABLE IF EXISTS buffer_call_type_targets_2146882400
124 (143.3ms) DROP TABLE IF EXISTS buffer_cumulative_cd_targets_2146882400
125 (142.4ms) DROP TABLE IF EXISTS buffer_cumulative_ct_targets_2146882400
126 (142.5ms) DROP TABLE IF EXISTS buffer_cumulative_dow_targets_2146882400
127 (142.7ms) DROP TABLE IF EXISTS buffer_cumulative_hour_targets_2146882400
128 (144.3ms) DROP TABLE IF EXISTS buffer_cumulative_oa_targets_2146882400
129 (142.6ms) DROP TABLE IF EXISTS buffer_cumulative_point_targets_2146882400
130 (142.9ms) DROP TABLE IF EXISTS buffer_current_cd_targets_2146882400
131 (143.1ms) DROP TABLE IF EXISTS buffer_current_ct_targets_2146882400
132 (152.0ms) DROP TABLE IF EXISTS buffer_current_dow_targets_2146882400
133 (144.3ms) DROP TABLE IF EXISTS buffer_current_hour_targets_2146882400
134 (144.6ms) DROP TABLE IF EXISTS buffer_current_oa_targets_2146882400
135 (142.3ms) DROP TABLE IF EXISTS buffer_current_point_targets_2146882400
136 (142.6ms) DROP TABLE IF EXISTS buffer_day_of_week_targets_2146882400
137 (142.3ms) DROP TABLE IF EXISTS buffer_hour_targets_2146882400
138 (142.6ms) DROP TABLE IF EXISTS buffer_linkage_call_days_targets_2146882400
139 (142.5ms) DROP TABLE IF EXISTS buffer_linkage_call_type_targets_2146882400
140 (146.9ms) DROP TABLE IF EXISTS buffer_linkage_targets_2146882400
141 (142.7ms) DROP TABLE IF EXISTS buffer_linkage_hour_targets_2146882400
142 (142.3ms) DROP TABLE IF EXISTS buffer_linkage_point_targets_2146882400
143 (146.0ms) DROP TABLE IF EXISTS buffer_location_privileges_2146882400
144 (142.8ms) DROP TABLE IF EXISTS buffer_periods_2146882400
145 (142.6ms) DROP TABLE IF EXISTS buffer_point_targets_2146882400
146 (142.5ms) DROP TABLE IF EXISTS buffer_schedules_2146882400
147 (142.7ms) DROP TABLE IF EXISTS buffer_target_call_types_2146882400
148 (142.8ms) DROP TABLE IF EXISTS buffer_target_daily_points_2146882400
149 (142.5ms) DROP TABLE IF EXISTS buffer_target_dates_list_2146882400
150 (142.5ms) DROP TABLE IF EXISTS buffer_target_primary_availabilities_2146882400
151 (142.3ms) DROP TABLE IF EXISTS buffer_targets_2146882400
152 (158.7ms) DROP TABLE IF EXISTS buffer_tmp_targets_availabilities_2146882400
153 (142.6ms) DROP TABLE IF EXISTS buffer_tmp_targets_availabilities_exclusions_2146882400
154 (142.4ms) DROP TABLE IF EXISTS buffer_tmp_targets_client_totals_2146882400
155 (154.2ms) DROP TABLE IF EXISTS buffer_tmp_targets_scheduled_2146882400
156 (142.5ms) DROP TABLE IF EXISTS buffer_tmp_targets_staff_totals_2146882400
157 (142.5ms) DROP TABLE IF EXISTS buffer_prepopulate_steps_2146882400
158 (142.5ms) DROP TABLE IF EXISTS buffer_prepopulate_dates_2146882400
159 (142.8ms) DROP TABLE IF EXISTS buffer_prepopulate_periods_2146882400
160 (142.7ms) DROP TABLE IF EXISTS buffer_prepopulate_assignments_2146882400
161 (143.0ms) DROP TABLE IF EXISTS buffer_prepopulate_staff_schedules_2146882400
162 (144.5ms) DROP TABLE IF EXISTS buffer_assignment_limit_call_types_2146882400
163 (142.4ms) DROP TABLE IF EXISTS buffer_assignment_limit_periods_2146882400
164 (146.6ms) DROP TABLE IF EXISTS buffer_assignment_limit_staff_types_2146882400
165 (145.7ms) DROP TABLE IF EXISTS buffer_assignment_limit_staffs_2146882400
166 (144.7ms) DROP TABLE IF EXISTS buffer_auto_populate_slots_2146882400
167 (142.8ms) DROP TABLE IF EXISTS buffer_call_type_assignments_2146882400
168 (142.4ms) DROP TABLE IF EXISTS buffer_combined_availabilities_2146882400
169 (142.6ms) DROP TABLE IF EXISTS buffer_combined_availability_linkages_2146882400
170 (142.3ms) DROP TABLE IF EXISTS buffer_counter_increments_2146882400
171 (142.2ms) DROP TABLE IF EXISTS buffer_linkage_assigned_days_2146882400
172 (144.8ms) DROP TABLE IF EXISTS buffer_linkage_call_type_assignments_2146882400
173 (144.7ms) DROP TABLE IF EXISTS buffer_linkage_dow_targets_2146882400
174 (142.6ms) DROP TABLE IF EXISTS buffer_linkage_patterns_2146882400
175 (142.4ms) DROP TABLE IF EXISTS buffer_linkages_2146882400
176 (143.7ms) DROP TABLE IF EXISTS buffer_location_privileges_2146882400
177 (142.4ms) DROP TABLE IF EXISTS buffer_min_distances_2146882400
178 (142.3ms) DROP TABLE IF EXISTS buffer_negative_relations_2146882400
179 (142.6ms) DROP TABLE IF EXISTS buffer_rule_calc_filters_2146882400
180 (142.9ms) DROP TABLE IF EXISTS buffer_rule_calc_schedules_2146882400
181 (144.7ms) DROP TABLE IF EXISTS buffer_rule_scores_2146882400
182 (142.3ms) DROP TABLE IF EXISTS buffer_rule_scores_with_corrections_2146882400
183 (142.6ms) DROP TABLE IF EXISTS buffer_schedule_linkages_2146882400
184 (142.7ms) DROP TABLE IF EXISTS buffer_schedules_linkage_patterns_2146882400
185 (142.5ms) DROP TABLE IF EXISTS buffer_specialization_daily_counts_2146882400
186 (142.5ms) DROP TABLE IF EXISTS buffer_staff_assigned_days_2146882400
187 (143.8ms) DROP TABLE IF EXISTS buffer_staff_daily_counts_2146882400
188 (142.3ms) DROP TABLE IF EXISTS buffer_staff_specializations_2146882400
189 (143.0ms) DROP TABLE IF EXISTS buffer_static_availabilities_2146882400
190 (149.2ms) DROP TABLE IF EXISTS buffer_target_assignments_2146882400
191 (142.3ms) DROP TABLE IF EXISTS buffer_linkage_assignment_limits_2146882400
192 (142.6ms) DROP TABLE IF EXISTS buffer_staff_assignment_limits_2146882400
193 (142.6ms) DROP TABLE IF EXISTS buffer_assignment_limits_2146882400
194 (140.5ms) delete from buffer_target_dates
195 where session_id = 2146882400
196
197INFO : (12-21 18:09:06) --> fill: 0 - Scheduler::AutoPopulate::Queries::CreateTables
198 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_assignment_limit_call_types_2146882400 LIKE buffer_assignment_limit_call_types
199 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_assignment_limit_periods_2146882400 LIKE buffer_assignment_limit_periods
200 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_assignment_limit_staff_types_2146882400 LIKE buffer_assignment_limit_staff_types
201 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_assignment_limit_staffs_2146882400 LIKE buffer_assignment_limit_staffs
202 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_auto_populate_slots_2146882400 LIKE buffer_auto_populate_slots
203 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_call_type_assignments_2146882400 LIKE buffer_call_type_assignments
204 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_combined_availabilities_2146882400 LIKE buffer_combined_availabilities
205 (151.1ms) CREATE TABLE IF NOT EXISTS buffer_combined_availability_linkages_2146882400 LIKE buffer_combined_availability_linkages
206 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_counter_increments_2146882400 LIKE buffer_counter_increments
207 (145.5ms) CREATE TABLE IF NOT EXISTS buffer_linkage_assigned_days_2146882400 LIKE buffer_linkage_assigned_days
208 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_linkage_call_type_assignments_2146882400 LIKE buffer_linkage_call_type_assignments
209 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_linkage_dow_targets_2146882400 LIKE buffer_linkage_dow_targets
210 (144.1ms) CREATE TABLE IF NOT EXISTS buffer_linkage_patterns_2146882400 LIKE buffer_linkage_patterns
211 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_linkages_2146882400 LIKE buffer_linkages
212 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_location_privileges_2146882400 LIKE buffer_location_privileges
213 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_min_distances_2146882400 LIKE buffer_min_distances
214 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_negative_relations_2146882400 LIKE buffer_negative_relations
215 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_rule_calc_filters_2146882400 LIKE buffer_rule_calc_filters
216 (155.8ms) CREATE TABLE IF NOT EXISTS buffer_rule_calc_schedules_2146882400 LIKE buffer_rule_calc_schedules
217 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_rule_scores_2146882400 LIKE buffer_rule_scores
218 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_rule_scores_with_corrections_2146882400 LIKE buffer_rule_scores_with_corrections
219 (144.1ms) CREATE TABLE IF NOT EXISTS buffer_schedule_linkages_2146882400 LIKE buffer_schedule_linkages
220 (145.5ms) CREATE TABLE IF NOT EXISTS buffer_schedules_linkage_patterns_2146882400 LIKE buffer_schedules_linkage_patterns
221 (144.2ms) CREATE TABLE IF NOT EXISTS buffer_specialization_daily_counts_2146882400 LIKE buffer_specialization_daily_counts
222 (144.1ms) CREATE TABLE IF NOT EXISTS buffer_staff_assigned_days_2146882400 LIKE buffer_staff_assigned_days
223 (144.1ms) CREATE TABLE IF NOT EXISTS buffer_staff_daily_counts_2146882400 LIKE buffer_staff_daily_counts
224 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_staff_specializations_2146882400 LIKE buffer_staff_specializations
225 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_static_availabilities_2146882400 LIKE buffer_static_availabilities
226 (154.8ms) CREATE TABLE IF NOT EXISTS buffer_target_assignments_2146882400 LIKE buffer_target_assignments
227 (145.2ms) CREATE TABLE IF NOT EXISTS buffer_linkage_assignment_limits_2146882400 LIKE buffer_linkage_assignment_limits
228 (144.8ms) CREATE TABLE IF NOT EXISTS buffer_staff_assignment_limits_2146882400 LIKE buffer_staff_assignment_limits
229 (146.0ms) CREATE TABLE IF NOT EXISTS buffer_assignment_limits_2146882400 LIKE buffer_assignment_limits
230 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_prepopulate_steps_2146882400 LIKE buffer_prepopulate_steps
231 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_prepopulate_dates_2146882400 LIKE buffer_prepopulate_dates
232 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_prepopulate_periods_2146882400 LIKE buffer_prepopulate_periods
233 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_prepopulate_assignments_2146882400 LIKE buffer_prepopulate_assignments
234 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_prepopulate_staff_schedules_2146882400 LIKE buffer_prepopulate_staff_schedules
235 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_annual_hour_targets_2146882400 LIKE buffer_annual_hour_targets
236 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_annual_point_targets_2146882400 LIKE buffer_annual_point_targets
237 (145.0ms) CREATE TABLE IF NOT EXISTS buffer_annual_targets_staff_totals_2146882400 LIKE buffer_annual_targets_staff_totals
238 (143.0ms) CREATE TABLE IF NOT EXISTS buffer_auto_populate_slots_2146882400 LIKE buffer_auto_populate_slots
239 (146.2ms) CREATE TABLE IF NOT EXISTS buffer_call_days_targets_2146882400 LIKE buffer_call_days_targets
240 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_call_type_targets_2146882400 LIKE buffer_call_type_targets
241 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_cd_targets_2146882400 LIKE buffer_cumulative_cd_targets
242 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_ct_targets_2146882400 LIKE buffer_cumulative_ct_targets
243 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_dow_targets_2146882400 LIKE buffer_cumulative_dow_targets
244 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_hour_targets_2146882400 LIKE buffer_cumulative_hour_targets
245 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_oa_targets_2146882400 LIKE buffer_cumulative_oa_targets
246 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_cumulative_point_targets_2146882400 LIKE buffer_cumulative_point_targets
247 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_current_cd_targets_2146882400 LIKE buffer_current_cd_targets
248 (144.8ms) CREATE TABLE IF NOT EXISTS buffer_current_ct_targets_2146882400 LIKE buffer_current_ct_targets
249 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_current_dow_targets_2146882400 LIKE buffer_current_dow_targets
250 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_current_hour_targets_2146882400 LIKE buffer_current_hour_targets
251 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_current_oa_targets_2146882400 LIKE buffer_current_oa_targets
252 (145.1ms) CREATE TABLE IF NOT EXISTS buffer_current_point_targets_2146882400 LIKE buffer_current_point_targets
253 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_day_of_week_targets_2146882400 LIKE buffer_day_of_week_targets
254 (144.8ms) CREATE TABLE IF NOT EXISTS buffer_hour_targets_2146882400 LIKE buffer_hour_targets
255 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_linkage_call_days_targets_2146882400 LIKE buffer_linkage_call_days_targets
256 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_linkage_call_type_targets_2146882400 LIKE buffer_linkage_call_type_targets
257 (144.4ms) CREATE TABLE IF NOT EXISTS buffer_linkage_targets_2146882400 LIKE buffer_linkage_targets
258 (144.2ms) CREATE TABLE IF NOT EXISTS buffer_linkage_hour_targets_2146882400 LIKE buffer_linkage_hour_targets
259 (144.6ms) CREATE TABLE IF NOT EXISTS buffer_linkage_point_targets_2146882400 LIKE buffer_linkage_point_targets
260 (142.4ms) CREATE TABLE IF NOT EXISTS buffer_location_privileges_2146882400 LIKE buffer_location_privileges
261 (145.0ms) CREATE TABLE IF NOT EXISTS buffer_periods_2146882400 LIKE buffer_periods
262 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_point_targets_2146882400 LIKE buffer_point_targets
263 (145.2ms) CREATE TABLE IF NOT EXISTS buffer_schedules_2146882400 LIKE buffer_schedules
264 (146.6ms) CREATE TABLE IF NOT EXISTS buffer_target_call_types_2146882400 LIKE buffer_target_call_types
265 (145.5ms) CREATE TABLE IF NOT EXISTS buffer_target_daily_points_2146882400 LIKE buffer_target_daily_points
266 (144.8ms) CREATE TABLE IF NOT EXISTS buffer_target_dates_list_2146882400 LIKE buffer_target_dates_list
267 (144.3ms) CREATE TABLE IF NOT EXISTS buffer_target_primary_availabilities_2146882400 LIKE buffer_target_primary_availabilities
268 (144.9ms) CREATE TABLE IF NOT EXISTS buffer_targets_2146882400 LIKE buffer_targets
269 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_tmp_targets_availabilities_2146882400 LIKE buffer_tmp_targets_availabilities
270 (144.7ms) CREATE TABLE IF NOT EXISTS buffer_tmp_targets_availabilities_exclusions_2146882400 LIKE buffer_tmp_targets_availabilities_exclusions
271 (144.5ms) CREATE TABLE IF NOT EXISTS buffer_tmp_targets_client_totals_2146882400 LIKE buffer_tmp_targets_client_totals
272 (145.1ms) CREATE TABLE IF NOT EXISTS buffer_tmp_targets_scheduled_2146882400 LIKE buffer_tmp_targets_scheduled
273 (149.0ms) CREATE TABLE IF NOT EXISTS buffer_tmp_targets_staff_totals_2146882400 LIKE buffer_tmp_targets_staff_totals
274INFO : (12-21 18:09:17) --> fill: 1 - Scheduler::AutoPopulate::Queries::Query001_PR_01
275 (143.4ms) insert into buffer_prepopulate_steps_2146882400 (
276 rule_id,
277 rule_type,
278 rule_subtype,
279 staff_id,
280 x,
281 days_of_week_mask,
282 start_date,
283 start_date_first_dow,
284 required_assignments
285 )
286 select
287 pr.id as rule_id,
288 pr.rule_type,
289 coalesce(rrt.recurring_type, mrt.timeframe) as rule_subtype,
290 pr.staff_id,
291 rrt.frequency as x,
292 case
293 when (rrt.days_of_week_mask = 0) then 127
294 else coalesce(rrt.days_of_week_mask, mrt.days_of_week_mask)
295 end as days_of_week_mask,
296 rrt.start_date,
297 case
298 when (cl.start_of_week = 0) then
299 date_add(rrt.start_date, interval -(dayofweek(rrt.start_date) - 1) day)
300 else
301 date_add(rrt.start_date, interval -weekday(rrt.start_date) day)
302 end as start_date_first_dow,
303 case
304 when (rrt.id is not null) then 1
305 else mrt.number_to_assign
306 end as required_assignments
307 from
308 clients as cl
309 inner join prepopulate_rules as pr
310 on pr.autopopulate_step_id = 1735
311 left join recurring_rule_types as rrt
312 on pr.id = rrt.prepopulate_rule_id
313 left join minimum_rule_types as mrt
314 on pr.id = mrt.prepopulate_rule_id
315 where cl.id = 26
316 order by
317 pr.display_order,
318 coalesce(rrt.display_order, mrt.display_order)
319
320INFO : (12-21 18:09:17) --> fill: 2 - Scheduler::AutoPopulate::Queries::Query001_PR_02
321 (144.4ms) insert into buffer_prepopulate_dates_2146882400 (
322 day,
323 schedule_on,
324 day_of_week_mask,
325 week,
326 first_dow,
327 last_dow,
328 month,
329 first_dom,
330 last_dom,
331 block,
332 first_dob,
333 last_dob
334 )
335 select
336 dl.day,
337 dl.schedule_on,
338 (1 << (dayofweek(dl.schedule_on) - 1)) as day_of_week_mask,
339 yearweek(dl.schedule_on, dl.week_mode) as week,
340 case
341 when (dl.start_of_week = 0) then
342 date_add(dl.schedule_on, interval -(dayofweek(dl.schedule_on) - 1) day)
343 else
344 date_add(dl.schedule_on, interval -weekday(dl.schedule_on) day)
345 end as first_dow,
346 case
347 when (dl.start_of_week = 0) then
348 date_add(dl.schedule_on, interval (7 - dayofweek(dl.schedule_on)) day)
349 else
350 date_add(dl.schedule_on, interval (6 - weekday(dl.schedule_on)) day)
351 end as last_dow,
352 (year(dl.schedule_on) * 100 + month(dl.schedule_on)) as month,
353 date_add(dl.schedule_on, interval (1 - dayofmonth(dl.schedule_on)) day) as first_dom,
354 last_day(dl.schedule_on) as last_dom,
355 dl.block_id as block,
356 dl.start_date as first_dob,
357 dl.end_date as last_dob
358 from (
359 select
360 (ns.item_number + 1) as day,
361 date_add(b.start_date, interval ns.item_number day) as schedule_on,
362 b.id as block_id,
363 b.start_date,
364 b.end_date,
365 cl.start_of_week,
366 case
367 when (cl.start_of_week = 0) then 2
368 else 7
369 end as week_mode
370 from
371 clients as cl
372 inner join blocks as b
373 on b.id in (18222,18678,19128)
374 inner join numeric_sequence as ns
375 on ns.item_number <= datediff(b.end_date, b.start_date)
376 where cl.id = 26
377 order by null
378 ) as dl
379 order by null
380
381INFO : (12-21 18:09:17) <-- clear: 0 - Scheduler::AutoPopulate::Queries::CreateTables
382INFO : (12-21 18:09:17) <-- clear: 1 - Scheduler::AutoPopulate::Queries::Query001_PR_01
383INFO : (12-21 18:09:17) <-- clear: 2 - Scheduler::AutoPopulate::Queries::Query001_PR_02
384INFO : (12-21 18:09:17) <-- clear: 3 - Scheduler::AutoPopulate::Queries::Query001_PR_03
385INFO : (12-21 18:09:17) <-- clear: 4 - Scheduler::AutoPopulate::Queries::Query001_PR_04
386INFO : (12-21 18:09:17) <-- clear: 5 - Scheduler::AutoPopulate::Queries::Query001_PR_05
387INFO : (12-21 18:09:17) <-- clear: 6 - Scheduler::AutoPopulate::Queries::Query005
388INFO : (12-21 18:09:17) <-- clear: 7 - Scheduler::AutoPopulate::Queries::Query01
389INFO : (12-21 18:09:17) <-- clear: 8 - Scheduler::AutoPopulate::Queries::Query012
390INFO : (12-21 18:09:17) <-- clear: 9 - Scheduler::AutoPopulate::Queries::QueryTargets
391INFO : (12-21 18:09:17) <-- clear: 10 - Scheduler::AutoPopulate::Queries::Query013
392INFO : (12-21 18:09:17) <-- clear: 11 - Scheduler::AutoPopulate::Queries::Query014
393INFO : (12-21 18:09:17) <-- clear: 12 - Scheduler::AutoPopulate::Queries::Query015_PR
394INFO : (12-21 18:09:17) <-- clear: 13 - Scheduler::AutoPopulate::Queries::Query016
395INFO : (12-21 18:09:17) <-- clear: 14 - Scheduler::AutoPopulate::Queries::Query02
396INFO : (12-21 18:09:17) <-- clear: 15 - Scheduler::AutoPopulate::Queries::Query03
397INFO : (12-21 18:09:17) <-- clear: 16 - Scheduler::AutoPopulate::Queries::Query04
398INFO : (12-21 18:09:17) <-- clear: 17 - Scheduler::AutoPopulate::Queries::Query045
399INFO : (12-21 18:09:17) <-- clear: 18 - Scheduler::AutoPopulate::Queries::QueryA
400INFO : (12-21 18:09:17) <-- clear: 19 - Scheduler::AutoPopulate::Queries::QueryB
401INFO : (12-21 18:09:17) <-- clear: 20 - Scheduler::AutoPopulate::Queries::Query05
402INFO : (12-21 18:09:17) <-- clear: 21 - Scheduler::AutoPopulate::Queries::Query06
403INFO : (12-21 18:09:17) <-- clear: 22 - Scheduler::AutoPopulate::Queries::Query07
404INFO : (12-21 18:09:17) <-- clear: 23 - Scheduler::AutoPopulate::Queries::Query0702
405INFO : (12-21 18:09:17) <-- clear: 24 - Scheduler::AutoPopulate::Queries::Query0705
406INFO : (12-21 18:09:17) <-- clear: 25 - Scheduler::AutoPopulate::Queries::Query0706
407INFO : (12-21 18:09:17) <-- clear: 26 - Scheduler::AutoPopulate::Queries::Query0707
408INFO : (12-21 18:09:17) <-- clear: 27 - Scheduler::AutoPopulate::Queries::Query0708
409INFO : (12-21 18:09:17) <-- clear: 28 - Scheduler::AutoPopulate::Queries::Query0709
410INFO : (12-21 18:09:17) <-- clear: 29 - Scheduler::AutoPopulate::Queries::Query08
411INFO : (12-21 18:09:17) <-- clear: 30 - Scheduler::AutoPopulate::Queries::Query085
412INFO : (12-21 18:09:17) <-- clear: 31 - Scheduler::AutoPopulate::Queries::Query09_PR
413INFO : (12-21 18:09:17) <-- clear: 32 - Scheduler::AutoPopulate::Queries::Query092
414INFO : (12-21 18:09:17) <-- clear: 33 - Scheduler::AutoPopulate::Queries::Query093
415INFO : (12-21 18:09:17) <-- clear: 34 - Scheduler::AutoPopulate::Queries::Query095
416INFO : (12-21 18:09:17) <-- clear: 35 - Scheduler::AutoPopulate::Queries::Query097
417INFO : (12-21 18:09:17) <-- clear: 36 - Scheduler::AutoPopulate::Queries::Query098
418INFO : (12-21 18:09:17) <-- clear: 37 - Scheduler::AutoPopulate::Queries::Query09_09_AL
419INFO : (12-21 18:09:17) <-- clear: 38 - Scheduler::AutoPopulate::Queries::AssignmentLimitApplicability
420INFO : (12-21 18:09:17) <-- clear: 39 - Scheduler::AutoPopulate::Queries::Query09_09_AL_01
421INFO : (12-21 18:09:17) <-- clear: 40 - Scheduler::AutoPopulate::Queries::Query09_09_AL_02
422INFO : (12-21 18:09:17) <-- clear: 41 - Scheduler::AutoPopulate::Queries::Query09_09_AL_03
423INFO : (12-21 18:09:17) <-- clear: 42 - Scheduler::AutoPopulate::Queries::Query09_09_AL_04
424INFO : (12-21 18:09:17) <-- clear: 43 - Scheduler::AutoPopulate::Queries::Query09_09_AL_05
425INFO : (12-21 18:09:17) <-- clear: 44 - Scheduler::AutoPopulate::Queries::Query09_09_AL_06
426INFO : (12-21 18:09:17) <-- clear: 45 - Scheduler::AutoPopulate::Queries::Query09_12_Points
427INFO : (12-21 18:09:17) <-- clear: 46 - Scheduler::AutoPopulate::Queries::Query09_12_Hours
428INFO : (12-21 18:09:17) <-- clear: 47 - Scheduler::AutoPopulate::Queries::Query10
429INFO : (12-21 18:09:17) <-- clear: 48 - Scheduler::AutoPopulate::Queries::QueryScore02
430INFO : (12-21 18:09:17) <-- clear: 49 - Scheduler::AutoPopulate::Queries::QueryScore03
431INFO : (12-21 18:09:17) <-- clear: 50 - Scheduler::AutoPopulate::Queries::QueryScore04
432INFO : (12-21 18:09:17) <-- clear: 51 - Scheduler::AutoPopulate::Queries::Query11
433INFO : (12-21 18:09:17) <-- clear: 52 - Scheduler::AutoPopulate::Queries::DropTables
434 (142.9ms) DROP TABLE IF EXISTS buffer_annual_hour_targets_2146882400
435 (142.7ms) DROP TABLE IF EXISTS buffer_annual_point_targets_2146882400
436 (142.5ms) DROP TABLE IF EXISTS buffer_annual_targets_staff_totals_2146882400
437 (143.2ms) DROP TABLE IF EXISTS buffer_auto_populate_slots_2146882400
438 (142.9ms) DROP TABLE IF EXISTS buffer_call_days_targets_2146882400
439 (143.0ms) DROP TABLE IF EXISTS buffer_call_type_targets_2146882400
440 (142.7ms) DROP TABLE IF EXISTS buffer_cumulative_cd_targets_2146882400
441 (142.5ms) DROP TABLE IF EXISTS buffer_cumulative_ct_targets_2146882400
442 (143.7ms) DROP TABLE IF EXISTS buffer_cumulative_dow_targets_2146882400
443 (142.8ms) DROP TABLE IF EXISTS buffer_cumulative_hour_targets_2146882400
444 (142.6ms) DROP TABLE IF EXISTS buffer_cumulative_oa_targets_2146882400
445 (142.5ms) DROP TABLE IF EXISTS buffer_cumulative_point_targets_2146882400
446 (148.0ms) DROP TABLE IF EXISTS buffer_current_cd_targets_2146882400
447 (142.5ms) DROP TABLE IF EXISTS buffer_current_ct_targets_2146882400
448 (160.1ms) DROP TABLE IF EXISTS buffer_current_dow_targets_2146882400
449 (143.4ms) DROP TABLE IF EXISTS buffer_current_hour_targets_2146882400
450 (143.1ms) DROP TABLE IF EXISTS buffer_current_oa_targets_2146882400
451 (143.3ms) DROP TABLE IF EXISTS buffer_current_point_targets_2146882400
452 (143.0ms) DROP TABLE IF EXISTS buffer_day_of_week_targets_2146882400
453 (153.6ms) DROP TABLE IF EXISTS buffer_hour_targets_2146882400
454 (145.1ms) DROP TABLE IF EXISTS buffer_linkage_call_days_targets_2146882400
455 (142.6ms) DROP TABLE IF EXISTS buffer_linkage_call_type_targets_2146882400
456 (142.8ms) DROP TABLE IF EXISTS buffer_linkage_targets_2146882400
457 (142.7ms) DROP TABLE IF EXISTS buffer_linkage_hour_targets_2146882400
458 (142.7ms) DROP TABLE IF EXISTS buffer_linkage_point_targets_2146882400
459 (142.7ms) DROP TABLE IF EXISTS buffer_location_privileges_2146882400
460 (142.8ms) DROP TABLE IF EXISTS buffer_periods_2146882400
461 (142.7ms) DROP TABLE IF EXISTS buffer_point_targets_2146882400
462 (142.9ms) DROP TABLE IF EXISTS buffer_schedules_2146882400
463 (142.8ms) DROP TABLE IF EXISTS buffer_target_call_types_2146882400
464 (142.6ms) DROP TABLE IF EXISTS buffer_target_daily_points_2146882400
465 (142.7ms) DROP TABLE IF EXISTS buffer_target_dates_list_2146882400
466 (144.8ms) DROP TABLE IF EXISTS buffer_target_primary_availabilities_2146882400
467 (142.4ms) DROP TABLE IF EXISTS buffer_targets_2146882400
468 (142.9ms) DROP TABLE IF EXISTS buffer_tmp_targets_availabilities_2146882400
469 (142.6ms) DROP TABLE IF EXISTS buffer_tmp_targets_availabilities_exclusions_2146882400
470 (142.9ms) DROP TABLE IF EXISTS buffer_tmp_targets_client_totals_2146882400
471 (154.8ms) DROP TABLE IF EXISTS buffer_tmp_targets_scheduled_2146882400
472 (144.6ms) DROP TABLE IF EXISTS buffer_tmp_targets_staff_totals_2146882400
473 (142.7ms) DROP TABLE IF EXISTS buffer_prepopulate_steps_2146882400
474 (143.1ms) DROP TABLE IF EXISTS buffer_prepopulate_dates_2146882400
475 (142.6ms) DROP TABLE IF EXISTS buffer_prepopulate_periods_2146882400
476 (142.7ms) DROP TABLE IF EXISTS buffer_prepopulate_assignments_2146882400
477 (142.8ms) DROP TABLE IF EXISTS buffer_prepopulate_staff_schedules_2146882400
478 (143.0ms) DROP TABLE IF EXISTS buffer_assignment_limit_call_types_2146882400
479 (142.7ms) DROP TABLE IF EXISTS buffer_assignment_limit_periods_2146882400
480 (143.6ms) DROP TABLE IF EXISTS buffer_assignment_limit_staff_types_2146882400
481 (142.8ms) DROP TABLE IF EXISTS buffer_assignment_limit_staffs_2146882400
482 (142.3ms) DROP TABLE IF EXISTS buffer_auto_populate_slots_2146882400
483 (143.5ms) DROP TABLE IF EXISTS buffer_call_type_assignments_2146882400
484 (149.2ms) DROP TABLE IF EXISTS buffer_combined_availabilities_2146882400
485 (142.9ms) DROP TABLE IF EXISTS buffer_combined_availability_linkages_2146882400
486 (144.4ms) DROP TABLE IF EXISTS buffer_counter_increments_2146882400
487 (143.1ms) DROP TABLE IF EXISTS buffer_linkage_assigned_days_2146882400
488 (142.9ms) DROP TABLE IF EXISTS buffer_linkage_call_type_assignments_2146882400
489 (142.7ms) DROP TABLE IF EXISTS buffer_linkage_dow_targets_2146882400
490 (142.8ms) DROP TABLE IF EXISTS buffer_linkage_patterns_2146882400
491 (143.8ms) DROP TABLE IF EXISTS buffer_linkages_2146882400
492 (142.2ms) DROP TABLE IF EXISTS buffer_location_privileges_2146882400
493 (145.9ms) DROP TABLE IF EXISTS buffer_min_distances_2146882400
494 (142.5ms) DROP TABLE IF EXISTS buffer_negative_relations_2146882400
495 (142.6ms) DROP TABLE IF EXISTS buffer_rule_calc_filters_2146882400
496 (143.0ms) DROP TABLE IF EXISTS buffer_rule_calc_schedules_2146882400
497 (143.0ms) DROP TABLE IF EXISTS buffer_rule_scores_2146882400
498 (142.8ms) DROP TABLE IF EXISTS buffer_rule_scores_with_corrections_2146882400
499 (143.0ms) DROP TABLE IF EXISTS buffer_schedule_linkages_2146882400
500 (142.5ms) DROP TABLE IF EXISTS buffer_schedules_linkage_patterns_2146882400
501 (143.2ms) DROP TABLE IF EXISTS buffer_specialization_daily_counts_2146882400
502 (170.5ms) DROP TABLE IF EXISTS buffer_staff_assigned_days_2146882400
503 (144.8ms) DROP TABLE IF EXISTS buffer_staff_daily_counts_2146882400
504 (142.4ms) DROP TABLE IF EXISTS buffer_staff_specializations_2146882400
505 (143.2ms) DROP TABLE IF EXISTS buffer_static_availabilities_2146882400
506 (148.2ms) DROP TABLE IF EXISTS buffer_target_assignments_2146882400
507 (144.7ms) DROP TABLE IF EXISTS buffer_linkage_assignment_limits_2146882400
508 (142.6ms) DROP TABLE IF EXISTS buffer_staff_assignment_limits_2146882400
509 (142.8ms) DROP TABLE IF EXISTS buffer_assignment_limits_2146882400
510 (140.6ms) delete from buffer_target_dates
511 where session_id = 2146882400
512
513 Notification Load (141.8ms) SELECT `notifications`.* FROM `notifications` WHERE `notifications`.`client_id` = 26 AND `notifications`.`locked` = 1 AND `notifications`.`domain` = 'admin/schedules/populate'
514 (140.7ms) BEGIN
515 SQL (146.9ms) DELETE FROM `notifications` WHERE `notifications`.`id` = 423
516 (144.5ms) COMMIT
517 (140.7ms) BEGIN
518 SQL (140.8ms) DELETE FROM `notifications` WHERE `notifications`.`id` = 424
519 (143.9ms) COMMIT
520 (140.3ms) BEGIN
521 SQL (140.6ms) DELETE FROM `notifications` WHERE `notifications`.`id` = 425
522 (144.3ms) COMMIT