Created
May 20, 2014 13:16
-
-
Save gabeodess/c51046e69da928498bfc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 3178 LIMIT 1 | |
Geokit is using the domain: localhost | |
AdminUser Load (0.4ms) SELECT "admin_users".* FROM "admin_users" WHERE "admin_users"."id" IN (0, 2, 0) LIMIT 1 | |
SQL (8.3ms) UPDATE "users" SET "last_login_at" = '2014-05-20 13:08:40.242561' WHERE "users"."id" = 3178 | |
Farm Load (2.4ms) SELECT "farms".* FROM "farms" WHERE "farms"."user_id" = 3178 AND "farms"."status" = 'approved' LIMIT 1 | |
Farm Load (0.7ms) SELECT "farms".* FROM "farms" WHERE "farms"."status" = 'approved' AND "farms"."user_id" = 3178 LIMIT 1 | |
Delivery Load (0.5ms) SELECT "deliveries".* FROM "deliveries" WHERE "deliveries"."farm_id" = 82 AND "deliveries"."id" = $1 LIMIT 1 [["id", "1287"]] | |
Farm Exists (0.4ms) SELECT 1 AS one FROM "farms" WHERE (("farms"."user_id" = 3178 AND "farms"."status" = 'approved')) LIMIT 1 | |
(0.8ms) BEGIN | |
Share Load (1.1ms) SELECT "shares".* FROM "shares" WHERE "shares"."delivery_id" = 1287 AND "shares"."id" IN (11301, 11308, 11321, 11320, 11319, 11318, 11317, 11316, 11315, 11314, 11313, 11312, 11307, 11311, 11310, 11309, 11306, 11305, 11304, 11303, 11302, 11300) | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11301 AND "share_items"."id" IN (12771) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12771 AND "skus"."id" IN (11370, 11371) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11308 AND "share_items"."id" IN (12778) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12778 AND "skus"."id" IN (11385) | |
ShareItem Load (0.7ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11321 AND "share_items"."id" IN (12796) | |
Sku Load (0.6ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12796 AND "skus"."id" IN (11412) | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11320 AND "share_items"."id" IN (12790, 12791, 12792, 12793, 12794, 12795) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12790 AND "skus"."id" IN (11406) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12791 AND "skus"."id" IN (11407) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12792 AND "skus"."id" IN (11408) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12793 AND "skus"."id" IN (11409) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12794 AND "skus"."id" IN (11410) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12795 AND "skus"."id" IN (11411) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11319 AND "share_items"."id" IN (12789) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12789 AND "skus"."id" IN (11403, 11404, 11405) | |
ShareItem Load (0.8ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11318 AND "share_items"."id" IN (12788) | |
Sku Load (0.6ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12788 AND "skus"."id" IN (11399, 11400, 11401, 11402) | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11317 AND "share_items"."id" IN (12787) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12787 AND "skus"."id" IN (11397, 11398) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11316 AND "share_items"."id" IN (12786) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12786 AND "skus"."id" IN (11396) | |
ShareItem Load (1.0ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11315 AND "share_items"."id" IN (12785) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12785 AND "skus"."id" IN (11394, 11395) | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11314 AND "share_items"."id" IN (12784) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12784 AND "skus"."id" IN (11393) | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11313 AND "share_items"."id" IN (12783) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12783 AND "skus"."id" IN (11390, 11391, 11392) | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11312 AND "share_items"."id" IN (12782) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12782 AND "skus"."id" IN (11389) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11307 AND "share_items"."id" IN (12777) | |
Sku Load (0.9ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12777 AND "skus"."id" IN (11384) | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11311 AND "share_items"."id" IN (12781) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12781 AND "skus"."id" IN (11388) | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11310 AND "share_items"."id" IN (12780) | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12780 AND "skus"."id" IN (11387) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11309 AND "share_items"."id" IN (12779) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12779 AND "skus"."id" IN (11386) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11306 AND "share_items"."id" IN (12776) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12776 AND "skus"."id" IN (11381, 11382, 11383) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11305 AND "share_items"."id" IN (12775) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12775 AND "skus"."id" IN (11379, 11380) | |
ShareItem Load (0.8ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11304 AND "share_items"."id" IN (12774) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12774 AND "skus"."id" IN (11375, 11376, 11377, 11378) | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11303 AND "share_items"."id" IN (12773) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12773 AND "skus"."id" IN (11373, 11374) | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11302 AND "share_items"."id" IN (12772) | |
Sku Load (0.7ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12772 AND "skus"."id" IN (11372) | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11300 AND "share_items"."id" IN (12770) | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12770 AND "skus"."id" IN (11366, 11367, 11368, 11369) | |
Stop Load (0.7ms) SELECT "stops".* FROM "stops" WHERE "stops"."delivery_id" = 1287 LIMIT 1 | |
DropOff Load (0.6ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 161 LIMIT 1 | |
ZipCode Load (1.0ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78727' LIMIT 1 | |
Share Load (1.3ms) SELECT "shares".* FROM "shares" WHERE "shares"."delivery_id" = 1287 | |
Stop Load (0.5ms) SELECT "stops".* FROM "stops" WHERE "stops"."delivery_id" = 1287 | |
Farm Load (3.2ms) SELECT "farms".* FROM "farms" WHERE "farms"."id" = 82 LIMIT 1 | |
CACHE (0.0ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 161 LIMIT 1 | |
CACHE (0.0ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78727' LIMIT 1 | |
Stop Exists (4.7ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 161 AND "stops"."start" = '2014-05-22 17:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3963) LIMIT 1 | |
DropOff Load (0.6ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 208 LIMIT 1 | |
ZipCode Load (0.4ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78758' LIMIT 1 | |
Stop Exists (1.5ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 208 AND "stops"."start" = '2014-05-22 18:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3964) LIMIT 1 | |
DropOff Load (0.6ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 137 LIMIT 1 | |
CACHE (0.0ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78758' LIMIT 1 | |
Stop Exists (1.8ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 137 AND "stops"."start" = '2014-05-22 18:30:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3965) LIMIT 1 | |
DropOff Load (0.6ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 207 LIMIT 1 | |
CACHE (0.0ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78758' LIMIT 1 | |
Stop Exists (1.0ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 207 AND "stops"."start" = '2014-05-22 19:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3966) LIMIT 1 | |
DropOff Load (0.8ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 218 LIMIT 1 | |
ZipCode Load (0.5ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78749' LIMIT 1 | |
Stop Exists (1.6ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 218 AND "stops"."start" = '2014-05-22 20:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3967) LIMIT 1 | |
DropOff Load (0.8ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 176 LIMIT 1 | |
ZipCode Load (1.6ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78729' LIMIT 1 | |
Stop Exists (1.5ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 176 AND "stops"."start" = '2014-05-22 21:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3968) LIMIT 1 | |
DropOff Load (0.6ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 112 LIMIT 1 | |
ZipCode Load (0.7ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78681' LIMIT 1 | |
Stop Exists (2.0ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 112 AND "stops"."start" = '2014-05-22 22:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3969) LIMIT 1 | |
DropOff Load (0.8ms) SELECT "drop_offs".* FROM "drop_offs" WHERE "drop_offs"."id" = 219 LIMIT 1 | |
ZipCode Load (0.5ms) SELECT "zip_codes".* FROM "zip_codes" WHERE "zip_codes"."zip" = '78664' LIMIT 1 | |
Stop Exists (0.9ms) SELECT 1 AS one FROM "stops" INNER JOIN "deliveries" ON "stops"."delivery_id" = "deliveries"."id" WHERE "deliveries"."farm_id" = 82 AND (("stops"."drop_off_id" = 219 AND "stops"."start" = '2014-05-22 23:00:00.000000')) AND (stops.id IS NOT NULL) AND (stops.id != 3970) LIMIT 1 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11301 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11308 | |
ShareItem Load (0.3ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11321 | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11320 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11319 | |
ShareItem Load (0.3ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11318 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11317 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11316 | |
ShareItem Load (0.3ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11315 | |
ShareItem Load (0.3ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11314 | |
ShareItem Load (0.8ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11313 | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11312 | |
ShareItem Load (0.5ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11307 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11311 | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11310 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11309 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11306 | |
ShareItem Load (0.6ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11305 | |
ShareItem Load (4.2ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11304 | |
ShareItem Load (0.7ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11303 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11302 | |
ShareItem Load (0.4ms) SELECT "share_items".* FROM "share_items" WHERE "share_items"."share_id" = 11300 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12771 | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12778 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12796 | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12790 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12791 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12792 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12793 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12794 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12795 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12789 | |
Sku Load (0.7ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12788 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12787 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12786 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12785 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12784 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12783 | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12782 | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12777 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12781 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12780 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12779 | |
Sku Load (0.3ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12776 | |
Sku Load (0.7ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12775 | |
Sku Load (0.5ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12774 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12773 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12772 | |
Sku Load (0.4ms) SELECT "skus".* FROM "skus" WHERE "skus"."share_item_id" = 12770 | |
SQL (6.6ms) UPDATE "shares" SET "updated_at" = '2014-05-20 13:08:41.045061' WHERE "shares"."delivery_id" = 1287 | |
(1.1ms) COMMIT |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment