see an example, i replaced inappropriate valued insert to ? and put ? in quotes.
MariaDB [vrtb]> EXPLAIN SELECT /*nibble boundary 0*/ `day`,`playerid`,`subid`,`vastid`,`domain`,`requests`,`impressions`,`imptime`,`completed`,`errors`,`rev`,`loadreqs`,`loaded`,`actualrequests`,`firstquarter`,`midpoint`,`thirdquarter`,`click`,`viewable`,`mouse_event`,`custom1`,`custom2` FROM `vrtb`.`playerVastsStatsByDomain` FORCE INDEX (`PRIMARY`) WHERE (((`day` > '20170507') OR (`day` = '20170507' AND `playerid` > '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` > 'http://anything2mp3.com/batch?op=start&id=250351607') OR (`day` = '547781985' AND `playerid` = 'http://anything2mp3.com/batch?op=start&id=250351607' AND `subid` = '20170507' AND `vastid` > '547781985') OR (`day` = 'http://anything2mp3.com/batch?op=start&id=250351607' AND `playerid` = '$$custom_param_esc(pageurl)$$' AND `subid` = '?' AND `vastid` = '?' AND `domain` >= '?')) AND ((`day` < '20170507') OR (`day` = '20170507' AND `playerid` < '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` < 'http://anything2mp3.com/batch?op=start&id=250360017') OR (`day` = '547781985' AND `playerid` = 'http://anything2mp3.com/batch?op=start&id=250360017' AND `subid` = '20170507' AND `vastid` < '547781985') OR (`day` = 'http://anything2mp3.com/batch?op=start&id=250360017' AND `playerid` = '$$custom_param_esc(pageurl)$$' AND `subid` = '?' AND `vastid` = '?' AND `domain` <= '?'))) ORDER BY `day`,`playerid`,`subid`,`vastid`,`domain` LIMIT 99999, 1;
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+
| 1 | SIMPLE | playerVastsStatsByDomain | range | PRIMARY | PRIMARY | 270 | NULL | 17393 | Using where |
+------+-------------+--------------------------+-------+---------------+---------+---------+------+-------+-------------+
it looks like symbols ? cause to mess things ...
see an example, i replaced inappropriate valued insert to ? and put ? in quotes.
MariaDB [vrtb]> EXPLAIN SELECT /*nibble boundary 0*/ `day`,` playerid` ,`subid` ,`vastid` ,`domain` ,`requests` ,`impressions` ,`imptime` ,`completed` ,`errors` ,`rev`, `loadreqs` ,`loaded` ,`actualrequest s`,`firstquarte r`,`midpoint` ,`thirdquarter` ,`click` ,`viewable` ,`mouse_ event`, `custom1` ,`custom2` FROM `vrtb`. `playerVastsSta tsByDomain` FORCE INDEX (`PRIMARY`) WHERE (((`day` > '20170507') OR (`day` = '20170507' AND `playerid` > '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` > 'http:// anything2mp3. com/batch? op=start& id=250351607') OR (`day` = '547781985' AND `playerid` = 'http:// anything2mp3. com/batch? op=start& id=250351607' AND `subid` = '20170507' AND `vastid` > '547781985') OR (`day` = 'http:// anything2mp3. com/batch? op=start& id=250351607' AND `playerid` = '$$custom_ param_esc( pageurl) $$' AND `subid` = '?' AND `vastid` = '?' AND `domain` >= '?')) AND ((`day` < '20170507') OR (`day` = '20170507' AND `playerid` < '547781985') OR (`day` = '20170507' AND `playerid` = '547781985' AND `subid` < 'http:// anything2mp3. com/batch? op=start& id=250360017') OR (`day` = '547781985' AND `playerid` = 'http:// anything2mp3. com/batch? op=start& id=250360017' AND `subid` = '20170507' AND `vastid` < '547781985') OR (`day` = 'http:// anything2mp3. com/batch? op=start& id=250360017' AND `playerid` = '$$custom_ param_esc( pageurl) $$' AND `subid` = '?' AND `vastid` = '?' AND `domain` <= '?'))) ORDER BY `day`,` playerid` ,`subid` ,`vastid` ,`domain` LIMIT 99999, 1; +------ ------- +------ ------- ------- ------+ ------- +------ ------- --+---- -----+- ------- -+----- -+----- --+---- ------- --+ +------ ------- +------ ------- ------- ------+ ------- +------ ------- --+---- -----+- ------- -+----- -+----- --+---- ------- --+ sByDomain | range | PRIMARY | PRIMARY | 270 | NULL | 17393 | Using where | +------ ------- +------ ------- ------- ------+ ------- +------ ------- --+---- -----+- ------- -+----- -+----- --+---- ------- --+
+------
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------
| 1 | SIMPLE | playerVastsStat
+------