SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE users ( id BIGINT(20) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, created_at TIMESTAMP NULL DEFAULT NULL, KEY (created_at) ) ENGINE=InnoDB; INSERT INTO users (created_at) VALUES ('2024-01-02 07:49:03'), ('2024-01-06 16:12:10'), ('2024-01-07 21:25:28'), ('2024-01-14 11:54:59'), ('2024-01-15 08:09:49'), ('2024-01-21 09:42:58'), ('2024-01-24 07:13:56'), ('2024-01-27 16:13:01'), ('2024-01-28 01:16:54'), ('2024-02-01 08:50:57'), ('2024-02-03 11:24:18'), ('2024-02-04 05:03:59'), ('2024-02-12 22:55:40'), ('2024-02-23 17:08:20'), ('2024-03-01 20:41:27'), ('2024-03-05 13:16:16'), ('2024-03-08 00:40:24'), ('2024-03-12 03:06:05'), ('2024-03-16 13:50:13'), ('2024-03-21 13:53:34'), ('2024-03-24 18:29:22'), ('2024-03-25 23:17:43'), ('2024-03-26 04:17:55'), ('2024-03-26 08:04:40'), ('2024-04-04 02:29:50'), ('2024-04-06 22:22:41'), ('2024-04-07 15:47:47'), ('2024-04-17 12:36:51'), ('2024-04-22 06:19:30'), ('2024-04-25 04:34:24'), ('2024-04-25 19:45:31'), ('2024-04-28 21:02:45'), ('2024-04-30 06:06:38'), ('2024-05-02 15:31:07'), ('2024-05-04 18:38:08'), ('2024-05-17 11:43:51'), ('2024-05-24 21:18:41'), ('2024-05-25 22:09:48'), ('2024-05-26 20:36:59'), ('2024-05-27 18:18:38'), ('2024-06-05 14:16:17'), ('2024-06-06 05:18:54'), ('2024-06-09 19:09:03'), ('2024-06-20 08:52:11'), ('2024-06-22 23:45:33'), ('2024-06-26 21:45:29'), ('2024-07-01 18:34:26'), ('2024-07-03 05:33:46'), ('2024-07-05 23:46:28'), ('2024-07-08 12:38:08'), ('2024-07-08 14:07:30'), ('2024-07-09 23:22:12'), ('2024-07-11 06:13:10'), ('2024-07-11 12:56:23'), ('2024-07-16 23:58:22'), ('2024-07-17 07:06:40'), ('2024-07-18 00:37:09'), ('2024-07-20 22:59:25'), ('2024-07-20 23:29:36'), ('2024-07-24 22:11:09'), ('2024-07-26 09:21:57'), ('2024-07-27 10:32:53'), ('2024-07-30 13:51:17'), ('2024-08-02 17:49:54'), ('2024-08-03 19:00:59'), ('2024-08-04 21:27:07'), ('2024-08-06 10:50:05'), ('2024-08-15 05:59:12'), ('2024-08-16 23:19:28'), ('2024-08-24 03:17:21'), ('2024-09-01 14:47:05'), ('2024-09-09 16:44:13'), ('2024-09-12 15:28:17'), ('2024-09-17 15:32:18'), ('2024-09-28 19:41:55'), ('2024-10-05 19:37:05'), ('2024-10-06 16:04:03'), ('2024-10-08 04:04:56'), ('2024-10-11 00:23:38'), ('2024-10-16 08:07:00'), ('2024-10-24 04:49:58'), ('2024-10-28 12:53:40'), ('2024-11-05 15:41:05'), ('2024-11-08 23:04:18'), ('2024-11-11 01:52:06'), ('2024-11-16 22:05:16'), ('2024-11-17 20:41:23'), ('2024-11-18 01:13:00'), ('2024-11-22 03:06:51'), ('2024-11-22 18:10:56'), ('2024-11-25 01:45:02'), ('2024-11-26 15:17:46'), ('2024-11-27 02:31:43'), ('2024-11-28 14:25:31'), ('2024-12-02 12:11:10'), ('2024-12-04 07:00:35'), ('2024-12-12 11:19:03'), ('2024-12-22 03:19:23'), ('2024-12-22 14:42:04'), ('2024-12-23 14:21:49'); EXPLAIN SELECT COUNT(*) FROM users; EXPLAIN ANALYZE SELECT * FROM users ORDER BY id DESC LIMIT 10; EXPLAIN ANALYZE SELECT * FROM users ORDER BY created_at DESC LIMIT 10;