|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190708 3:44:36
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.197863 Lock_time: 0.000064 Rows_sent: 36 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562550276;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 01:44:36.050916' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 4:33:32
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.058489 Lock_time: 0.039872 Rows_sent: 15 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562553212;
|
|
SELECT COUNT(*) AS count_all, extract(year from start_time) AS extract_year_from_start_time FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 13 GROUP BY extract(year from start_time);
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190708 6:39:05
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000062 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562560745;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('helpers.label.event.repeat') OR `key` LIKE 'helpers.label.event.repeat.%') LIMIT 1;
|
|
# Time: 190708 6:45:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000084 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562561144;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('countries.Friesland') OR `key` LIKE 'countries.Friesland.%') LIMIT 1;
|
|
# Time: 190708 7:11:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.136518 Lock_time: 0.000053 Rows_sent: 36 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562562666;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 05:11:05.880651' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 7:15:51
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.192623 Lock_time: 0.000052 Rows_sent: 36 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562562951;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 05:15:51.660588' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 8:20:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.103036 Lock_time: 0.000057 Rows_sent: 6 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562566802;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-08 06:20:02.555813' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190708 12:06:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000795 Lock_time: 0.000047 Rows_sent: 20 Rows_examined: 37
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562580369;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-08 10:06:09.143317' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190708 12:07:43
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097984 Lock_time: 0.000054 Rows_sent: 36 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562580463;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 10:07:43.706291' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 13:15:16
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.192947 Lock_time: 0.000047 Rows_sent: 36 Rows_examined: 17318
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562584516;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 11:15:16.734931' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 13:39:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.003607 Lock_time: 0.000062 Rows_sent: 7 Rows_examined: 6847
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562585973;
|
|
SELECT `tags`.* FROM `tags` WHERE (LOWER(name) = LOWER('aldil') OR LOWER(name) = LOWER('blender') OR LOWER(name) = LOWER('creation-numerique') OR LOWER(name) = LOWER('epn-des-rancy') OR LOWER(name) = LOWER('logiciels-libres') OR LOWER(name) = LOWER('mercredi-numérique') OR LOWER(name) = LOWER('atelier'));
|
|
# Time: 190708 14:20:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001165 Lock_time: 0.000051 Rows_sent: 6 Rows_examined: 562
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562588433;
|
|
SELECT COUNT(*) AS count_all, `orgas`.`kind_id` AS orgas_kind_id FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`active` = TRUE GROUP BY `orgas`.`kind_id`;
|
|
# Time: 190708 14:32:29
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000541 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562589149;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-08 12:32:29.599135' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190708 14:42:19
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096823 Lock_time: 0.000054 Rows_sent: 37 Rows_examined: 17328
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562589739;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-08 12:42:19.236548' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 16:16:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.182365 Lock_time: 0.000043 Rows_sent: 6 Rows_examined: 17329
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562595391;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-08 14:16:31.582999' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190708 17:40:11
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000062 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562600411;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'pt' AND (`key` IN ('countries.Overijssel') OR `key` LIKE 'countries.Overijssel.%') LIMIT 1;
|
|
# Time: 190708 18:47:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001868 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 165
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562604445;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND ('2019-07-08 16:47:25.475622' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190708 19:34:23
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 112 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.028907 Lock_time: 0.000105 Rows_sent: 20 Rows_examined: 17349
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562607263;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.5541362) / 57.2957795), ((events.latitude - 47.2186371) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND (events.latitude BETWEEN 46.567344076001184 AND 47.86993012399882 AND events.longitude BETWEEN -2.5130445176091003 AND -0.5952278823908996 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '45') AND ('2019-07-08 17:34:23.811222' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190708 20:51:29
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.011461 Lock_time: 0.000039 Rows_sent: 1 Rows_examined: 17329
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562611889;
|
|
SELECT COUNT(*) FROM `events` WHERE `events`.`moderated` = 0;
|
|
# Time: 190708 20:56:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 111 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000557 Lock_time: 0.000062 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562612185;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-08 18:56:25.811628' <= end_time) ORDER BY id desc LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190709 8:30:55
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000063 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562653855;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'pt-BR' AND (`key` IN ('countries.Zeeland') OR `key` LIKE 'countries.Zeeland.%') LIMIT 1;
|
|
# Time: 190709 9:17:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001184 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 68
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562656629;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (end_time <= '2019-11-06 07:17:09.797427') AND ('2019-07-09 07:17:09.797899' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190709 9:50:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.005294 Lock_time: 0.000029 Rows_sent: 1 Rows_examined: 29149
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562658644;
|
|
SELECT COUNT(*) FROM `versions`;
|
|
# Time: 190709 11:41:21
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000697 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562665281;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-09 09:41:21.007659' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190709 13:17:04
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014370 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 1626
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562671024;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-09 11:17:03.990040' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190709 13:28:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.003557 Lock_time: 0.000042 Rows_sent: 8 Rows_examined: 6850
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562671713;
|
|
SELECT `tags`.* FROM `tags` WHERE (LOWER(name) = LOWER('aldil') OR LOWER(name) = LOWER('bidouille') OR LOWER(name) = LOWER('entraide') OR LOWER(name) = LOWER('epn-des-rancy') OR LOWER(name) = LOWER('install-party') OR LOWER(name) = LOWER('libre-en-fete-2020') OR LOWER(name) = LOWER('linux') OR LOWER(name) = LOWER('logiciels-libres'));
|
|
# Time: 190709 14:01:29
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 699 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.009886 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 29154
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562673689;
|
|
SELECT COUNT(*) FROM `versions`;
|
|
# Time: 190709 14:42:26
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097458 Lock_time: 0.000051 Rows_sent: 37 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562676146;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-09 12:42:26.163214' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190709 16:50:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000063 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562683856;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('event_mailer.accept.reminder') OR `key` LIKE 'event_mailer.accept.reminder.%') LIMIT 1;
|
|
# Time: 190709 19:26:04
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000076 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562693164;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'nl' AND (`key` IN ('countries.Bruxelles') OR `key` LIKE 'countries.Bruxelles.%') LIMIT 1;
|
|
# Time: 190709 22:41:36
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014713 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562704896;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-09 20:41:36.179137' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190709 23:44:30
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096545 Lock_time: 0.000051 Rows_sent: 42 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562708670;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND ('2019-07-09 21:44:30.485719' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 0:44:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.195715 Lock_time: 0.000048 Rows_sent: 35 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562712252;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-09 22:44:12.576731' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 4:20:30
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 698 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.121659 Lock_time: 0.000055 Rows_sent: 35 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562725230;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 02:20:29.999418' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190710 8:24:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.095512 Lock_time: 0.000054 Rows_sent: 6 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562739849;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-10 06:24:08.968696' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 9:15:57
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014231 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562742957;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-10 07:15:57.180796' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190710 10:52:14
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096907 Lock_time: 0.000052 Rows_sent: 35 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562748734;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 08:52:14.543226' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 12:09:08
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096889 Lock_time: 0.000053 Rows_sent: 35 Rows_examined: 17334
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562753348;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 10:09:08.704050' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 13:46:30
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014270 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 17335
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562759190;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-10 11:46:30.150588' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190710 14:21:17
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096127 Lock_time: 0.000054 Rows_sent: 3 Rows_examined: 17336
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562761277;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND ('2019-07-10 12:21:17.155256' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 18:08:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.129562 Lock_time: 0.000084 Rows_sent: 35 Rows_examined: 17336
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562774924;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 16:08:43.922526' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 18:45:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097064 Lock_time: 0.000052 Rows_sent: 35 Rows_examined: 17336
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562777118;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 16:45:18.754830' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190710 18:50:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.026406 Lock_time: 0.000047 Rows_sent: 20 Rows_examined: 1639
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562777441;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 16:50:41.034202' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 19:22:52
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000935 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 550
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562779372;
|
|
SELECT COUNT(*) FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`active` = TRUE;
|
|
# Time: 190710 21:40:36
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1286 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000985 Lock_time: 0.000021 Rows_sent: 8 Rows_examined: 550
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562787636;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`region_id` = 92;
|
|
# Time: 190710 22:20:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000511 Lock_time: 0.000061 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562790002;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-10 20:20:02.745909' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 22:54:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.095908 Lock_time: 0.000054 Rows_sent: 6 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562792052;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-10 20:54:11.925764' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 23:05:34
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1286 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.025990 Lock_time: 0.000049 Rows_sent: 20 Rows_examined: 1640
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562792734;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-10 21:05:34.070879' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190710 23:39:39
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096070 Lock_time: 0.000031 Rows_sent: 4 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562794779;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 2 AND ('2019-07-10 21:39:39.088428' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190711 3:07:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098974 Lock_time: 0.000065 Rows_sent: 35 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562807223;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 01:07:03.525768' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 3:28:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097327 Lock_time: 0.000052 Rows_sent: 35 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562808505;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 01:28:25.233695' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 6:15:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1285 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.126713 Lock_time: 0.000056 Rows_sent: 35 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562818503;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 04:15:03.152724' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190711 6:55:42
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1873 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000067 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562820942;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('activerecord.attributes.orga.active') OR `key` LIKE 'activerecord.attributes.orga.active.%') LIMIT 1;
|
|
# Time: 190711 12:01:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000905 Lock_time: 0.000058 Rows_sent: 20 Rows_examined: 54
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562839301;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-11 10:01:41.400716' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190711 12:05:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.114455 Lock_time: 0.000054 Rows_sent: 35 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562839535;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 10:05:34.959943' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 13:07:11
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.203037 Lock_time: 0.000038 Rows_sent: 1 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562843231;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` IN (27, 31) AND ('2019-07-11 11:07:11.521286' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190711 13:09:24
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096951 Lock_time: 0.000056 Rows_sent: 6 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562843364;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-11 11:09:24.789122' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190711 14:46:38
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1873 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.027632 Lock_time: 0.000103 Rows_sent: 20 Rows_examined: 17357
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562849198;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.5541362) / 57.2957795), ((events.latitude - 47.2186371) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND (events.latitude BETWEEN 46.567344076001184 AND 47.86993012399882 AND events.longitude BETWEEN -2.5130445176091003 AND -0.5952278823908996 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '45') AND ('2019-07-11 12:46:38.401647' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190711 14:48:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001022 Lock_time: 0.000031 Rows_sent: 5 Rows_examined: 560
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562849292;
|
|
SELECT COUNT(*) AS count_all, `orgas`.`kind_id` AS orgas_kind_id FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`region_id` = 13 AND `orgas`.`active` = TRUE GROUP BY `orgas`.`kind_id`;
|
|
# Time: 190711 15:53:42
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097831 Lock_time: 0.000054 Rows_sent: 35 Rows_examined: 17337
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562853222;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 13:53:42.111301' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 16:33:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099787 Lock_time: 0.000053 Rows_sent: 35 Rows_examined: 17338
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562855583;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 14:33:03.244103' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 17:27:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001105 Lock_time: 0.000054 Rows_sent: 6 Rows_examined: 562
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562858855;
|
|
SELECT COUNT(*) AS count_all, `orgas`.`kind_id` AS orgas_kind_id FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`region_id` = 12 AND `orgas`.`active` = TRUE GROUP BY `orgas`.`kind_id`;
|
|
# Time: 190711 23:27:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096916 Lock_time: 0.000052 Rows_sent: 35 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562880476;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 21:27:56.079403' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 23:32:00
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.102544 Lock_time: 0.000082 Rows_sent: 35 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562880720;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 21:32:00.496125' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 23:39:49
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099614 Lock_time: 0.000057 Rows_sent: 35 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562881189;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 21:39:49.416897' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190711 23:46:58
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097240 Lock_time: 0.000052 Rows_sent: 35 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562881618;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 21:46:58.039673' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 1:12:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.162504 Lock_time: 0.000053 Rows_sent: 34 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562886764;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-11 23:12:44.008840' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 1:23:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014263 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562887389;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-11 23:23:09.160242' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190712 2:28:17
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.155201 Lock_time: 0.000069 Rows_sent: 34 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562891297;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 00:28:17.801285' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 4:03:32
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000479 Lock_time: 0.000050 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562897012;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-12 02:03:32.666038' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190712 4:06:48
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098928 Lock_time: 0.000071 Rows_sent: 34 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562897208;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 02:06:48.803872' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 5:16:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000561 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562901378;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-12 03:16:18.257991' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190712 5:19:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098132 Lock_time: 0.000059 Rows_sent: 6 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562901571;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-12 03:19:31.472328' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190712 5:24:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 1872 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096704 Lock_time: 0.000052 Rows_sent: 34 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562901858;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 03:24:18.504907' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190712 6:36:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000497 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562906172;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-12 04:36:12.301001' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190712 7:13:28
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014183 Lock_time: 0.000119 Rows_sent: 0 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562908408;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-12 05:13:28.193597' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190712 7:35:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096986 Lock_time: 0.000052 Rows_sent: 34 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562909709;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 05:35:09.745193' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 8:36:32
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.023774 Lock_time: 0.000102 Rows_sent: 0 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562913392;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-12 06:36:32.164467' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190712 9:18:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.128758 Lock_time: 0.000052 Rows_sent: 6 Rows_examined: 17348
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562915936;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-12 07:18:55.880619' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 10:49:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2463 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000196 Lock_time: 0.000043 Rows_sent: 1 Rows_examined: 4
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562921375;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`name` = 'provider' LIMIT 1;
|
|
# Time: 190712 14:45:34
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000097 Lock_time: 0.000023 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562935534;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'pt-BR' AND (`key` IN ('helpers.submit.create') OR `key` LIKE 'helpers.submit.create.%') LIMIT 1;
|
|
# Time: 190712 16:50:14
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2463 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000328 Lock_time: 0.000049 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562943014;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-12 14:50:14.981864' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190712 16:54:46
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097710 Lock_time: 0.000054 Rows_sent: 34 Rows_examined: 17389
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562943286;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 14:54:46.596246' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190712 17:54:37
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2463 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000144 Lock_time: 0.000045 Rows_sent: 1 Rows_examined: 6
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562946877;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`name` = 'thirdPlace' LIMIT 1;
|
|
# Time: 190712 22:57:42
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014802 Lock_time: 0.000112 Rows_sent: 20 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562965062;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.5541362) / 57.2957795), ((events.latitude - 47.2186371) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND (events.latitude BETWEEN 46.567344076001184 AND 47.86993012399882 AND events.longitude BETWEEN -2.5130445176091003 AND -0.5952278823908996 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '45') AND ('2019-07-12 20:57:42.755369' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190712 23:30:54
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.124690 Lock_time: 0.000053 Rows_sent: 6 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562967054;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-12 21:30:53.946084' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190713 0:01:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2463 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.151900 Lock_time: 0.050124 Rows_sent: 33 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562968878;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-12 22:01:18.181379' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190713 0:06:17
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000972 Lock_time: 0.000023 Rows_sent: 1 Rows_examined: 551
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1562969177;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`region_id` = 94 AND `orgas`.`active` = TRUE ORDER BY `orgas`.`updated_at` DESC LIMIT 25 OFFSET 0;
|
|
# Time: 190713 0:14:21
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.101791 Lock_time: 0.000060 Rows_sent: 247 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562969661;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-12 22:14:21.456795' <= end_time) ORDER BY `events`.`id` ASC LIMIT 1000;
|
|
# Time: 190713 4:50:49
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 2462 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.005908 Lock_time: 0.000017 Rows_sent: 1 Rows_examined: 29237
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562986249;
|
|
SELECT COUNT(*) FROM `versions`;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190713 7:05:29
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.100078 Lock_time: 0.000053 Rows_sent: 33 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1562994329;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-13 05:05:29.748757' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190713 8:10:34
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.110499 Lock_time: 0.000033 Rows_sent: 3475 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562998234;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND `events`.`region_id` = 13;
|
|
# Time: 190713 8:18:46
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000065 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1562998726;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('time.formats.short') OR `key` LIKE 'time.formats.short.%') LIMIT 1;
|
|
# Time: 190713 8:48:40
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001312 Lock_time: 0.000039 Rows_sent: 37 Rows_examined: 550
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563000520;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`region_id` = 2;
|
|
# Time: 190713 9:46:50
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000384 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563004010;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-13 07:46:50.225111' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190713 9:51:45
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015508 Lock_time: 0.000109 Rows_sent: 2 Rows_examined: 17395
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563004305;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.6800198) / 57.2957795), ((events.latitude - 48.1113387) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND (events.latitude BETWEEN 47.38767978444576 AND 48.83499761555424 AND events.longitude BETWEEN -2.7638522211778036 AND -0.5961873788221963 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-13 07:51:45.712310' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190713 11:06:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097468 Lock_time: 0.000052 Rows_sent: 33 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563008766;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-13 09:06:06.806594' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190713 11:56:52
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000940 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 550
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563011812;
|
|
SELECT COUNT(*) FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`active` = TRUE;
|
|
# Time: 190713 16:39:39
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014230 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 17393
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563028779;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-13 14:39:39.371732' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190713 17:45:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.002340 Lock_time: 0.000056 Rows_sent: 20 Rows_examined: 228
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563032702;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND ('2019-07-13 15:45:02.231480' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190713 18:01:49
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015411 Lock_time: 0.000108 Rows_sent: 2 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563033709;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.6800198) / 57.2957795), ((events.latitude - 48.1113387) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND (events.latitude BETWEEN 47.38767978444576 AND 48.83499761555424 AND events.longitude BETWEEN -2.7638522211778036 AND -0.5961873788221963 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-13 16:01:49.932952' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190713 18:31:57
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.109734 Lock_time: 0.000058 Rows_sent: 33 Rows_examined: 17394
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563035517;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-13 16:31:56.984778' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190713 19:59:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000091 Lock_time: 0.000030 Rows_sent: 5 Rows_examined: 6
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563040746;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`id` IN (1, 2, 3, 4, 6);
|
|
# Time: 190713 20:34:22
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.017076 Lock_time: 0.000065 Rows_sent: 242 Rows_examined: 17394
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563042862;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND ('2019-07-13 18:34:22.083443' <= end_time);
|
|
# Time: 190713 23:27:04
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.194894 Lock_time: 0.000048 Rows_sent: 25 Rows_examined: 42392
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563053224;
|
|
SELECT `versions`.* FROM `versions` ORDER BY `versions`.`created_at` DESC LIMIT 25 OFFSET 13125;
|
|
# Time: 190714 0:40:32
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001358 Lock_time: 0.000052 Rows_sent: 7 Rows_examined: 582
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563057632;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`region_id` = 13 AND `orgas`.`active` = TRUE ORDER BY `orgas`.`city` ASC LIMIT 25 OFFSET 25;
|
|
# Time: 190714 0:41:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3051 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.175874 Lock_time: 0.000021 Rows_sent: 25 Rows_examined: 29392
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563057666;
|
|
SELECT `versions`.* FROM `versions` ORDER BY `versions`.`whodunnit` ASC LIMIT 25 OFFSET 125;
|
|
# Time: 190714 2:43:28
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000355 Lock_time: 0.000061 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563065008;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-14 00:43:28.456018' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190714 3:53:54
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096988 Lock_time: 0.000065 Rows_sent: 0 Rows_examined: 17394
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563069234;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 5 AND ('2019-07-14 01:53:54.094657' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190714 5:15:47
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3050 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000336 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563074147;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-14 03:15:47.338679' <= end_time) ORDER BY id desc LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190714 6:45:52
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000077 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563079552;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('helpers.label.user.password') OR `key` LIKE 'helpers.label.user.password.%') LIMIT 1;
|
|
# Time: 190714 8:20:50
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.012200 Lock_time: 0.000059 Rows_sent: 0 Rows_examined: 17395
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563085250;
|
|
SELECT COUNT(*) AS count_all, extract(year from start_time) AS extract_year_from_start_time, extract(month from start_time) AS extract_month_from_start_time FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 91 GROUP BY extract(year from start_time), extract(month from start_time);
|
|
# Time: 190714 9:24:49
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000065 Lock_time: 0.000022 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563089089;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('orgas.form.tags_helper') OR `key` LIKE 'orgas.form.tags_helper.%') LIMIT 1;
|
|
# Time: 190714 11:18:37
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3637 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.021117 Lock_time: 0.000104 Rows_sent: 0 Rows_examined: 17395
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563095917;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-14 09:18:37.186840' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190714 13:59:10
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099271 Lock_time: 0.000051 Rows_sent: 34 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563105550;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-14 11:59:10.774695' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190714 14:41:30
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096066 Lock_time: 0.000054 Rows_sent: 0 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563108090;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 9 AND ('2019-07-14 12:41:30.610240' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190714 15:36:52
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014144 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563111412;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-14 13:36:52.169848' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190714 19:12:13
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3637 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000078 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563124333;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('events.form.save') OR `key` LIKE 'events.form.save.%') LIMIT 1;
|
|
# Time: 190714 19:44:57
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096171 Lock_time: 0.000056 Rows_sent: 0 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563126297;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 7 AND ('2019-07-14 17:44:57.078430' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190714 20:20:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098369 Lock_time: 0.000053 Rows_sent: 34 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563128435;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-14 18:20:35.779692' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190714 21:40:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000461 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563133231;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-14 19:40:31.547837' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190714 22:00:29
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000101 Lock_time: 0.000030 Rows_sent: 6 Rows_examined: 6
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563134429;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`id` IN (1, 2, 3, 4, 5, 6);
|
|
# Time: 190714 22:21:55
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014157 Lock_time: 0.000107 Rows_sent: 0 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563135715;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-14 20:21:55.197960' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190714 23:06:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014760 Lock_time: 0.000109 Rows_sent: 20 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563138404;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.5541362) / 57.2957795), ((events.latitude - 47.2186371) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND (events.latitude BETWEEN 46.567344076001184 AND 47.86993012399882 AND events.longitude BETWEEN -2.5130445176091003 AND -0.5952278823908996 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((47.2186371 - events.latitude) * PI() / 180 / 2), 2) + COS(47.2186371 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.5541362 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '45') AND ('2019-07-14 21:06:44.098347' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190714 23:54:39
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097713 Lock_time: 0.000052 Rows_sent: 34 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563141279;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-14 21:54:39.575646' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 0:00:01
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.310664 Lock_time: 0.000099 Rows_sent: 34 Rows_examined: 17396
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563141601;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-14 22:00:00.753876' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 1:12:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099598 Lock_time: 0.000051 Rows_sent: 34 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563145926;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-14 23:12:06.404772' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 1:57:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.013924 Lock_time: 0.000107 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563148676;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-14 23:57:56.177728' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 2:03:37
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000548 Lock_time: 0.000069 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563149017;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-15 00:03:37.139371' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190715 3:14:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.175633 Lock_time: 0.000054 Rows_sent: 5 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563153296;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-15 01:14:56.375807' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190715 4:06:01
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015810 Lock_time: 0.000111 Rows_sent: 1 Rows_examined: 17398
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563156361;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.6800198) / 57.2957795), ((events.latitude - 48.1113387) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND (events.latitude BETWEEN 47.38767978444576 AND 48.83499761555424 AND events.longitude BETWEEN -2.7638522211778036 AND -0.5961873788221963 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 02:06:01.701966' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 5:05:22
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 3638 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097330 Lock_time: 0.000051 Rows_sent: 34 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563159922;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-15 03:05:22.573046' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190715 7:53:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014345 Lock_time: 0.000114 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
use adl_fr;
|
|
SET timestamp=1563170005;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 05:53:25.196648' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 10:49:15
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097745 Lock_time: 0.000053 Rows_sent: 34 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563180555;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-15 08:49:15.483606' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 12:59:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014274 Lock_time: 0.000111 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563188381;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 10:59:41.267510' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 15:11:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097961 Lock_time: 0.000055 Rows_sent: 34 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563196272;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-15 13:11:12.730054' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 15:16:14
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014336 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563196574;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 13:16:14.903098' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 16:43:27
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000930 Lock_time: 0.000056 Rows_sent: 20 Rows_examined: 97
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563201807;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-15 14:43:27.687538' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190715 16:56:19
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4228 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000936 Lock_time: 0.000054 Rows_sent: 20 Rows_examined: 97
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563202579;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-15 14:56:19.943916' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190715 17:02:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.016268 Lock_time: 0.000056 Rows_sent: 245 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563202926;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND ('2019-07-15 15:02:06.600967' <= end_time);
|
|
# Time: 190715 17:23:26
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000926 Lock_time: 0.000054 Rows_sent: 20 Rows_examined: 97
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563204206;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-15 15:23:26.591403' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190715 19:19:21
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097036 Lock_time: 0.000056 Rows_sent: 42 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563211161;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 18 AND ('2019-07-15 17:19:21.757770' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190715 23:19:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014317 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563225571;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 21:19:31.223661' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190715 23:25:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4228 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.024463 Lock_time: 0.000105 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563225931;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 21:25:31.165777' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190716 1:37:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015003 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563233851;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-15 23:37:31.170020' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190716 3:36:23
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098225 Lock_time: 0.000054 Rows_sent: 33 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563240983;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 01:36:23.889521' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190716 4:21:16
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4227 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097226 Lock_time: 0.000057 Rows_sent: 5 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563243676;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-16 02:21:15.995632' <= end_time) ORDER BY id desc LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190716 7:07:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000068 Lock_time: 0.000022 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563253632;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('activerecord.attributes.orga.name') OR `key` LIKE 'activerecord.attributes.orga.name.%') LIMIT 1;
|
|
# Time: 190716 7:13:04
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.012920 Lock_time: 0.000056 Rows_sent: 0 Rows_examined: 17397
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563253984;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND `events`.`region_id` IN (97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113) AND ('2019-07-16 05:13:04.798261' <= end_time);
|
|
# Time: 190716 14:44:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001331 Lock_time: 0.000058 Rows_sent: 20 Rows_examined: 113
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563281042;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-16 12:44:02.938812' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190716 15:34:38
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014081 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563284078;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-16 13:34:38.435647' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190716 16:03:57
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.038576 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 1718
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563285837;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 14:03:57.697937' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190716 16:17:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001532 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 157
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563286661;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 17 AND ('2019-07-16 14:17:41.252272' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190716 17:51:20
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4814 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000065 Lock_time: 0.000019 Rows_sent: 1 Rows_examined: 6
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563292280;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`name` = 'thirdPlace' LIMIT 1;
|
|
# Time: 190716 19:16:16
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000662 Lock_time: 0.000068 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563297376;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-16 17:16:16.607377' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190716 21:00:30
|
|
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
|
|
# Thread_id: 5167 Schema: mysql QC_hit: No
|
|
# Query_time: 0.000057 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use mysql;
|
|
SET timestamp=1563303630;
|
|
SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'time_zone_transition';
|
|
# Time: 190716 21:02:43
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4814 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.103588 Lock_time: 0.000050 Rows_sent: 32 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563303763;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 19:02:43.309720' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190716 21:12:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.115482 Lock_time: 0.000053 Rows_sent: 32 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563304345;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 19:12:24.965564' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190716 21:45:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014615 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 1717
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563306318;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 19:45:18.400290' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 0:25:13
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097598 Lock_time: 0.000053 Rows_sent: 32 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563315913;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-16 22:25:13.695268' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 1:03:59
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.102913 Lock_time: 0.000055 Rows_sent: 3 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563318239;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 2 AND ('2019-07-16 23:03:59.542128' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 5:00:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4813 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000388 Lock_time: 0.000056 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563332402;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-17 03:00:02.720877' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 5:54:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4814 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000514 Lock_time: 0.000045 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563335681;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-17 03:54:41.101018' <= end_time) ORDER BY id desc LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190717 6:27:20
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5401 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000089 Lock_time: 0.000031 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563337640;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('ice_cube.each_month') OR `key` LIKE 'ice_cube.each_month.%') LIMIT 1;
|
|
# Time: 190717 11:29:28
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098301 Lock_time: 0.000052 Rows_sent: 32 Rows_examined: 17413
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563355768;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 09:29:27.912467' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 15:47:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014665 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 1718
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563371264;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 13:47:44.898439' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 16:27:30
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000438 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563373650;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-17 14:27:30.275118' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 16:28:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099394 Lock_time: 0.000056 Rows_sent: 32 Rows_examined: 17414
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563373736;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 14:28:56.069324' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 17:43:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097820 Lock_time: 0.000052 Rows_sent: 32 Rows_examined: 17414
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563378189;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 15:43:09.552602' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 17:50:34
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000517 Lock_time: 0.000067 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563378634;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-17 15:50:34.821460' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 19:05:55
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.098509 Lock_time: 0.000051 Rows_sent: 32 Rows_examined: 17414
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563383155;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 17:05:55.728519' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 19:07:15
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014341 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 1718
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563383235;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 17:07:15.038446' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190717 20:47:25
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097677 Lock_time: 0.000053 Rows_sent: 32 Rows_examined: 17414
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563389245;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 18:47:25.751695' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190717 23:21:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001079 Lock_time: 0.000027 Rows_sent: 19 Rows_examined: 551
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563398463;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`region_id` = 7;
|
|
# Time: 190718 1:54:22
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.132850 Lock_time: 0.000055 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563407662;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-17 23:54:22.480709' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 2:35:17
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097853 Lock_time: 0.000050 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563410117;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 00:35:17.357891' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 4:43:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5400 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015906 Lock_time: 0.000110 Rows_sent: 2 Rows_examined: 17417
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563417798;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.6800198) / 57.2957795), ((events.latitude - 48.1113387) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND (events.latitude BETWEEN 47.38767978444576 AND 48.83499761555424 AND events.longitude BETWEEN -2.7638522211778036 AND -0.5961873788221963 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-18 02:43:18.294644' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190718 8:15:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000383 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563430541;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-18 06:15:41.165282' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190718 8:30:04
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000374 Lock_time: 0.000051 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563431404;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-18 06:30:04.319038' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190718 8:32:31
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097458 Lock_time: 0.000052 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563431551;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 06:32:31.083901' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 8:41:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001056 Lock_time: 0.000019 Rows_sent: 22 Rows_examined: 551
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563432093;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`region_id` = 139;
|
|
# Time: 190718 8:49:22
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014469 Lock_time: 0.000111 Rows_sent: 0 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563432562;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-18 06:49:22.183607' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190718 8:57:24
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.104568 Lock_time: 0.000062 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563433044;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 06:57:24.736155' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 10:15:59
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5988 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000072 Lock_time: 0.000026 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563437759;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('stats.index.awaitingModeration') OR `key` LIKE 'stats.index.awaitingModeration.%') LIMIT 1;
|
|
# Time: 190718 11:30:27
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014479 Lock_time: 0.000064 Rows_sent: 20 Rows_examined: 1719
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563442227;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 09:30:27.220421' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190718 12:01:59
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5988 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.121002 Lock_time: 0.000053 Rows_sent: 6 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563444119;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-18 10:01:59.322962' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 15:56:38
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5988 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000417 Lock_time: 0.000049 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563458198;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-18 13:56:38.763632' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190718 16:20:48
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096013 Lock_time: 0.000055 Rows_sent: 6 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563459648;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-18 14:20:48.752858' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190718 16:30:54
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5988 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.195715 Lock_time: 0.000048 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563460254;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 14:30:54.382953' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 19:31:27
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096819 Lock_time: 0.000052 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563471087;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 17:31:26.988717' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190718 19:38:40
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097966 Lock_time: 0.000053 Rows_sent: 32 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563471520;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 17:38:40.396186' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 0:47:06
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.193851 Lock_time: 0.000052 Rows_sent: 30 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563490026;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-18 22:47:06.789490' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 2:03:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5988 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001164 Lock_time: 0.000049 Rows_sent: 20 Rows_examined: 115
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563494621;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-19 00:03:41.462817' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190719 5:05:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5987 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.023718 Lock_time: 0.000077 Rows_sent: 0 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563505533;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-19 03:05:33.178350' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190719 6:34:26
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097609 Lock_time: 0.000053 Rows_sent: 29 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563510866;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 04:34:26.319229' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 6:41:19
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000063 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563511279;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('ransack.attributes.active_record/base.updated_at') OR `key` LIKE 'ransack.attributes.active_record/base.updated_at.%') LIMIT 1;
|
|
# Time: 190719 7:17:11
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.226826 Lock_time: 0.000047 Rows_sent: 25 Rows_examined: 38590
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 1 Priority_queue: No
|
|
SET timestamp=1563513431;
|
|
SELECT `versions`.* FROM `versions` ORDER BY `versions`.`event` DESC LIMIT 25 OFFSET 9275;
|
|
# Time: 190719 8:24:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097403 Lock_time: 0.000052 Rows_sent: 29 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563517481;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 06:24:41.528012' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 8:36:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000377 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563518193;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-19 06:36:33.077386' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190719 10:08:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097430 Lock_time: 0.000055 Rows_sent: 2 Rows_examined: 17415
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563523736;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND ('2019-07-19 08:08:56.605055' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190719 13:20:37
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099984 Lock_time: 0.000070 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563535237;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 11:20:37.710142' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 13:47:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6575 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.190966 Lock_time: 0.000049 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563536855;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 11:47:35.329873' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 14:48:47
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.099597 Lock_time: 0.000052 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563540527;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 12:48:47.636370' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 15:31:24
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000419 Lock_time: 0.000054 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563543084;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-19 13:31:24.066319' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190719 15:52:48
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000454 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 20
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563544368;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-19 13:52:48.517718' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190719 16:01:32
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.026030 Lock_time: 0.000070 Rows_sent: 249 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563544892;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND ('2019-07-19 14:01:32.146706' <= end_time);
|
|
# Time: 190719 16:51:35
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014003 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563547895;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-19 14:51:35.176911' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190719 17:29:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.025922 Lock_time: 0.000052 Rows_sent: 65 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563550149;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND `events`.`region_id` = 3 AND ('2019-07-19 15:29:09.239214' <= end_time);
|
|
# Time: 190719 17:39:02
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.197182 Lock_time: 0.000053 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563550742;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 15:39:02.779126' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 17:52:26
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097277 Lock_time: 0.000052 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563551546;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 15:52:25.938877' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190719 20:53:41
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014048 Lock_time: 0.000109 Rows_sent: 0 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563562421;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-19 18:53:41.164511' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190719 21:25:43
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014292 Lock_time: 0.000110 Rows_sent: 0 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563564343;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-19 19:25:43.542642' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190719 21:42:55
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000064 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563565375;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'de' AND (`key` IN ('pages.filter.iframe_helper') OR `key` LIKE 'pages.filter.iframe_helper.%') LIMIT 1;
|
|
# Time: 190719 23:58:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7002 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000060 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563573483;
|
|
SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'taggings';
|
|
# Time: 190720 0:48:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6575 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.113087 Lock_time: 0.000050 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563576524;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 22:48:44.539597' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190720 1:51:21
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097067 Lock_time: 0.000051 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563580281;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-19 23:51:21.245923' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190720 1:51:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 6574 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000391 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563580316;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-19 23:51:56.476331' <= end_time) ORDER BY id desc LIMIT 20;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190720 6:26:05
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000068 Lock_time: 0.000023 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563596765;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('activerecord.attributes.event.url') OR `key` LIKE 'activerecord.attributes.event.url.%') LIMIT 1;
|
|
# Time: 190720 10:14:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.018383 Lock_time: 0.000056 Rows_sent: 247 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563610443;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND (latitude is not null and longitude is not null) AND ('2019-07-20 08:14:03.658215' <= end_time);
|
|
# Time: 190720 11:30:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000178 Lock_time: 0.000027 Rows_sent: 14 Rows_examined: 111
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563615056;
|
|
SELECT `regions`.* FROM `regions` WHERE `regions`.`id` IN (1, 17, 6, 3, 21, 18, 13, 139, 29, 12, 138, 27, 4, 2) ORDER BY `regions`.`name` ASC;
|
|
# Time: 190720 13:19:58
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.015632 Lock_time: 0.000115 Rows_sent: 0 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563621598;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 7.7507127) / 57.2957795), ((events.latitude - 48.584614) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 1 AND (events.latitude BETWEEN 47.86095508444576 AND 49.30827291555424 AND events.longitude BETWEEN 6.656768036355796 AND 8.844657363644204 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.584614 - events.latitude) * PI() / 180 / 2), 2) + COS(48.584614 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((7.7507127 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-20 11:19:58.194848' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190720 13:31:56
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7161 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001075 Lock_time: 0.000020 Rows_sent: 1 Rows_examined: 551
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563622316;
|
|
SELECT COUNT(*) FROM `orgas` WHERE `orgas`.`moderated` = TRUE AND `orgas`.`region_id` = 111 AND `orgas`.`active` = TRUE;
|
|
# Time: 190720 16:09:18
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014290 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 1722
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563631758;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-20 14:09:18.611868' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190720 16:38:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.016004 Lock_time: 0.000116 Rows_sent: 2 Rows_examined: 17418
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563633483;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - -1.6800198) / 57.2957795), ((events.latitude - 48.1113387) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND (events.latitude BETWEEN 47.38767978444576 AND 48.83499761555424 AND events.longitude BETWEEN -2.7638522211778036 AND -0.5961873788221963 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.1113387 - events.latitude) * PI() / 180 / 2), 2) + COS(48.1113387 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((-1.6800198 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '50') AND ('2019-07-20 14:38:03.778332' <= end_time) ORDER BY id desc, distance ASC LIMIT 20;
|
|
# Time: 190720 17:09:46
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097678 Lock_time: 0.000052 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563635386;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-20 15:09:45.984612' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190720 18:28:33
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001085 Lock_time: 0.000106 Rows_sent: 20 Rows_examined: 21
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563640113;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-20 16:28:33.315399' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190720 19:06:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096677 Lock_time: 0.000056 Rows_sent: 6 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563642369;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-20 17:06:09.216408' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190720 20:14:23
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001562 Lock_time: 0.000052 Rows_sent: 20 Rows_examined: 159
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563646463;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 17 AND ('2019-07-20 18:14:23.278448' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190720 20:19:44
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.019123 Lock_time: 0.000113 Rows_sent: 27 Rows_examined: 17443
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
SET timestamp=1563646784;
|
|
SELECT events.*, 3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.8566101 - events.latitude) * PI() / 180 / 2), 2) + COS(48.8566101 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((2.3514992 - events.longitude) * PI() / 180 / 2), 2))) AS distance, MOD(CAST((ATAN2( ((events.longitude - 2.3514992) / 57.2957795), ((events.latitude - 48.8566101) / 57.2957795)) * 57.2957795) + 360 AS decimal), 360) AS bearing FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND (events.latitude BETWEEN 48.784244208444576 AND 48.92897599155542 AND events.longitude BETWEEN 2.2415115696396835 AND 2.461486830360317 AND (3958.755864232 * 2 * ASIN(SQRT(POWER(SIN((48.8566101 - events.latitude) * PI() / 180 / 2), 2) + COS(48.8566101 * PI() / 180) * COS(events.latitude * PI() / 180) * POWER(SIN((2.3514992 - events.longitude) * PI() / 180 / 2), 2)))) BETWEEN 0.0 AND '5') AND ('2019-07-20 18:19:44.791539' <= end_time) ORDER BY id desc, distance ASC LIMIT 3000;
|
|
# Time: 190720 22:21:37
|
|
# User@Host: debian-sys-maint[debian-sys-maint] @ localhost []
|
|
# Thread_id: 7549 Schema: mysql QC_hit: No
|
|
# Query_time: 0.000088 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 1
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: Yes Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use mysql;
|
|
SET timestamp=1563654097;
|
|
SELECT engine FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'innodb_index_stats';
|
|
# Time: 190721 0:20:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.096195 Lock_time: 0.000029 Rows_sent: 17 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563661212;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 139 AND ('2019-07-20 22:20:12.238693' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190721 4:42:09
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000239 Lock_time: 0.000048 Rows_sent: 14 Rows_examined: 111
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563676929;
|
|
SELECT `regions`.* FROM `regions` WHERE `regions`.`id` IN (1, 17, 3, 21, 18, 13, 139, 6, 29, 12, 138, 27, 4, 2) ORDER BY `regions`.`name` ASC;
|
|
# Time: 190721 5:34:03
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7160 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.097353 Lock_time: 0.000052 Rows_sent: 29 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563680043;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-21 03:34:03.099491' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190721 6:27:22
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7749 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000065 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563683242;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('countries.Kärnten') OR `key` LIKE 'countries.Kärnten.%') LIMIT 1;
|
|
# Time: 190721 6:40:01
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7748 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000066 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563684001;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'en' AND (`key` IN ('events.form.submitter_helper') OR `key` LIKE 'events.form.submitter_helper.%') LIMIT 1;
|
|
# Time: 190721 7:14:45
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7748 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000435 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 22
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563686085;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND ('2019-07-21 05:14:45.864293' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190721 7:36:08
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7748 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.014942 Lock_time: 0.000057 Rows_sent: 20 Rows_examined: 1722
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563687368;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 12 AND ('2019-07-21 05:36:08.325570' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190721 9:00:43
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 7748 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000062 Lock_time: 0.000020 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563692443;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'de' AND (`key` IN ('countries.Grisons') OR `key` LIKE 'countries.Grisons.%') LIMIT 1;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190721 11:23:12
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 4 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000064 Lock_time: 0.000021 Rows_sent: 0 Rows_examined: 7
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
use adl_fr;
|
|
SET timestamp=1563700992;
|
|
SELECT 1 AS one FROM `translations` WHERE `translations`.`locale` = 'fr' AND (`key` IN ('countries.Uri') OR `key` LIKE 'countries.Uri.%') LIMIT 1;
|
|
/usr/sbin/mysqld, Version: 10.1.38-MariaDB-0+deb9u1 (Debian 9.8). started with:
|
|
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
|
|
Time Id Command Argument
|
|
# Time: 190721 12:05:43
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 3.280142 Lock_time: 0.000020 Rows_sent: 25 Rows_examined: 56343
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: Yes Filesort_on_disk: No Merge_passes: 0 Priority_queue: Yes
|
|
use adl_fr;
|
|
SET timestamp=1563703543;
|
|
SELECT `versions`.* FROM `versions` ORDER BY `versions`.`created_at` DESC LIMIT 25 OFFSET 27025;
|
|
# Time: 190721 14:13:49
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000168 Lock_time: 0.000046 Rows_sent: 1 Rows_examined: 6
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563711229;
|
|
SELECT `kinds`.* FROM `kinds` WHERE `kinds`.`name` = 'thirdPlace' LIMIT 1;
|
|
# Time: 190721 14:16:00
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.000891 Lock_time: 0.000018 Rows_sent: 1 Rows_examined: 551
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563711360;
|
|
SELECT `orgas`.* FROM `orgas` WHERE `orgas`.`region_id` = 34;
|
|
# Time: 190721 14:36:57
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.001054 Lock_time: 0.000053 Rows_sent: 20 Rows_examined: 116
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563712617;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 3 AND ('2019-07-21 12:36:57.784223' <= end_time) ORDER BY id desc LIMIT 20;
|
|
# Time: 190721 14:39:11
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.190141 Lock_time: 0.000048 Rows_sent: 44 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563712751;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 13 AND ('2019-07-21 12:39:11.278585' <= end_time) ORDER BY id desc LIMIT 3000;
|
|
# Time: 190721 15:37:28
|
|
# User@Host: adl_fr[adl_fr] @ localhost []
|
|
# Thread_id: 5 Schema: adl_fr QC_hit: No
|
|
# Query_time: 0.093325 Lock_time: 0.000054 Rows_sent: 4 Rows_examined: 17416
|
|
# Rows_affected: 0
|
|
# Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
|
|
# Filesort: No Filesort_on_disk: No Merge_passes: 0 Priority_queue: No
|
|
SET timestamp=1563716248;
|
|
SELECT `events`.* FROM `events` WHERE `events`.`moderated` = 1 AND `events`.`region_id` = 6 AND ('2019-07-21 13:37:28.033697' <= end_time) ORDER BY id desc LIMIT 20;
|