Skip to content

Instantly share code, notes, and snippets.

@miratcan
Created July 18, 2011 14:11
Show Gist options
  • Save miratcan/1089620 to your computer and use it in GitHub Desktop.
Save miratcan/1089620 to your computer and use it in GitHub Desktop.
That long sql log is for showing 10 thumbnails...
[sql] SELECT ...
FROM "looks_look"
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||da518127fcee31e22ccffa7532bd4008
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||da518127fcee31e22ccffa7532bd4008
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||da518127fcee31e22ccffa7532bd4008,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||da518127fcee31e22ccffa7532bd4008LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/98/a3/98a3cc9c467e49b3132892a9cdef5867.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||da518127fcee31e22ccffa7532bd4008
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||7548b9615ffeb55cb14f08aa3b21b405
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||7548b9615ffeb55cb14f08aa3b21b405LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["fa21021084c4b300e7c8ef32a5185d16",
"8d014ddcc936e956caf6159564b7e646",
"22f2ef45b4ce5f456e869dc8a6290e9c",
"da518127fcee31e22ccffa7532bd4008"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||7548b9615ffeb55cb14f08aa3b21b405
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||029dee5cf09085c985fa3266351d4c4d
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||029dee5cf09085c985fa3266351d4c4d
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||029dee5cf09085c985fa3266351d4c4d,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||029dee5cf09085c985fa3266351d4c4dLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/54/d2/54d257d4777d1c6b6cd032ab02190693.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||029dee5cf09085c985fa3266351d4c4d
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||fa2343c2a83a4ecb6b83c6aaba66ee17
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||fa2343c2a83a4ecb6b83c6aaba66ee17LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["dca9ef42d58734553be96af490d9ebc5",
"255f28bebf298dbcca5f8325d9bfa4a0",
"029dee5cf09085c985fa3266351d4c4d",
"a9b115fd78118309dfe68372af75b2cf"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||fa2343c2a83a4ecb6b83c6aaba66ee17
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||d031e7b55db5aa94ad17376f0dacf315
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||d031e7b55db5aa94ad17376f0dacf315
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||d031e7b55db5aa94ad17376f0dacf315,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||d031e7b55db5aa94ad17376f0dacf315LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/f7/b1/f7b12458e736824e0338c7225f34624b.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||d031e7b55db5aa94ad17376f0dacf315
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||246c33d6352a5b3233c627c87a924b6d
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||246c33d6352a5b3233c627c87a924b6dLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["d031e7b55db5aa94ad17376f0dacf315",
"7586ccba299807e0afa46f68698b0687",
"4d51035be229c5890477fda926e18575",
"2b3cd2aa205b7c117bfbe3d56534312a"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||246c33d6352a5b3233c627c87a924b6d
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||f162246877584277d84ef8c5be76dc50
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||f162246877584277d84ef8c5be76dc50
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||f162246877584277d84ef8c5be76dc50,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||f162246877584277d84ef8c5be76dc50LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/7d/db/7ddbf3b0cf4f0afe5ac7c507e997a6d3.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||f162246877584277d84ef8c5be76dc50
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||541f5ed85f02f7a0f19b244463268b88
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||541f5ed85f02f7a0f19b244463268b88LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["9d37a47811070e768f0185575b4805db",
"7faed9158d3df37b807094390c5daca1",
"d40921f4c61c5623e9ae1e1408923634",
"f162246877584277d84ef8c5be76dc50"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||541f5ed85f02f7a0f19b244463268b88
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||e774cd6a777d10ecb2112c00ed68e091
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||e774cd6a777d10ecb2112c00ed68e091
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||e774cd6a777d10ecb2112c00ed68e091,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||e774cd6a777d10ecb2112c00ed68e091LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/33/a7/33a79640f877c43e5a25da14dec51317.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||e774cd6a777d10ecb2112c00ed68e091
[sql] (1ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||451a97f6edb40595c02fb0f4a61149ad
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||451a97f6edb40595c02fb0f4a61149adLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["12ddddb2608b1ec9e80b48ba11fbeb82",
"f41213f0aa316a6994cc42d7da839fda",
"17f6c2b6585e70386ae2fe38c6929496",
"e774cd6a777d10ecb2112c00ed68e091"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||451a97f6edb40595c02fb0f4a61149ad
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||a019c94b590bfb33c3d281b0815a4977
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||a019c94b590bfb33c3d281b0815a4977
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||a019c94b590bfb33c3d281b0815a4977,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||a019c94b590bfb33c3d281b0815a4977LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/68/63/68634943bab6134eba1d45ab178d54a8.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||a019c94b590bfb33c3d281b0815a4977
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||f1c257687712ea75f7ba95112c11689f
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||f1c257687712ea75f7ba95112c11689fLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["85c33eaebb9b0c55d37b3d47682839d9",
"4a05c29d7e271125ecd20ad01db7255b",
"e67601c0602ad0c14d4a2c24893a70cd",
"a019c94b590bfb33c3d281b0815a4977"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||f1c257687712ea75f7ba95112c11689f
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||7a7af478b0bc598c1b5f57c4616422e7
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||7a7af478b0bc598c1b5f57c4616422e7
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||7a7af478b0bc598c1b5f57c4616422e7,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||7a7af478b0bc598c1b5f57c4616422e7LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/fd/b8/fdb85ef27dcbed68392453835a5accc7.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||7a7af478b0bc598c1b5f57c4616422e7
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||18d4c947471648c0263921a1de363024
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||18d4c947471648c0263921a1de363024LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["7a7af478b0bc598c1b5f57c4616422e7",
"231df3239d31eba0119a0e51e2235467",
"23c10a3a6ff021567146f585d25526c8",
"bd509ac65c62f65998a48673fea20226"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||18d4c947471648c0263921a1de363024
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||5f9d7e51fb2c52d4ea95fef6c48cc5a7
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||5f9d7e51fb2c52d4ea95fef6c48cc5a7
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||5f9d7e51fb2c52d4ea95fef6c48cc5a7,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||5f9d7e51fb2c52d4ea95fef6c48cc5a7LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/c7/78/c778b98dc76df71731541c486d40083c.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||5f9d7e51fb2c52d4ea95fef6c48cc5a7
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||27957f48841b07aaf8a73cd96a6a7152
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||27957f48841b07aaf8a73cd96a6a7152LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["a3ab2c47441c2a80cfc15a1da6d11d68",
"5f9d7e51fb2c52d4ea95fef6c48cc5a7",
"01fe5d012170226c361ac4e5923ff332",
"51d6d95b88066a8f2acd2170b3bc4b1e"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||27957f48841b07aaf8a73cd96a6a7152
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||dba890f02079eed89a82249776e7bce1
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||dba890f02079eed89a82249776e7bce1
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||dba890f02079eed89a82249776e7bce1,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||dba890f02079eed89a82249776e7bce1LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/d6/cf/d6cfe555775e98a5265e6cc6b2e5ffec.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||dba890f02079eed89a82249776e7bce1
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||21aefa274644620df5d27d8f1df5fde7
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||21aefa274644620df5d27d8f1df5fde7LIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["2c0468cd03c8da8ff85095f93893bb90",
"3235079f1fd0c2cd865bdd26ccf6ba61",
"2943cbbff7207560d6ad2df839ec7919",
"dba890f02079eed89a82249776e7bce1"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||21aefa274644620df5d27d8f1df5fde7
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||ad9fccc51ffe6178b9371cf3d668861c
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||ad9fccc51ffe6178b9371cf3d668861c
[sql] INSERT INTO "thumbnail_kvstore" ("key",
"value")
VALUES (sorl-thumbnail||image||ad9fccc51ffe6178b9371cf3d668861c,)
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||ad9fccc51ffe6178b9371cf3d668861cLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = {"storage": "django.core.files.storage.FileSystemStorage",
"name": "cache/a0/8a/a08aff120cef29e8ed73e45d9d598cab.jpg",
"size": [161,
209]}
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||image||ad9fccc51ffe6178b9371cf3d668861c
[sql] (0ms) Found 1 matching rows
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||947500d6181ae03a54ee6d1851adbc1d
[sql] SELECT ...
FROM "thumbnail_kvstore"
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||947500d6181ae03a54ee6d1851adbc1dLIMIT 1
[sql] UPDATE "thumbnail_kvstore"
SET "value" = ["ad9fccc51ffe6178b9371cf3d668861c",
"a8afbf777c9bccec224abbaad88a1c28",
"a6a91edcff205d1f7b441d5528bb4c66",
"9fde7544eedbfa19f52ed576327f6bc0"]
WHERE "thumbnail_kvstore"."key" = sorl-thumbnail||thumbnails||947500d6181ae03a54ee6d1851adbc1d
[sql] (0ms) Found 1 matching rows
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment