17 requêtes
0.0309 sec.
© SELECT * FROM topics WHERE numtopic='987';
Requete effectuee en 2,2 ms
SELECT * FROM forums WHERE id='2';
Requete effectuee en 0,6 ms
SELECT * FROM niveaux WHERE id='14';
Requete effectuee en 0,6 ms
SELECT * FROM programmes_chapitres WHERE id='0';
Requete effectuee en 0,5 ms
DELETE FROM visites_ip WHERE date <> '2019/02/16 00:24';
Requete effectuee en 0,8 ms
SELECT ip FROM visites_ip_bl WHERE ip='18.212.206.217';
Requete effectuee en 0,5 ms
SELECT id, ip, date, cpt FROM visites_ip WHERE ip='18.212.206.217';
Requete effectuee en 0,9 ms
INSERT into visites_ip (id, ua, ip, date, cpt) values (null, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '18.212.206.217', '2019/02/16 00:24', '1');
Requete effectuee en 0,8 ms
SELECT COUNT(*) AS nb FROM posts WHERE numtopic='987';
Requete effectuee en 0,9 ms
SELECT id FROM posts WHERE numtopic='987' ORDER BY datet LIMIT 0,50;
Requete effectuee en 0,9 ms
SELECT
posts.*,
topics.id_membre_first,
forums.id AS forum_id, forums.nom AS forum_nom, forums.is_prive, forums.is_enigme, forums.is_blank, forums.is_prive,
mb.pseudo AS mbpseudo,mb.etat AS mbetat,mb.icon_avatar AS mbicon_avatar,
mb.id_niveau AS mbid_niveau, mb.id_spe AS mbid_spe, mb.sexe as mbsexe,
mb.d_correcteur AS mbd_correcteur, mb.d_moderateur AS mbd_moderateur, mb.d_webmaster AS mbd_webmaster, mb.d_enigmes AS mbd_enigmes, mb.d_html AS mbd_html, mb.id_ban AS mbid_ban,
niveaux.id AS niveau_id, niveaux.nom AS niveau_nom,
enigmes_en_cours.numtopic AS is_enigme_en_cours
FROM posts
LEFT JOIN topics ON posts.numtopic=topics.numtopic
LEFT JOIN forums ON topics.id_forum=forums.id
LEFT JOIN membres AS mb ON posts.id_membre=mb.id
LEFT JOIN niveaux ON topics.id_niveau=niveaux.id
LEFT JOIN enigmes_en_cours ON topics.numtopic=enigmes_en_cours.numtopic
WHERE posts.id IN (3005,3011)
ORDER BY posts.datet;
Requete effectuee en 1,4 ms
SELECT * FROM niveaux WHERE id='14';
Requete effectuee en 0,5 ms
SELECT * FROM programmes_chapitres WHERE id='0';
Requete effectuee en 0,5 ms
SELECT * FROM niveaux WHERE id='15';
Requete effectuee en 0,5 ms
SELECT COUNT(*) AS nb FROM fiches WHERE id_chapitre='' AND actif=1;
Requete effectuee en 0,4 ms
SELECT
f.id,
f.url,
f.sug_title,
id_type,
video,
sum(t.nb) as total
FROM
fiches as f
INNER JOIN fiches_telecharge as t on t.id = f.id
WHERE f.id_niveau = 15 AND f.actif = 1 GROUP BY t.id order by total desc limit 0, 5;
Requete effectuee en 0,4 ms
SELECT * FROM forums WHERE actif='1' ORDER BY ordre ASC;
Requete effectuee en 0,6 ms