SmartCJ Support Forum

Code: Select all

# Time: 140127 20:22:41
# User@Host: xxxxx[xxxxx] @ localhost []
# Query_time: 5.007647  Lock_time: 0.000154 Rows_sent: 5  Rows_examined: 814911
use xxxxxxx;
SET timestamp=1390854161;
select  g.id, g.gallery_md5, gs.total_shows as thumb_casts, gs.total_clicks as clicks, if (gs.total_shows < 50, 1, 0) as new_thumb  FROM rot_galleries as g JOIN rot_gallery_stats as gs on gs.thumb_id = g.id WHERE g.status = 1   AND g.rgroup != 0  and gs.group_id = '0'  AND g.gallery_md5 NOT IN ('8ed6a6454f8557059ba97fc3fab1459c','77da596d2f37a83b8ad14c564b6e8ca9','a3597679704310eeab2ec1a3d4492a72','fe16261f211c664adf86986602306f9b','94cc878fe5f55eab3ac83eee75aa25c6','46303fecdd48539d3930a9fb1bdfc3da','118f05b6539dcb4fe4aaebd9331c63a6','0fe21f899fd31955e98db9470856497b','bb61a04b2a263e524ebf07f5f8c954dc','cdd9f01d1a354ade51738fcada69719a','728caafd8f464cf2e56e5de786efa50c','ecbc031795fcb8ce74071a93d7317d4e','c6799a0210f1226389b27a1fc24ed51a','b06596652da95f8b40d3d7b4c5c5eacd','d8ab4434d01c60404cde41eab9bb4adb','923bca44cc388a9ff60682f75c43334f','8edde822d3c330ea78a20c4eb210fd8c','a28099d87a402c528f6b392fa437ab9f','bec72927804eacbe20b9784ffdb8bce9','b29dc1de68e8cbdab91d0fa8ce832ae4','0bde2fd76deb9b2bc7cbc5d574cf4975','f48288e785297ff8a4606a6d469f6577','5d0f152aaae15450ba2036764f876fb6','dc72c59611c78ede15e24d57c46b1329','58b20b570bb5cb730302c1ccaba5289a','af1e70d3204268cbed943adfb1e361e8','fbc3e41a0c8aed17eb26c62c409303d1','522fc13b50407de502a09a56495a6900','503648befe4b6c9f93c364d59ad0505c','6f632c3a59065fff5e0b935ceebec1b2','4ddd5959cff3a9dd34315d4341f36419','90dfb5008124b0585e768c4eb8704752','ecf981dcff0b7f841de0b9572bf0131d','45879c3f28d2ff1a74d5a3ddd6fbd33b','94a8a240aa3099550170e84121e048c2','ac28cfe7a369c04a4e4aef17e98eb734','b3f61f78e574ba85d928825d5d0cb367','7d9ae07f22537f8c116782273f2068b4','05f557a0081318f066032e6a799542df','c3096a72d09b6f81c2b614db83070eb2')  AND gs.total_shows < 50 GROUP BY gallery_md5   ORDER BY g.priority, gs.total_ctr DESC, gs.total_shows ASC LIMIT 0, 5# queryitems;