SELECT `Item`.`id`, `Item`.`item_code`, `Item`.`item_name`, `Item`.`item_price`, `Item`.`item_stock_wholesale_price`, `Item`.`item_color`, `Item`.`file1_name`, `Item`.`item_naming`, `Item`.`item_fullcolor`, `Item`.`item_speed`, `Item`.`item_rank`, `Campaign`.`id`, `Campaign`.`campaign_price` FROM `witinc_pqnavi_test`.`md_items` AS `Item` LEFT JOIN `witinc_pqnavi_test`.`md_campaigns` AS `Campaign` ON (`Campaign`.`item_id` = `Item`.`id`) WHERE `Item`.`id` <> 58510 AND `Item`.`id` IN (58429, 58431, 58432, 58433, 58434, 58435, 58436, 58437, 58439, 58440, 58441, 58442, 58444, 58445, 58446, 58447, 58448, 58449, 58450, 58451, 58452, 58453, 58454, 58455, 58456, 58457, 58458, 58459, 58460, 58461, 58466, 58468, 58469, 58470, 58471, 58472, 58473, 58474, 58475, 58476, 58477, 58478, 58480, 58481, 58482, 58483, 58484, 58485, 58486, 58487, 58489, 58490, 58492, 58493, 58494, 58495, 58496, 58497, 58498, 58501, 58502, 58503, 58505, 58506, 58507, 58511, 58512, 58513, 58514, 58515, 58516, 58517, 58518, 58519, 58520, 58521, 58522, 58523, 58524, 58525, 58526, 58527, 58528, 58529, 58530, 58531, 58532, 58533, 58534, 58535, 58536, 58537, 58538, 58539, 58540, 58541, 58542, 58543, 58544, 58545, 58546, 58547, 58548, 58549, 58550, 58551, 58552, 58553, 58554, 58555, 58557, 58558, 58559, 58560, 58561, 58562, 58563, 58564, 58565, 58566, 58567, 58568, 58569, 58570, 58571, 58572, 58573, 58574, 58575, 58576, 58577, 58578, 58579, 58580, 58581, 58582, 58583, 58584, 58585, 58586, 58587, 58588, 58589, 58590, 58591, 58593, 58594, 58595, 58596, 58597, 58598, 58599, 58600, 58601, 58602, 58603, 58604, 58605, 58606, 58607, 58608, 58609, 58610, 58611, 58612, 58613, 58614, 58615, 58616, 58617, 58618, 58619, 58620, 58621, 58622, 58623, 58624, 58625, 58626, 58627, 58628, 58629, 58630, 58631, 58509, 58500, 57389, 56219, 55026, 58510, 58430, 58464, 58479, 58463, 58462, 58438, 58499, 58504, 58508, 58488, 58465, 58491, 58427, 58394, 58413, 58387, 58389, 58390, 58391, 58392, 58401, 58428, 58376, 58415, 58403, 58375, 58409, 58412, 58411, 58410, 58388, 58408, 58407, 58386, 58406, 58426, 58385, 58405, 58425, 58384, 58404, 58424, 58383, 58423, 58382, 58402, 58422, 58381, 58421, 58380, 58400, 58420, 58379, 58399, 58419, 58378, 58398, 58418, 58377, 58397, 58417, 58396, 58416, 58395, 58374, 58414, 58373, 58393, 58443, 58467, 58556, 58592) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 0 | 0 | 1 | maybe slow |