SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002875 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002875 [ RunTime:0.002029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410033,435115,454052,986568,432755,890730,583508,560754,250669,397754,354427,630362,668032,346480,244669,982484,276160,694063,706831,1023177,336388,318705,905846,57902,392156,600494,855414,395081,282157,621514,41139,355740,172833,556266,115358,463570,478024,14446,680924,169290,398408,847469,98814,181128,776072,349610,363535,589870,237874,167205,400520,491314,676887,527674,417514,95330,127585,854616,783203,5703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]