rn7.net/wiki

MonRaspberryPi

PagePrincipale :: rn7.net :: DerniersChangements :: DerniersCommentaires :: ParametresUtilisateur :: Vous êtes ec2-54-196-2-131.compute-1.amazonaws.com
Affichage simplifié
 2017-09-06 13:49:23 par CharlesNepote
 2017-09-06 13:39:58 par CharlesNepote
 2016-11-20 22:06:38 par CharlesNepote
Query log :
delete from wikini_referrers where time < date_sub(now(), interval '24' day) (0.0005)
SELECT DISTINCT a.id FROM wikini_pages a,wikini_pages b WHERE a.latest = 'N' AND a.time < date_sub(now(), INTERVAL '90' DAY) AND a.tag = b.tag AND a.time < b.time AND b.time < date_sub(now(), INTERVAL '90' DAY) (0.0022)
SELECT * FROM wikini_pages WHERE tag = 'MonRaspberryPi' AND latest = 'Y' LIMIT 1 (0.0003)
SELECT id, value FROM wikini_triples WHERE resource = "http://www.wikini.net/_vocabulary/handler/revisions" AND property = "http://www.wikini.net/_vocabulary/acls" (0.0002)
SELECT id, value FROM wikini_triples WHERE resource = "ThisWikiGroup:admins" AND property = "http://www.wikini.net/_vocabulary/acls" (0.0002)
select * from wikini_acls where page_tag = 'MonRaspberryPi' and privilege = 'read' limit 1 (0.0002)
select * from wikini_pages where tag = 'MonRaspberryPi' order by time desc (0.0003)
SELECT * FROM wikini_pages WHERE tag = 'CharlesNepote' AND latest = 'Y' LIMIT 1 (0.0002)
SELECT id, value FROM wikini_triples WHERE resource = "http://www.wikini.net/_vocabulary/action/header" AND property = "http://www.wikini.net/_vocabulary/acls" (0.0002)
SELECT * FROM wikini_pages WHERE tag = 'DerniersChangements' AND latest = 'Y' LIMIT 1 (0.0002)
SELECT * FROM wikini_pages WHERE tag = 'DerniersCommentaires' AND latest = 'Y' LIMIT 1 (0.0002)
SELECT * FROM wikini_pages WHERE tag = 'ParametresUtilisateur' AND latest = 'Y' LIMIT 1 (0.0002)
SELECT id, value FROM wikini_triples WHERE resource = "http://www.wikini.net/_vocabulary/action/footer" AND property = "http://www.wikini.net/_vocabulary/acls" (0.0002)
select * from wikini_acls where page_tag = 'MonRaspberryPi' and privilege = 'write' limit 1 (0.0002)
0.0052 s (total SQL time)
0.0365 s (total time)
SQL time represent : 14.2% of total time