CREATE TABLE `ps_hands` (
  `id` bigint(14) NOT NULL DEFAULT '0',
  `roomId` tinyint(1) NOT NULL DEFAULT '0',
  `currency` varchar(1) NOT NULL,
  `handLimit` float(8,2) NOT NULL DEFAULT '0.00',
  `date` date NOT NULL,
  `maxPlayers` int(1) NOT NULL,
  `text` text,
  `p1` mediumint(7) NOT NULL DEFAULT '0',
  `p2` mediumint(7) NOT NULL DEFAULT '0',
  `p3` mediumint(7) NOT NULL DEFAULT '0',
  `p4` mediumint(7) NOT NULL DEFAULT '0',
  `p5` mediumint(7) NOT NULL DEFAULT '0',
  `p6` mediumint(7) NOT NULL DEFAULT '0',
  `p7` mediumint(7) NOT NULL DEFAULT '0',
  `p8` mediumint(7) NOT NULL DEFAULT '0',
  `p9` mediumint(7) NOT NULL DEFAULT '0',
  `pp1` float(8,2) NOT NULL,
  `pp2` float(8,2) NOT NULL,
  `pp3` float(8,2) NOT NULL,
  `pp4` float(8,2) NOT NULL,
  `pp5` float(8,2) NOT NULL,
  `pp6` float(8,2) NOT NULL,
  `pp7` float(8,2) NOT NULL,
  `pp8` float(8,2) NOT NULL,
  `pp9` float(8,2) NOT NULL,
  `psd1` tinyint(1) NOT NULL,
  `psd2` tinyint(1) NOT NULL,
  `psd3` tinyint(1) NOT NULL,
  `psd4` tinyint(1) NOT NULL,
  `psd5` tinyint(1) NOT NULL,
  `psd6` tinyint(1) NOT NULL,
  `psd7` tinyint(1) NOT NULL,
  `psd8` tinyint(1) NOT NULL,
  `psd9` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `maxPlayers` (`maxPlayers`),
  KEY `currency` (`currency`) USING BTREE,
  KEY `p1_handLimit` (`p1`,`handLimit`),
  KEY `p2_handLimit` (`p2`,`handLimit`),
  KEY `p3_handLimit` (`p3`,`handLimit`),
  KEY `p4_handLimit` (`p4`,`handLimit`),
  KEY `p5_handLimit` (`p5`,`handLimit`),
  KEY `p6_handLimit` (`p6`,`handLimit`),
  KEY `p7_handLimit` (`p7`,`handLimit`),
  KEY `p8_handLimit` (`p8`,`handLimit`),
  KEY `p9_handLimit` (`p9`,`handLimit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT

SELECT `id`, `currency`, `pp1` AS `profit`, `psd1` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p1` = '9121'

Query_time: 11.908202  Lock_time: 0.000158 Rows_sent: 1051346  Rows_examined: 2102692
SET timestamp=1538167584;
SELECT `id`, `currency`, `pp1` AS `profit`, `psd1` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p1` = '96317' OR `p2` = '96317' OR `p3` = '96317' OR `p4` = '96317' OR `p5` = '96317' OR `p6` = '96317' OR `p7` = '96317' OR `p8` = '96317' OR `p9` = '96317' ORDER BY `id` ASC;

# Query_time: 6.640310  Lock_time: 0.000237 Rows_sent: 1051346  Rows_examined: 1051346
SET timestamp=1538167823;
SELECT `id`, `currency`, `pp1` AS `profit`, `psd1` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p1` = '96317' OR `p2` = '96317' OR `p3` = '96317' OR `p4` = '96317' OR `p5` = '96317' OR `p6` = '96317' OR `p7` = '96317' OR `p8` = '96317' OR `p9` = '96317';

# Query_time: 6.900837  Lock_time: 0.000485 Rows_sent: 1051346  Rows_examined: 3154038
SET timestamp=1538167901;
SELECT `id`, `currency`, `pp1` AS `profit`, `psd1` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p1` = '96317'
UNION ALL (SELECT `id`, `currency`, `pp2` AS `profit`, `psd2` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p2` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp3` AS `profit`, `psd3` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p3` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp4` AS `profit`, `psd4` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p4` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp5` AS `profit`, `psd5` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p5` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp6` AS `profit`, `psd6` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p6` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp7` AS `profit`, `psd7` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p7` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp8` AS `profit`, `psd8` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p8` = '96317') 
UNION ALL (SELECT `id`, `currency`, `pp9` AS `profit`, `psd9` AS `isSD`, `handLimit` FROM `ps_hands` WHERE `p9` = '96317') 
ORDER BY `id` ASC;