rendered paste body
I am wondering if my indexes are doing anything for me.
+---------+---------------------+-----------+--------------------------------+-----------+
| data_id | dtstamp | listeners | song | stream_id |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| data | 0 | PRIMARY | 1 | data_id | A | 2127190 | NULL | NULL | | BTREE | |
| data | 1 | fk_data | 1 | stream_id | A | 1488 | NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
Example Query:
SELECT date(dtstamp) as date, TIME_FORMAT(dtstamp, '%l:%i%p') AS time, listeners, song from data WHERE stream_id=? and date(dtstamp)=?