SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504247 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504247 [ RunTime:0.002566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810449,805359,93351,307814,31927,33261,902804,463883,201976,136080,599901,45094,953707,309207,627846,950855,285990,865346,69711,688025,396591,461244,419138,982616,792761,991562,975168,6214,106047,413100,272634,260763,914315,834558,805439,873082,444916,306214,286302,986048,297887,828333,342431,788544,231433,47275,1019863,709154,107175,780833,983047,777961,1017237,827144,476373,482972,464522,403175,722219,599696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000791s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002450s ]