Hello, is there anything you can do to help me squash these SLOW log entries?
Code:
# Time: 140114 18:57:14
# User@Host: W101CDB[W101CDB] @ [x.x.x.x]
# Thread_id: 3741 Schema: wizard QC_hit: No
# Query_time: 13.801944 Lock_time: 0.000050 Rows_sent: 0 Rows_examined: 751190
use wizard;
SET timestamp=1389743834;
SELECT * FROM credits_pending WHERE checkstamp <= 1389743819 AND userid = 136471 ORDER BY checkstamp ASC LIMIT 1;
# Time: 140114 18:57:16
# User@Host: W101CDB[W101CDB] @ [x.x.x.x]
# Thread_id: 3753 Schema: wizard QC_hit: No
# Query_time: 13.718970 Lock_time: 0.000064 Rows_sent: 1 Rows_examined: 695240
SET timestamp=1389743836;
SELECT * FROM credits_pending WHERE checkstamp <= 1389743822 AND userid = 136100 ORDER BY checkstamp ASC LIMIT 1;