Notice (8): Undefined offset: 0 [APP/app_controller.php, line 35]
Notice (8): Undefined offset: 0 [APP/app_controller.php, line 38]
Notice (8): Undefined offset: 0 [APP/app_controller.php, line 41]
Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/vhosts/eauxvives.org/httpdocs/cake/libs/debugger.php:686) [CORE/wwwroot/forum/includes/session.php, line 1042]
Eauxvives.org
 
 

Statistiques de niveaux

 
(default) 42 queries took 43 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `niveau_statistiques_consolides`551
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SHOW FULL COLUMNS FROM `niveau_stations_de_mesures`10101
4SHOW FULL COLUMNS FROM `niveau_source_donnees`661
5SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';111
6SHOW FULL COLUMNS FROM `niveau_donnees_temps_reels`12121
7SHOW FULL COLUMNS FROM `niveau_references_de_niveaux`11111
8SHOW FULL COLUMNS FROM `phpbb_users`76762
9SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_bin';111
10SHOW FULL COLUMNS FROM `topos`10101
11SHOW FULL COLUMNS FROM `topo_types`221
12SHOW FULL COLUMNS FROM `topo_bassins`221
13SHOW FULL COLUMNS FROM `topo_bassin_details`21211
14SHOW FULL COLUMNS FROM `topo_parcours`441
15SHOW FULL COLUMNS FROM `topo_parcours_details`25252
16SHOW FULL COLUMNS FROM `topo_rivieres`221
17SHOW FULL COLUMNS FROM `topo_riviere_details`35352
18SHOW FULL COLUMNS FROM `topo_spots`221
19SHOW FULL COLUMNS FROM `topo_spot_details`20201
20SHOW FULL COLUMNS FROM `niveaux`12121
21SHOW FULL COLUMNS FROM `niveau_evaluations`331
22SHOW FULL COLUMNS FROM `coordonnee_administrative_topos`331
23SHOW FULL COLUMNS FROM `coordonnees_administratives`991
24SHOW FULL COLUMNS FROM `coordonnee_administrative_types`221
25SHOW FULL COLUMNS FROM `attachments`19191
26SHOW FULL COLUMNS FROM `attachments_links`661
27SHOW FULL COLUMNS FROM `niveau_references_de_niveau_types`221
28SHOW FULL COLUMNS FROM `parametres`441
29SHOW FULL COLUMNS FROM `phpbb_profile_fields_data`12121
30SHOW FULL COLUMNS FROM `clubs_ffck`15151
31SHOW FULL COLUMNS FROM `petite_annonces`12121
32SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_swedish_ci';111
33SHOW FULL COLUMNS FROM `petite_annonce_types`551
34SHOW FULL COLUMNS FROM `petite_annonce_categories`221
35SHOW FULL COLUMNS FROM `petite_annonce_matos_types`331
36SHOW FULL COLUMNS FROM `petite_annonce_commentaires`661
37SHOW FULL COLUMNS FROM `petite_annonce_disciplines`331
38SHOW FULL COLUMNS FROM `petite_annonces_petite_annonce_disciplines`331
39SHOW FULL COLUMNS FROM `niveau_alertes`551
40SELECT `NiveauStatistiquesConsolide`.`id`, `NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id`, `NiveauStatistiquesConsolide`.`date_extraction`, `NiveauStatistiquesConsolide`.`hauteur_d_eau`, `NiveauStatistiquesConsolide`.`debit`, `NiveauStationsDeMesure`.`id`, `NiveauStationsDeMesure`.`nom`, `NiveauStationsDeMesure`.`niveau_source_donnee_id`, `NiveauStationsDeMesure`.`riviere`, `NiveauStationsDeMesure`.`web_adress2`, `NiveauStationsDeMesure`.`web_adress1`, `NiveauStationsDeMesure`.`comment`, `NiveauStationsDeMesure`.`actif`, `NiveauStationsDeMesure`.`created`, `NiveauStationsDeMesure`.`modified` FROM `niveau_statistiques_consolides` AS `NiveauStatistiquesConsolide` LEFT JOIN `niveau_stations_de_mesures` AS `NiveauStationsDeMesure` ON (`NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id` = `NiveauStationsDeMesure`.`id`) WHERE `NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id` = '0' 000
41SELECT `NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id`, EXTRACT(MONTH FROM NiveauStatistiquesConsolide.date_extraction ) as month, ROUND( AVG( NiveauStatistiquesConsolide.hauteur_d_eau ) , 2 ) as hauteur_d_eau, ROUND( AVG( NiveauStatistiquesConsolide.debit ) , 2 ) as debit FROM `niveau_statistiques_consolides` AS `NiveauStatistiquesConsolide` LEFT JOIN `niveau_stations_de_mesures` AS `NiveauStationsDeMesure` ON (`NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id` = `NiveauStationsDeMesure`.`id`) WHERE `NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id` = '0' GROUP BY `NiveauStatistiquesConsolide`.`niveau_stations_de_mesure_id`, EXTRACT(MONTH FROM `NiveauStatistiquesConsolide`.`date_extraction` ) 000
42SELECT `NiveauStationsDeMesure`.`id`, `NiveauStationsDeMesure`.`nom`, `NiveauStationsDeMesure`.`niveau_source_donnee_id`, `NiveauStationsDeMesure`.`riviere`, `NiveauStationsDeMesure`.`web_adress2`, `NiveauStationsDeMesure`.`web_adress1`, `NiveauStationsDeMesure`.`comment`, `NiveauStationsDeMesure`.`actif`, `NiveauStationsDeMesure`.`created`, `NiveauStationsDeMesure`.`modified` FROM `niveau_stations_de_mesures` AS `NiveauStationsDeMesure` WHERE `NiveauStationsDeMesure`.`riviere` IS NOT NULL ORDER BY `NiveauStationsDeMesure`.`riviere` ASC 5135131