Re: Query Takes Longer Each Time Its Run

[Rick James]

lease provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
and surround them with [ code ] and [ / code ]

I hope you did not have this on your 16GB machine:
innodb_buffer_pool_size = 16G

The rest of the VARIABLES are the same?
Especially
sync_binlog
innodb_flush_log_at_trx_commit = 0
innodb_flush_method = O_DIRECT

When you have LIMIT, the value in "Filtered" goes wonky. Seems to be 100 * (# rows in table) / (limit value). Do you have 15M rows in profile_thumbs_name?

I have another thought, but I need to know which engine you are using and the table sizes.