Skip to content

Instantly share code, notes, and snippets.

@scomma

scomma/slow.log

Last active December 2, 2019 11:01
Show Gist options
  • Save scomma/0b11f9b6b691243e52a2815136c9cd0e to your computer and use it in GitHub Desktop.
Save scomma/0b11f9b6b691243e52a2815136c9cd0e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
slow.log
[107] production(main)> app.get 'https://page365.net/Jade4you9/products.json', god_token: '9uctTgwj8pvixpXtbN66Drro3LTuAMpG'
D, [2019-12-02T16:35:53.535756 #25736] DEBUG -- : Account Load (11.8ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`username` = 'Jade4you9' LIMIT 1
D, [2019-12-02T16:35:53.679421 #25736] DEBUG -- : (124.7ms) SELECT COUNT(*) FROM `products` WHERE `products`.`account_id` = 303359
D, [2019-12-02T16:35:53.688800 #25736] DEBUG -- : Product Load (2.4ms) SELECT `products`.* FROM `products` WHERE `products`.`account_id` = 303359 ORDER BY `products`.`id` DESC LIMIT 50 OFFSET 0
D, [2019-12-02T16:35:53.737452 #25736] DEBUG -- : HABTM_Photos Load (1.6ms) SELECT `photos_products`.* FROM `photos_products` WHERE `photos_products`.`product_id` IN (68810370, 68810364, 68806072, 68805871, 68805870, 68805869, 68799593, 68799297, 68788870, 68788869, 6
8788322, 68788310, 68787671, 68787670, 68787669, 68787668, 68787667, 68787663, 68787662, 68787661, 68787594, 68787332, 68787304, 68787065, 68787064, 68786997, 68786780, 68786776, 68786774, 68786773, 68786770, 68785825, 68785824, 68785089, 68784689, 68782984, 68782983, 68
780310, 68774510, 68772886, 68772826, 68772813, 68772812, 68772811, 68768105, 68768102, 68768101, 68768098, 68765254, 68759614)
D, [2019-12-02T16:35:53.946623 #25736] DEBUG -- : Photo Load (134.9ms) SELECT `photos`.* FROM `photos` WHERE `photos`.`id` IN (191376346, 191376282, 191329161, 191327643, 191327640, 191327639, 191194497, 191189240, 191084425, 191084424, 191076096, 191075986, 191056382
, 191056381, 191056380, 191056379, 191056378, 191056374, 191056373, 191056372, 191055512, 191045369, 191045093, 191033100, 191033099, 191032031, 191028858, 191028854, 191028851, 191028850, 191028847, 190960499, 190960497, 190948400, 190946435, 190939974, 190939973, 19091
3896, 190847002, 190789562, 190788973, 190788675, 190788674, 190788655, 190705801, 190705792, 190705791, 190705732, 190688830, 190592732)
D, [2019-12-02T16:35:53.973108 #25736] DEBUG -- : ProductVariant Load (2.5ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` IN (68810370, 68810364, 68806072, 68805871, 68805870, 68805869, 68799593, 68799297, 68788870, 687888
69, 68788322, 68788310, 68787671, 68787670, 68787669, 68787668, 68787667, 68787663, 68787662, 68787661, 68787594, 68787332, 68787304, 68787065, 68787064, 68786997, 68786780, 68786776, 68786774, 68786773, 68786770, 68785825, 68785824, 68785089, 68784689, 68782984, 6878298
3, 68780310, 68774510, 68772886, 68772826, 68772813, 68772812, 68772811, 68768105, 68768102, 68768101, 68768098, 68765254, 68759614)
D, [2019-12-02T16:35:53.999012 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68810370 LIMIT 1
D, [2019-12-02T16:35:54.014066 #25736] DEBUG -- : Account Load (6.5ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1
D, [2019-12-02T16:35:54.024328 #25736] DEBUG -- : (4.8ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68810370
D, [2019-12-02T16:35:54.097088 #25736] DEBUG -- : ProductCategory Load (1.1ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1
D, [2019-12-02T16:35:54.116809 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330897 AND (quantity < 0)
D, [2019-12-02T16:35:54.123744 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330897 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.130451 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330897 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.136747 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330897 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.154724 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330897 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.160846 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68810364 LIMIT 1
D, [2019-12-02T16:35:54.166114 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.171752 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68810364
D, [2019-12-02T16:35:54.174119 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.178434 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330891 AND (quantity < 0)
D, [2019-12-02T16:35:54.183197 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330891 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.189627 #25736] DEBUG -- : (1.5ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330891 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.195622 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330891 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.203174 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69330891 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.209182 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68806072 LIMIT 1
D, [2019-12-02T16:35:54.217012 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68806072
D, [2019-12-02T16:35:54.221126 #25736] DEBUG -- : ProductCategory Load (1.3ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980906 LIMIT 1
D, [2019-12-02T16:35:54.226456 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325957 AND (quantity < 0)
D, [2019-12-02T16:35:54.231252 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68805871 LIMIT 1
D, [2019-12-02T16:35:54.237151 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.240448 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.245180 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68805871
D, [2019-12-02T16:35:54.247237 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.250997 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325755 AND (quantity < 0)
D, [2019-12-02T16:35:54.255413 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325755 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.260294 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325755 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.266481 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325755 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.273348 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325755 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.279967 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69329068 AND (quantity < 0)
D, [2019-12-02T16:35:54.285478 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69329068 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.292140 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69329068 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.298346 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69329068 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.304623 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69329068 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.310434 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68805870 LIMIT 1
D, [2019-12-02T16:35:54.316714 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.322078 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68805870
D, [2019-12-02T16:35:54.324702 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.329072 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325754 AND (quantity < 0)
D, [2019-12-02T16:35:54.334013 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325754 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.340647 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325754 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.346914 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325754 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.352814 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325754 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.357913 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68805869 LIMIT 1
D, [2019-12-02T16:35:54.362625 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.367109 #25736] DEBUG -- : (1.1ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68805869
D, [2019-12-02T16:35:54.369249 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.374048 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325753 AND (quantity < 0)
D, [2019-12-02T16:35:54.378969 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325753 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.384621 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325753 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.394052 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325753 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.400955 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69325753 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.407094 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68799593 LIMIT 1
D, [2019-12-02T16:35:54.414750 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68799593
D, [2019-12-02T16:35:54.418811 #25736] DEBUG -- : ProductCategory Load (1.2ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117972779 LIMIT 1
D, [2019-12-02T16:35:54.423744 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318511 AND (quantity < 0)
D, [2019-12-02T16:35:54.427046 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.434976 #25736] DEBUG -- : (3.9ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318511 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.440984 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318511 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.445548 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318511 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.452469 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318511 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.458002 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68799297 LIMIT 1
D, [2019-12-02T16:35:54.462271 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.466712 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68799297
D, [2019-12-02T16:35:54.469232 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.473711 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318137 AND (quantity < 0)
D, [2019-12-02T16:35:54.478996 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318137 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.495023 #25736] DEBUG -- : (6.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318137 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.502302 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318137 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.513096 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69318137 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.518976 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68788870 LIMIT 1
D, [2019-12-02T16:35:54.525684 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.534044 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68788870
D, [2019-12-02T16:35:54.536791 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.541735 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306681 AND (quantity < 0)
D, [2019-12-02T16:35:54.549678 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68788869 LIMIT 1
D, [2019-12-02T16:35:54.555120 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.557856 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.561925 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68788869
D, [2019-12-02T16:35:54.563795 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.567293 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306680 AND (quantity < 0)
D, [2019-12-02T16:35:54.571229 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306680 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.576313 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306680 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.580725 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306680 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.585763 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306680 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.591574 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306704 AND (quantity < 0)
D, [2019-12-02T16:35:54.595730 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306704 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.601016 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306704 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.606625 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306704 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.613998 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69306704 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.620089 #25736] DEBUG -- : ProductVariant Load (1.5ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68788322 LIMIT 1
D, [2019-12-02T16:35:54.626283 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.631602 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68788322
D, [2019-12-02T16:35:54.634330 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:54.638910 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305896 AND (quantity < 0)
D, [2019-12-02T16:35:54.643091 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305896 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.649502 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305896 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.655063 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305896 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.661275 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305896 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.666932 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68788310 LIMIT 1
D, [2019-12-02T16:35:54.675231 #25736] DEBUG -- : (1.5ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68788310
D, [2019-12-02T16:35:54.679383 #25736] DEBUG -- : ProductCategory Load (1.2ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1
D, [2019-12-02T16:35:54.686153 #25736] DEBUG -- : (1.9ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305884 AND (quantity < 0)
D, [2019-12-02T16:35:54.691131 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787671 LIMIT 1
D, [2019-12-02T16:35:54.697285 #25736] DEBUG -- : CACHE (0.1ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.702620 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787671
D, [2019-12-02T16:35:54.705420 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:54.710378 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305142 AND (quantity < 0)
D, [2019-12-02T16:35:54.715679 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305142 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.721374 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305142 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.726137 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305142 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.732102 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305142 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.737281 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787670 LIMIT 1
D, [2019-12-02T16:35:54.742860 #25736] DEBUG -- : CACHE (0.1ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.746622 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.751726 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787670
D, [2019-12-02T16:35:54.754601 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:54.759231 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305141 AND (quantity < 0)
D, [2019-12-02T16:35:54.763657 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305141 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.768942 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305141 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.773901 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305141 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.779234 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305141 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.785379 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305164 AND (quantity < 0)
D, [2019-12-02T16:35:54.790971 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305164 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.796709 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305164 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.803447 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305164 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.815112 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305164 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.821877 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787669 LIMIT 1
D, [2019-12-02T16:35:54.828250 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.831735 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.837015 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787669
D, [2019-12-02T16:35:54.839864 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:54.845033 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305140 AND (quantity < 0)
D, [2019-12-02T16:35:54.851140 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305140 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.857342 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305140 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.863060 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305140 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.873846 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305140 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.881330 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305261 AND (quantity < 0)
D, [2019-12-02T16:35:54.887819 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305261 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.894118 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305261 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.899716 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305261 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.906895 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305261 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.912979 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787668 LIMIT 1
D, [2019-12-02T16:35:54.918899 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.924138 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787668
D, [2019-12-02T16:35:54.926766 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:54.932138 #25736] DEBUG -- : (1.6ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305139 AND (quantity < 0)
D, [2019-12-02T16:35:54.938422 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787667 LIMIT 1
D, [2019-12-02T16:35:54.943229 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.947929 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787667
D, [2019-12-02T16:35:54.949955 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:54.954275 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305138 AND (quantity < 0)
D, [2019-12-02T16:35:54.959144 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305138 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:54.965463 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305138 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:54.971295 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305138 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.978405 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305138 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:54.984949 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305290 AND (quantity < 0)
D, [2019-12-02T16:35:54.988350 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:54.994014 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305290 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.000624 #25736] DEBUG -- : StockMove Load (1.8ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305290 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.009441 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305290 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.015580 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305290 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.020125 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787663 LIMIT 1
D, [2019-12-02T16:35:55.024923 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.027358 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.030092 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.034030 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787663
D, [2019-12-02T16:35:55.035796 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.039405 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305134 AND (quantity < 0)
D, [2019-12-02T16:35:55.044876 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305278 AND (quantity < 0)
D, [2019-12-02T16:35:55.050614 #25736] DEBUG -- : (1.7ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305279 AND (quantity < 0)
D, [2019-12-02T16:35:55.052899 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.059317 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305280 AND (quantity < 0)
D, [2019-12-02T16:35:55.064991 #25736] DEBUG -- : ProductVariant Load (1.1ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787662 LIMIT 1
D, [2019-12-02T16:35:55.068962 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.071189 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.073227 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.077064 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787662
D, [2019-12-02T16:35:55.078879 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.083411 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305133 AND (quantity < 0)
D, [2019-12-02T16:35:55.089777 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305266 AND (quantity < 0)
D, [2019-12-02T16:35:55.096261 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305267 AND (quantity < 0)
D, [2019-12-02T16:35:55.101808 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787661 LIMIT 1
D, [2019-12-02T16:35:55.106066 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.108435 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.110555 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.112760 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.115272 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.118400 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.123395 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787661
D, [2019-12-02T16:35:55.126211 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.130521 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305132 AND (quantity < 0)
D, [2019-12-02T16:35:55.136448 #25736] DEBUG -- : (1.1ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305250 AND (quantity < 0)
D, [2019-12-02T16:35:55.162785 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.170575 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305251 AND (quantity < 0)
D, [2019-12-02T16:35:55.178089 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305252 AND (quantity < 0)
D, [2019-12-02T16:35:55.185567 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305253 AND (quantity < 0)
D, [2019-12-02T16:35:55.193032 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305254 AND (quantity < 0)
D, [2019-12-02T16:35:55.201473 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305255 AND (quantity < 0)
D, [2019-12-02T16:35:55.209659 #25736] DEBUG -- : ProductVariant Load (1.8ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787594 LIMIT 1
D, [2019-12-02T16:35:55.215743 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.220822 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787594
D, [2019-12-02T16:35:55.223832 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.229066 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305043 AND (quantity < 0)
D, [2019-12-02T16:35:55.234617 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305043 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.240766 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305043 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.246184 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305043 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.253480 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305043 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.259540 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787332 LIMIT 1
D, [2019-12-02T16:35:55.265680 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.270673 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787332
D, [2019-12-02T16:35:55.273686 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:55.278515 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304705 AND (quantity < 0)
D, [2019-12-02T16:35:55.286086 #25736] DEBUG -- : ProductVariant Load (1.5ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787304 LIMIT 1
D, [2019-12-02T16:35:55.295454 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.298690 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.303498 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787304
D, [2019-12-02T16:35:55.306391 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:55.311400 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304669 AND (quantity < 0)
D, [2019-12-02T16:35:55.321624 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304681 AND (quantity < 0)
D, [2019-12-02T16:35:55.330206 #25736] DEBUG -- : ProductVariant Load (2.5ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787065 LIMIT 1
D, [2019-12-02T16:35:55.339227 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.341988 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.347765 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787065
D, [2019-12-02T16:35:55.350037 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.354197 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304331 AND (quantity < 0)
D, [2019-12-02T16:35:55.359781 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304331 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.367245 #25736] DEBUG -- : StockMove Load (1.4ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304331 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.372443 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304331 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.380038 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304331 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.386979 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304344 AND (quantity < 0)
D, [2019-12-02T16:35:55.392478 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304344 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.398331 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304344 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.405018 #25736] DEBUG -- : StockMove Load (2.6ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304344 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.413886 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304344 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.422216 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68787064 LIMIT 1
D, [2019-12-02T16:35:55.429377 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.433035 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.438377 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68787064
D, [2019-12-02T16:35:55.441518 #25736] DEBUG -- : CACHE (0.1ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.447422 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304330 AND (quantity < 0)
D, [2019-12-02T16:35:55.456072 #25736] DEBUG -- : (1.6ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304333 AND (quantity < 0)
D, [2019-12-02T16:35:55.464419 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786997 LIMIT 1
D, [2019-12-02T16:35:55.470736 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.476142 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786997
D, [2019-12-02T16:35:55.478940 #25736] DEBUG -- : CACHE (0.1ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.483913 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304224 AND (quantity < 0)
D, [2019-12-02T16:35:55.491361 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786780 LIMIT 1
D, [2019-12-02T16:35:55.497625 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.501771 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.506978 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786780
D, [2019-12-02T16:35:55.509397 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.513959 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303915 AND (quantity < 0)
D, [2019-12-02T16:35:55.519764 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303915 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.525740 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303915 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.533630 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303915 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.539189 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303915 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.545397 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305086 AND (quantity < 0)
D, [2019-12-02T16:35:55.551590 #25736] DEBUG -- : (1.5ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305086 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.566062 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305086 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.573317 #25736] DEBUG -- : StockMove Load (1.9ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305086 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.583202 #25736] DEBUG -- : StockMove Load (1.6ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69305086 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.589785 #25736] DEBUG -- : ProductVariant Load (1.4ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786776 LIMIT 1
D, [2019-12-02T16:35:55.596167 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.599542 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.602866 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.608244 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786776
D, [2019-12-02T16:35:55.611137 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.616164 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303911 AND (quantity < 0)
D, [2019-12-02T16:35:55.621538 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303911 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.627804 #25736] DEBUG -- : StockMove Load (1.7ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303911 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.633111 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303911 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.640200 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303911 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.645464 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304233 AND (quantity < 0)
D, [2019-12-02T16:35:55.650627 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304233 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.658804 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304233 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.664235 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304233 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.672956 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304233 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.682020 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304235 AND (quantity < 0)
D, [2019-12-02T16:35:55.686228 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304235 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.690781 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304235 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.696117 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304235 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.701016 #25736] DEBUG -- : StockMove Load (1.1ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69304235 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.705515 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786774 LIMIT 1
D, [2019-12-02T16:35:55.712300 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786774
D, [2019-12-02T16:35:55.714569 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.719206 #25736] DEBUG -- : (1.5ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303909 AND (quantity < 0)
D, [2019-12-02T16:35:55.722522 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.730338 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786773 LIMIT 1
D, [2019-12-02T16:35:55.736417 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.741593 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786773
D, [2019-12-02T16:35:55.744367 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.749641 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303908 AND (quantity < 0)
D, [2019-12-02T16:35:55.756876 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68786770 LIMIT 1
D, [2019-12-02T16:35:55.762996 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.768142 #25736] DEBUG -- : (1.3ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68786770
D, [2019-12-02T16:35:55.770902 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117980431 LIMIT 1 [["id", 117980431]]
D, [2019-12-02T16:35:55.775919 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69303905 AND (quantity < 0)
D, [2019-12-02T16:35:55.782791 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68785825 LIMIT 1
D, [2019-12-02T16:35:55.788181 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.792816 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68785825
D, [2019-12-02T16:35:55.794764 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:55.798915 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302348 AND (quantity < 0)
D, [2019-12-02T16:35:55.805164 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302348 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.811710 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302348 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.816537 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302348 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.823745 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302348 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.829967 #25736] DEBUG -- : ProductVariant Load (1.3ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68785824 LIMIT 1
D, [2019-12-02T16:35:55.836084 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.841801 #25736] DEBUG -- : (1.5ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68785824
D, [2019-12-02T16:35:55.844687 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:55.849702 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302347 AND (quantity < 0)
D, [2019-12-02T16:35:55.854428 #25736] DEBUG -- : (1.3ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302347 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.861149 #25736] DEBUG -- : (1.4ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302347 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0)
D, [2019-12-02T16:35:55.867338 #25736] DEBUG -- : StockMove Load (1.2ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302347 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.873931 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69302347 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.879651 #25736] DEBUG -- : ProductVariant Load (1.2ms) SELECT `product_variants`.* FROM `product_variants` WHERE `product_variants`.`product_id` = 68785089 LIMIT 1
D, [2019-12-02T16:35:55.884446 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.887142 #25736] DEBUG -- : CACHE (0.0ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 303359 LIMIT 1 [["id", 303359]]
D, [2019-12-02T16:35:55.890940 #25736] DEBUG -- : (1.2ms) SELECT MAX(`product_variants`.`updated_at`) FROM `product_variants` WHERE `product_variants`.`product_id` = 68785089
D, [2019-12-02T16:35:55.892735 #25736] DEBUG -- : CACHE (0.0ms) SELECT `product_categories`.* FROM `product_categories` WHERE `product_categories`.`id` = 117954745 LIMIT 1 [["id", 117954745]]
D, [2019-12-02T16:35:55.896756 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69301244 AND (quantity < 0)
D, [2019-12-02T16:35:55.901245 #25736] DEBUG -- : (1.2ms) SELECT SUM(`stock_moves`.`quantity`) FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69301244 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0)
D, [2019-12-02T16:35:55.907189 #25736] DEBUG -- : StockMove Load (1.3ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69301244 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity < 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.912713 #25736] DEBUG -- : StockMove Load (1.4ms) SELECT `stock_moves`.* FROM `stock_moves` WHERE `stock_moves`.`product_variant_id` = 69301244 AND (`stock_moves`.`price` IS NOT NULL) AND (quantity > 0) ORDER BY created_at DESC
D, [2019-12-02T16:35:55.920051 #25736] DEBUG -- : (1.3ms) SELECT SU
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment