[LangTuDaTinh]

Before:

PHP Code:


Query: 
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline

FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                       LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN signature ON signature.signatureid=user.signatureid
                       LEFT JOIN customsignature ON customsignature.userid=user.userid

LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,46438,893724,893756,893767,893789,895152,895308,895318,895320,895401,895825,895949,896089,896479,896613,896725)
GROUP BY post.postid
ORDER BY dateline 

Time before: 0.13210904598236
Time after:  0.93727195262909
Page generated in 1.2715369462967 seconds with 22 queries, 


Time before: 0.13210904598236
Time after: 0.93727195262909
Page generated in 1.2715369462967 seconds with 22 queries,


After

PHP Code:

Query: 
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
WHERE post.postid IN (0,46438,893724,893756,893767,893789,895152,895308,895318,895320,895401,895825,895949,896089,896479,896613,896725)
GROUP BY post.postid
ORDER BY dateline 

Time before: 0.091778039932251
Time after:  0.097924947738647
Page generated in 0.77503001689911 seconds with 22 queries, 


Time before: 0.091778039932251
Time after: 0.097924947738647
Page generated in 0.77503001689911 seconds with 22 queries,