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` <> 64908 AND `Item`.`id` IN (45237, 45239, 45240, 45241, 45243, 45245, 45246, 45248, 45249, 45251, 45252, 45253, 45256, 45257, 45258, 45260, 45261, 45263, 45264, 45265, 45266, 45269, 45270, 45271, 45272, 45273, 45276, 45283, 45284, 45285, 45286, 45288, 45289, 45290, 45291, 45293, 45294, 45295, 45296, 45297, 45298, 45299, 45300, 45301, 45302, 45303, 45304, 45305, 45306, 45307, 45308, 45310, 45311, 45312, 45314, 45315, 45318, 45321, 45326, 45328, 45330, 45331, 45332, 45333, 45334, 45335, 45336, 45337, 45338, 45339, 45341, 45342, 45346, 45347, 45348, 45353, 45357, 45358, 45359, 45360, 45361, 45362, 45363, 45364, 45365, 45366, 45367, 45368, 45369, 45370, 45371, 45372, 45373, 45374, 45375, 45376, 45377, 45378, 45379, 45380, 45381, 45382, 45383, 45384, 45385, 45386, 45387, 45388, 45389, 45390, 45391, 45392, 45393, 45394, 45395, 45396, 45397, 45398, 45399, 45400, 45401, 45402, 45403, 45404, 45405, 45406, 45407, 45408, 45409, 45411, 45412, 45413, 45414, 45415, 45416, 45417, 45418, 45419, 45420, 45421, 45422, 45423, 45427, 45428, 45429, 45430, 45431, 45432, 45433, 45434, 45435, 45436, 45437, 45438, 45439, 45440, 45441, 45442, 45443, 45444, 45445, 45446, 45447, 45448, 45449, 45450, 45451, 45452, 45453, 45454, 45455, 45456, 45457, 45458, 45459, 45460, 45461, 45462, 45463, 45464, 45465, 45466, 45467, 45468, 45469, 45470, 45471, 45472, 45473, 45474, 45475, 45476, 45355, 45340, 45244, 45242, 45262, 45351, 45238, 45259, 45275, 45255, 45274, 45343, 45345, 45344, 45268, 45320, 45319, 45327, 45325, 45324, 45313, 45323, 45322, 45309, 45410, 45200, 45483, 45482, 45354, 45481, 45352, 45480, 45479, 45350, 45478, 45477, 45349, 45356, 45316, 45317, 45426, 45425, 45424, 45209, 45224, 45201, 45232, 45190, 45228, 45192, 45216, 45193, 45231, 45218, 45210, 45196, 45182, 45213, 45198, 45183, 45197, 45180, 45227, 45212, 45221, 45204, 45185, 45236, 45203, 45181, 45220, 45202, 45207, 45184, 45226, 45206, 45217, 45188, 45215, 45187, 45235, 45222, 45186, 45219, 45214, 45211, 45233, 45189, 45230, 45229, 45225, 45191, 45234, 45223, 45194, 45208, 45205, 45199, 45195, 45292, 45250, 45281, 45279, 45287, 45267, 45329, 45247, 45278, 45277, 45254, 45282, 45280, 64793, 64794, 64795, 64796, 64797, 64798, 64799, 64800, 64801, 64802, 64803, 64804, 64805, 64806, 64807, 64808, 64809, 64810, 64811, 64812, 64813, 64814, 64815, 64816, 64817, 64818, 64819, 64822, 64823, 64824, 64825, 64826, 64827, 64828, 64829, 64830, 64831, 64832, 64833, 64834, 64835, 64836, 64837, 64838, 64839, 64840, 64841, 64842, 64843, 64844, 64845, 64846, 64847, 64848, 64849, 64850, 64851, 64852, 64853, 64854, 64855, 64856, 64857, 64858, 64859, 64860, 64861, 64862, 64863, 64864, 64865, 64866, 64867, 64868, 64871, 64872, 64873, 64874, 64875, 64876, 64877, 64878, 64882, 64883, 64884, 64885, 64886, 64887, 64888, 64889, 64890, 64891, 64892, 64894, 64895, 64896, 64897, 64898, 64900, 64901, 64902, 64903, 64905, 64907, 64908, 64909, 64911, 64912, 64913, 64915, 64916, 64917, 64918, 64919, 64920, 64921, 64922, 64923, 64924, 64926, 64927, 64928, 64929, 64930, 64931, 64932, 64933, 64935, 64936, 64937, 64938, 64939, 64940, 64941, 64942, 64943, 64944, 64945, 64946, 64947, 64948, 64949, 64950, 64951, 64952, 64953, 64954, 64955, 64956, 64957, 64958, 64959, 64960, 64961, 64962, 64963, 64964, 64965, 64966, 64967, 64968, 64969, 64970, 64971, 64972, 64973, 64974, 64975, 64976, 64977, 64978, 64979, 64980, 64981, 64982, 64983, 64984, 64985, 64986, 64899, 64821, 64906, 64869, 64910, 64879, 64904, 64893, 64880, 64820, 64881, 64934, 64870, 64914, 64925) AND `Item`.`item_rank` IN (1, 2) AND `item_rank` <> 3 ORDER BY rand() ASC LIMIT 8 | 0 | 0 | 2 | maybe slow |