SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266040 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266040 [ RunTime:0.003094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248587,35139,656059,941753,791311,951248,446180,53307,193952,828769,365664,303099,185639,522000,154801,527895,970358,194240,262890,849693,735921,70666,485878,748832,1020436,611081,64640,1046469,695129,550971,5901,677468,533654,113244,1005202,328920,838313,1001294,2213,892342,610761,511796,556334,11178,1015052,357865,1018130,630125,530266,535292,698752,349697,412475,199796,151300,420839,17113,857506,873092,61129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]