SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 800020 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 800020 [ RunTime:0.003500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152257,929476,985701,283098,153328,251462,144768,352458,194660,162883,646411,370584,502145,651648,753838,140858,533847,223185,863237,694161,259470,335660,286852,77088,569940,975546,1045795,859321,881595,211303,23705,577484,297508,738234,560884,438579,668412,728897,26534,113494,1034398,1003625,181014,580330,342770,415788,843315,449906,1015960,978207,980781,429861,990109,28154,544763,1045056,413803,149882,921475,689163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 800020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 800020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]