/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;