Nouveaux membres

Messages / Fichiers

memcache [memcached-1.2.2.tar.gz]

matt il y a 8 mois via web | 0 réponse(s) / Répondre |

© Allty 2008

Execution time: -1219977038.2673 | Queries cached : 1 | Queries without cache : 6 | Show / HideSELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5checkSELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, '8d92df9afa1d5d393ce9b20dbb35731a' as md5check
SELECT GROUP_CONCAT(username) as last_members FROM users WHERE picture=1 ORDER BY date_sub DESC LIMIT 15SELECT 	SQL_CALC_FOUND_ROWS 
						m.id `id`,
						GROUP_CONCAT(r.`rcpt_username`) `to`,
						m.msg_sent_time `date`,
						m.message,
						m.from_username `sender`,
						m.appid `app`,
						m.msg_replying_to `replying_to`,
						m.users_group `users_group`,
						m.`replies`,
						u.sex `sender_sex`,
						CASE 	WHEN m.msg_type & b'1' THEN 'text'
					 	WHEN m.msg_type & b'100' THEN 'file'
						WHEN m.msg_type & b'10' THEN 'link'
						WHEN m.msg_type & b'1000' THEN 'event'
						WHEN m.msg_type & b'10000' THEN 'video'
						END `content_type`,
IF(m.msg_type & b'10000000', 'public', 'private') `visibility` 
				FROM
					msg `m`
				LEFT JOIN msg_recipients `r` ON(m.id=r.msg_id)
				LEFT JOIN users `u` ON (m.from_username = u.username)
				WHERE 1=1 AND m.msg_type & b'10000000' 
 AND m.msg_type & b'100' 

				GROUP BY m.id
				ORDER BY m.id DESC LIMIT 0,30
SELECT FOUND_ROWS() as total, 'b605226295048b68f637406cb1fa0bbb' as md5check