Skip to content

Instantly share code, notes, and snippets.

@klippx

klippx/delete_pol.log

Created June 4, 2015 14:25
Show Gist options
  • Save klippx/53eb4a523d7042b81be9 to your computer and use it in GitHub Desktop.
Save klippx/53eb4a523d7042b81be9 to your computer and use it in GitHub Desktop.
Download ZIP
Deletear pouch order lines
Raw
delete_pol.log
2202 I, [2015-06-04T13:51:11.230236 #8457] INFO -- : Started GET "/labels/232.pdf" for 213.180.87.134 at 2015-06-04 13:51:11 +0200
2203 I, [2015-06-04T13:51:11.237208 #8457] INFO -- : Processing by LabelsController#show as PDF
2204 I, [2015-06-04T13:51:11.237313 #8457] INFO -- : Parameters: {"id"=>"232"}
2205 D, [2015-06-04T13:51:11.240117 #8457] DEBUG -- : User Load (0.7ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 42 ORDER BY `users`.`id` ASC LIMIT 1
2206 D, [2015-06-04T13:51:11.261844 #8457] DEBUG -- : TransportLabel Load (16.6ms) SELECT `transport_labels`.* FROM `transport_labels` WHERE `transport_labels`.`id` = 232 LIMIT 1
2207 D, [2015-06-04T13:51:11.277864 #8457] DEBUG -- : Address Load (0.7ms) SELECT `addresses`.* FROM `addresses` WHERE `addresses`.`owner_id` = 232 AND `addresses`.`owner_type` = 'TransportLabel' LIMIT 1
2208 I, [2015-06-04T13:51:11.297387 #8457] INFO -- : ***************WICKED***************
2209 D, [2015-06-04T13:51:11.461020 #8457] DEBUG -- : Ward Load (0.5ms) SELECT `wards`.* FROM `wards` WHERE `wards`.`id` = 32 LIMIT 1
2210 D, [2015-06-04T13:51:11.466726 #8457] DEBUG -- : PouchOrder Load (0.7ms) SELECT `pouch_orders`.* FROM `pouch_orders` WHERE `pouch_orders`.`transport_label_id` = 232
2211 D, [2015-06-04T13:51:11.473801 #8457] DEBUG -- : (3.1ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 622
2212 D, [2015-06-04T13:51:11.475464 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 632
2213 D, [2015-06-04T13:51:11.478383 #8457] DEBUG -- : (1.7ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 642
2214 D, [2015-06-04T13:51:11.479975 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 682
2215 D, [2015-06-04T13:51:11.481560 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 692
2216 D, [2015-06-04T13:51:11.483115 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 702
2217 D, [2015-06-04T13:51:11.484693 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 712
2218 D, [2015-06-04T13:51:11.487533 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 622 AND (quantity > 0)
2219 D, [2015-06-04T13:51:11.488781 #8457] DEBUG -- : PouchOrderLine Load (0.7ms) SELECT `pouch_order_lines`.* FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 622 AND (quantity > 0)
2220 D, [2015-06-04T13:51:11.492576 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 632 AND (quantity > 0)
2221 D, [2015-06-04T13:51:11.493810 #8457] DEBUG -- : PouchOrderLine Load (0.7ms) SELECT `pouch_order_lines`.* FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 632 AND (quantity > 0)
2222 D, [2015-06-04T13:51:11.497960 #8457] DEBUG -- : (0.4ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 712 AND (quantity > 0)
2223 D, [2015-06-04T13:51:11.499739 #8457] DEBUG -- : PouchOrderLine Load (1.1ms) SELECT `pouch_order_lines`.* FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 712 AND (quantity > 0)
2224 D, [2015-06-04T13:51:11.504034 #8457] DEBUG -- : (0.5ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 682 AND (quantity > 0)
2225 D, [2015-06-04T13:51:11.505499 #8457] DEBUG -- : PouchOrderLine Load (0.8ms) SELECT `pouch_order_lines`.* FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 682 AND (quantity > 0)
2226 D, [2015-06-04T13:51:11.508782 #8457] DEBUG -- : (0.3ms) BEGIN
2227 D, [2015-06-04T13:51:11.533081 #8457] DEBUG -- : SQL (17.5ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24372
2228 D, [2015-06-04T13:51:11.541363 #8457] DEBUG -- : SQL (0.6ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24372
2229 D, [2015-06-04T13:51:11.542861 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24382
2230 D, [2015-06-04T13:51:11.543940 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24382
2231 D, [2015-06-04T13:51:11.545945 #8457] DEBUG -- : SQL (1.1ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24392
2232 D, [2015-06-04T13:51:11.547159 #8457] DEBUG -- : SQL (0.5ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24392
2233 D, [2015-06-04T13:51:11.549702 #8457] DEBUG -- : SQL (1.6ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24402
2234 D, [2015-06-04T13:51:11.550861 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24402
2235 D, [2015-06-04T13:51:11.552125 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24412
2236 D, [2015-06-04T13:51:11.553179 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24412
2237 D, [2015-06-04T13:51:11.554718 #8457] DEBUG -- : SQL (0.6ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24422
2238 D, [2015-06-04T13:51:11.555788 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24422
2239 D, [2015-06-04T13:51:11.557447 #8457] DEBUG -- : SQL (0.7ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24432
2240 D, [2015-06-04T13:51:11.558505 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24432
2241 D, [2015-06-04T13:51:11.559712 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24442
2242 D, [2015-06-04T13:51:11.560821 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24442
2243 D, [2015-06-04T13:51:11.562020 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24452
2244 D, [2015-06-04T13:51:11.563069 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24452
2245 D, [2015-06-04T13:51:11.564361 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24462
2246 D, [2015-06-04T13:51:11.565589 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24462
2247 D, [2015-06-04T13:51:11.567316 #8457] DEBUG -- : (1.0ms) COMMIT
2248 D, [2015-06-04T13:51:11.570083 #8457] DEBUG -- : (0.5ms) SELECT COUNT(*) FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 692 AND (quantity > 0)
2249 D, [2015-06-04T13:51:11.571429 #8457] DEBUG -- : PouchOrderLine Load (0.8ms) SELECT `pouch_order_lines`.* FROM `pouch_order_lines` WHERE `pouch_order_lines`.`pouch_order_id` = 692 AND (quantity > 0)
2250 D, [2015-06-04T13:51:11.574341 #8457] DEBUG -- : (0.2ms) BEGIN
2251 D, [2015-06-04T13:51:11.575746 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24512
2252 D, [2015-06-04T13:51:11.576848 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24512
2253 D, [2015-06-04T13:51:11.578122 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24522
2254 D, [2015-06-04T13:51:11.579187 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24522
2255 D, [2015-06-04T13:51:11.580392 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24532
2256 D, [2015-06-04T13:51:11.581467 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24532
2257 D, [2015-06-04T13:51:11.582635 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24542
2258 D, [2015-06-04T13:51:11.583705 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24542
2259 D, [2015-06-04T13:51:11.584928 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24552
2260 D, [2015-06-04T13:51:11.585964 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24552
2261 D, [2015-06-04T13:51:11.587233 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24562
2262 D, [2015-06-04T13:51:11.588428 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24562
2263 D, [2015-06-04T13:51:11.590180 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24572
2264 D, [2015-06-04T13:51:11.592634 #8457] DEBUG -- : SQL (1.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24572
2265 D, [2015-06-04T13:51:11.594469 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24582
2266 D, [2015-06-04T13:51:11.595902 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24582
2267 D, [2015-06-04T13:51:11.597523 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24592
2268 D, [2015-06-04T13:51:11.598911 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24592
2269 D, [2015-06-04T13:51:11.600491 #8457] DEBUG -- : SQL (0.3ms) DELETE FROM `overdoses_lines` WHERE `overdoses_lines`.`pouch_order_line_id` = 24602
2270 D, [2015-06-04T13:51:11.601858 #8457] DEBUG -- : SQL (0.4ms) DELETE FROM `pouch_order_lines` WHERE `pouch_order_lines`.`id` = 24602
2271 D, [2015-06-04T13:51:11.603905 #8457] DEBUG -- : (1.1ms) COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment