- © Team EVO - 2008,2009
(default) 58 queries took 481 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `phpbb_users`76763
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
3SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12122
4SHOW FULL COLUMNS FROM `clubs_ffck`15152
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
6SHOW FULL COLUMNS FROM `petite_annonces`12122
7SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
8SHOW FULL COLUMNS FROM `petite_annonce_types`552
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
10SHOW FULL COLUMNS FROM `petite_annonce_categories`222
11SHOW FULL COLUMNS FROM `petite_annonce_matos_types`332
12SHOW FULL COLUMNS FROM `attachments`19192
13SHOW FULL COLUMNS FROM `attachments_links`662
14SHOW FULL COLUMNS FROM `petite_annonce_commentaires`662
15SHOW FULL COLUMNS FROM `petite_annonce_disciplines`332
16SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`332
17SHOW FULL COLUMNS FROM `niveau_alertes`552
18SHOW FULL COLUMNS FROM `topos`10102
19SHOW FULL COLUMNS FROM `topo_types`222
20SHOW FULL COLUMNS FROM `topo_bassins`222
21SHOW FULL COLUMNS FROM `topo_bassin_details`21212
22SHOW FULL COLUMNS FROM `topo_parcours`442
23SHOW FULL COLUMNS FROM `topo_parcours_details`25252
24SHOW FULL COLUMNS FROM `topo_rivieres`222
25SHOW FULL COLUMNS FROM `topo_riviere_details`35353
26SHOW FULL COLUMNS FROM `topo_spots`222
27SHOW FULL COLUMNS FROM `topo_spot_details`20202
28SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11112
29SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10102
30SHOW FULL COLUMNS FROM `niveau_source_donnees`662
31SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12122
32SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`222
33SHOW FULL COLUMNS FROM `niveaux`12122
34SHOW FULL COLUMNS FROM `niveau_evaluations`332
35SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`332
36SHOW FULL COLUMNS FROM `coordonnees_administratives`992
37SHOW FULL COLUMNS FROM `coordonnee_administrative_types`222
38 SELECT Topics.topic_id, Topics.topic_title, Forums.forum_name, Topics.topic_last_post_time,Topics.topic_replies, Topics.topic_last_post_id FROM phpbb_topics Topics INNER JOIN phpbb_forums Forums on Topics.forum_id = Forums.forum_id WHERE Topics.forum_id not in (13,15,34,46,4,23,24,25,26,32,33,35,38,41,45,48,49,50,51,53,54,"28") ORDER BY Topics.topic_last_post_time DESC limit 1515151
39SELECT * FROM `attachments` AS Image INNER JOIN attachments_links AL ON Image.id=AL.attachment_id INNER JOIN topos Topo ON AL.foreign_id=Topo.id INNER JOIN topo_types TT on Topo.topo_type_id=TT.id LEFT JOIN topos T2 ON Topo.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=Topo.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id WHERE Image.`mimetype` LIKE 'image%' AND Image.`class` = 'Topo' AND AL.`class` = 'Topo' AND Image.peut_illustrer=1 ORDER BY rand() ASC LIMIT 111406
40SELECT 'Parcours' AS type_icone , 'topos' AS type , 'Parcours' AS label_icone , T.id AS id, T.slug AS slug, T2.slug as slug_riviere, TP.numero_ordre as numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, TPD.modified AS date FROM `topo_parcours_details` TPD INNER JOIN topo_parcours TP ON TP.id = TPD.`topo_parcours_id` INNER JOIN topos T ON TP.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id WHERE TPD.etat = 0 union all SELECT 'Riviere' AS type_icone , 'topos' AS type , 'Riviere' AS label_icone , T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre, TRD.nom AS nom, TRD.modified AS date FROM `topo_riviere_details` TRD INNER JOIN topo_rivieres TR ON TR.id = TRD.topo_riviere_id INNER JOIN topos T ON TR.topo_id = T.id WHERE TRD.etat = 0 union all SELECT 'Bassin' AS type_icone , 'topos' AS type , 'Bassin' AS label_icone , T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre,TBD.nom AS nom, TBD.date_premiere_publication AS date FROM `topo_bassin_details` TBD INNER JOIN topo_bassins TB ON TB.id = TBD.`topo_bassin_id` INNER JOIN topos T ON TB.topo_id = T.id WHERE TBD.etat = 0 union all SELECT 'Spot' AS type_icone, 'topos' AS type , 'Spot' AS label_icone, T.id AS id, T.slug AS slug, null as slug_riviere, null as numero_ordre,TSD.nom AS nom, TSD.date_premiere_publication AS date FROM `topo_spot_details` TSD INNER JOIN topo_spots TS ON TS.id = TSD.`topo_spot_id` INNER JOIN topos T ON TS.topo_id = T.id WHERE TSD.etat = 0 union all SELECT 'Parcours' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T2.slug AS slug_riviere, TP.numero_ordre AS numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id =4 union all SELECT distinct 'Spot' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 2 union all SELECT distinct 'Bassin' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 3 union all SELECT distinct 'Riviere' AS type_icone, 'topo_commentaires' AS type , 'Commentaire' AS label_icone, T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, TC.created AS date FROM topo_commentaires TC INNER JOIN topos T ON TC.topo_id = T.id WHERE T.topo_type_id = 1 union all SELECT DISTINCT 'Carto' AS type_icone, 'Carto' AS type , 'Carto' AS label_icone, min(CC.id) AS id, min(T.slug) AS slug, min(T.slug) AS slug_riviere, 0 AS numero_ordre, min(CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END) as nom, min(CC.created) AS date FROM `carto_coordonnees` CC INNER JOIN carto_types CT on CC.carto_type_id=CT.id INNER JOIN topos T ON CC.`objet_id` = T.id and carto_type_id not in (5,6) LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id LEFT JOIN topo_bassins TB ON TB.topo_id=T.id LEFT JOIN topo_bassin_details TBD ON TBD.topo_bassin_id=TB.id LEFT JOIN topo_spots TS ON TS.topo_id=T.id LEFT JOIN topo_spot_details TSD ON TSD.topo_spot_id=TS.id group by CC.objet_id union all SELECT DISTINCT 'RefNiveau' AS type_icone, 'RefNiveau' AS type , 'Niveau calibrage' AS label_icone, CASE T.topo_type_id WHEN 4 THEN T.parent_id ELSE RN.topo_id END AS id, min(T.slug) AS slug, min(T.slug) AS slug_riviere, RN.topo_id AS numero_ordre, min(CASE T.topo_type_id WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) ELSE T.nom END) as nom, min(RN.modified) AS date FROM `niveau_references_de_niveaux` RN INNER JOIN topos T ON RN.`topo_id` = T.id LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id LEFT JOIN topo_bassins TB ON TB.topo_id=T.id LEFT JOIN topo_bassin_details TBD ON TBD.topo_bassin_id=TB.id LEFT JOIN topo_spots TS ON TS.topo_id=T.id LEFT JOIN topo_spot_details TSD ON TSD.topo_spot_id=TS.id group by RN.topo_id order by date desc limit 1515150
41SELECT 'Parcours' AS type_icone , 'dernieres_descentes' AS type , 'Dernière descente' AS label_icone , T.id AS id, T.slug AS slug, T2.slug as slug_riviere, TP.numero_ordre as numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, DD.quand AS date FROM dernieres_descentes DD INNER JOIN topos T ON DD.topo_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id=4 union all SELECT distinct CASE IF(T.topo_type_id is NULL,0,T.topo_type_id) WHEN 0 THEN 'Niveau' WHEN 1 THEN 'Riviere' WHEN 2 THEN 'Spot' WHEN 3 THEN 'Bassin' WHEN 4 THEN 'Parcours' ELSE 'Error' END as type_icone, 'niveaux' AS type , 'Niveau' as label_icone, N.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, CASE IF(T.topo_type_id is NULL,0,T.topo_type_id) WHEN 4 THEN concat(T2.nom," P",TP.numero_ordre) WHEN 0 THEN N.label_pas_topo ELSE T.nom END as nom, N.quand AS date FROM niveaux N LEFT JOIN topos T ON N.topo_id = T.id LEFT JOIN topos T2 ON T.parent_id=T2.id LEFT JOIN topo_parcours TP ON TP.topo_id=T.id LEFT JOIN topo_parcours_details TPD ON TPD.topo_parcours_id=TP.id LEFT JOIN topo_bassins TB ON TB.topo_id=T.id LEFT JOIN topo_bassin_details TBD ON TBD.topo_bassin_id=TB.id LEFT JOIN topo_spots TS ON TS.topo_id=T.id LEFT JOIN topo_spot_details TSD ON TSD.topo_spot_id=TS.id order by date desc limit 1515150
42SHOW FULL COLUMNS FROM `manifestations`12121
43SELECT `Manifestation`.`id`, `Manifestation`.`user_id`, `Manifestation`.`title`, `Manifestation`.`body`, `Manifestation`.`short`, `Manifestation`.`date_debut`, `Manifestation`.`date_fin`, `Manifestation`.`site_web`, `Manifestation`.`created`, `Manifestation`.`modified`, `Manifestation`.`slug`, `Manifestation`.`forum`, `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_website`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar` FROM `manifestations` AS `Manifestation` LEFT JOIN `phpbb_users` AS `Membre` ON (`Manifestation`.`user_id` = `Membre`.`user_id`) WHERE `date_debut` >= '2020-01-18' ORDER BY rand() ASC LIMIT 1111
44SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'manifestation' AND `Image`.`foreign_id` = (287) 110
45SELECT `Manifestation`.`id`, `Manifestation`.`title` FROM `manifestations` AS `Manifestation` WHERE `Manifestation`.`id` = 287 LIMIT 1110
46 SELECT distinct 'Parcours' AS type_icone, 'Photo' AS type , 'Parcours' AS label_icone , T.id AS id, T.slug AS slug, T2.slug AS slug_riviere, TP.numero_ordre AS numero_ordre, concat( T2.nom, ' P', TP.numero_ordre ) AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id INNER JOIN topos T2 ON T.parent_id = T2.id INNER JOIN topo_parcours TP ON TP.topo_id = T.id INNER JOIN topo_parcours_details TPD ON TP.id = TPD.topo_parcours_id WHERE T.topo_type_id =4 and ATT.class='Topo' union all SELECT distinct 'Spot' AS type_icone, 'Photo' AS type , 'Spot' AS label_icone , T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id WHERE T.topo_type_id = 2 and ATT.class='Topo' union all SELECT distinct 'Bassin' AS type_icone, 'Photo' AS type , 'Bassin' AS label_icone , T.id AS id, T.slug AS slug, T.slug AS slug_riviere, 0 AS numero_ordre, T.nom AS nom, date(ATT.created) AS date FROM attachments ATT INNER JOIN topos T ON ATT.foreign_id = T.id WHERE T.topo_type_id = 3 and ATT.class='Topo' ORDER BY date DESC LIMIT 15 15150
47SELECT `Membre`.`user_id`, `Membre`.`user_regdate`, `Membre`.`username`, `Membre`.`username_clean`, `Membre`.`user_website`, `Membre`.`user_email`, `Membre`.`user_lastvisit`, `Membre`.`user_posts`, `Membre`.`user_avatar`, `Profil`.`user_id`, `Profil`.`pf_prenom`, `Profil`.`pf_nom`, `Profil`.`pf_ville`, `Profil`.`pf_bateau`, `Profil`.`pf_pratique`, `Profil`.`pf_region`, `Profil`.`pf_departement`, `Profil`.`pf_club`, `Profil`.`pf_infos_rivieres`, `Profil`.`pf_photo`, `Profil`.`pf_autres_infos` FROM `phpbb_users` AS `Membre` LEFT JOIN `phpbb_profile_fields_data` AS `Profil` ON (`Membre`.`user_id` = `Profil`.`user_id`) WHERE 1 = 1 ORDER BY `user_regdate` DESC LIMIT 1515150
48SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`user_id` IN (17234, 17233, 17232, 17231, 17230, 17228, 17227, 17226, 17225, 17224, 17223, 17222, 17221, 17220, 17219) 550
49SELECT `NiveauAlerte`.`id`, `NiveauAlerte`.`user_id`, `NiveauAlerte`.`topo_id`, `NiveauAlerte`.`modified`, `NiveauAlerte`.`created` FROM `niveau_alertes` AS `NiveauAlerte` WHERE `NiveauAlerte`.`user_id` IN (17234, 17233, 17232, 17231, 17230, 17228, 17227, 17226, 17225, 17224, 17223, 17222, 17221, 17220, 17219) 000
50SELECT `PetiteAnnonce`.`id`, `PetiteAnnonce`.`user_id`, `PetiteAnnonce`.`ip`, `PetiteAnnonce`.`petite_annonce_type_id`, `PetiteAnnonce`.`petite_annonce_matos_type_id`, `PetiteAnnonce`.`contact`, `PetiteAnnonce`.`titre`, `PetiteAnnonce`.`commentaire`, `PetiteAnnonce`.`prix`, `PetiteAnnonce`.`slug`, `PetiteAnnonce`.`created`, `PetiteAnnonce`.`modified`, `Membre`.`user_id`, `Membre`.`username`, `Membre`.`username_clean`, `PetiteAnnonceType`.`id`, `PetiteAnnonceType`.`nom`, `PetiteAnnonceType`.`action`, `PetiteAnnonceType`.`petite_annonce_categorie_id`, `PetiteAnnonceType`.`slug`, `PetiteAnnonceMatosType`.`id`, `PetiteAnnonceMatosType`.`nom`, `PetiteAnnonceMatosType`.`slug` FROM `petite_annonces` AS `PetiteAnnonce` LEFT JOIN `phpbb_users` AS `Membre` ON (`PetiteAnnonce`.`user_id` = `Membre`.`user_id`) LEFT JOIN `petite_annonce_types` AS `PetiteAnnonceType` ON (`PetiteAnnonce`.`petite_annonce_type_id` = `PetiteAnnonceType`.`id`) LEFT JOIN `petite_annonce_matos_types` AS `PetiteAnnonceMatosType` ON (`PetiteAnnonce`.`petite_annonce_matos_type_id` = `PetiteAnnonceMatosType`.`id`) WHERE 1 = 1 ORDER BY `created` DESC LIMIT 1515150
51SELECT `Image`.`id`, `Image`.`class`, `Image`.`foreign_id`, `Image`.`filename`, `Image`.`slug`, `Image`.`dir`, `Image`.`mimetype`, `Image`.`filesize`, `Image`.`height`, `Image`.`width`, `Image`.`thumb`, `Image`.`description`, `Image`.`proprietaire`, `Image`.`proprietaire_url`, `Image`.`proprietaire_email`, `Image`.`user_id`, `Image`.`peut_illustrer`, `Image`.`created`, `Image`.`modified` FROM `attachments` AS `Image` WHERE `Image`.`class` = 'PetiteAnnonce' AND `Image`.`foreign_id` IN (15611, 15610, 15609, 15608, 15602, 15595, 15594, 15593, 15592, 15583, 15576, 15575, 15574, 15571, 15570) 440
52SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15575 LIMIT 1110
53SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15592 LIMIT 1110
54SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15593 LIMIT 1110
55SELECT `PetiteAnnonce`.`id` FROM `petite_annonces` AS `PetiteAnnonce` WHERE `PetiteAnnonce`.`id` = 15595 LIMIT 1110
56SELECT `PetiteAnnonceCommentaire`.`id`, `PetiteAnnonceCommentaire`.`petite_annonce_id`, `PetiteAnnonceCommentaire`.`auteur_id`, `PetiteAnnonceCommentaire`.`commentaire`, `PetiteAnnonceCommentaire`.`created`, `PetiteAnnonceCommentaire`.`modified` FROM `petite_annonce_commentaires` AS `PetiteAnnonceCommentaire` WHERE `PetiteAnnonceCommentaire`.`petite_annonce_id` IN (15611, 15610, 15609, 15608, 15602, 15595, 15594, 15593, 15592, 15583, 15576, 15575, 15574, 15571, 15570) 000
57SELECT `PetiteAnnonceDiscipline`.`id`, `PetiteAnnonceDiscipline`.`nom`, `PetiteAnnonceDiscipline`.`slug`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id`, `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` FROM `petite_annonce_disciplines` AS `PetiteAnnonceDiscipline` JOIN `petite_annonces_petite_annonce_disciplines` AS `PetiteAnnoncesPetiteAnnonceDiscipline` ON (`PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_id` IN (15611, 15610, 15609, 15608, 15602, 15595, 15594, 15593, 15592, 15583, 15576, 15575, 15574, 15571, 15570) AND `PetiteAnnoncesPetiteAnnonceDiscipline`.`petite_annonce_discipline_id` = `PetiteAnnonceDiscipline`.`id`) 15150
58SELECT AL.annu_lien_name, AL.annu_lien_url , FROM_UNIXTIME(AL.annu_lien_time) as date, AL.annu_lien_cat, AC.annu_cat_name , AC1.annu_cat_name as cat1, AC2.annu_cat_name as cat2, AC3.annu_cat_name as cat3 FROM phpbb_annuaire_liens AL inner join phpbb_annuaire_cats AC on AL.`annu_lien_cat`=AC.`annu_cat_id` left join phpbb_annuaire_cats AC1 on AC.parent_id=AC1.annu_cat_id left join phpbb_annuaire_cats AC2 on AC1.parent_id=AC2.annu_cat_id left join phpbb_annuaire_cats AC3 on AC2.parent_id=AC3.annu_cat_id ORDER BY AL.annu_lien_time desc LIMIT 1515150