SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580081 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580081 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647643,209548,202155,967525,475144,302022,419262,708672,873788,997559,184124,499092,131367,366045,66345,831036,561531,116864,414588,315108,1043540,961416,979018,837872,883351,103516,651888,839098,717119,125531,297592,366750,17613,786283,465359,264359,117093,372905,540800,746663,12884,217994,322086,1010796,104058,14916,619834,486908,853021,437287,750624,715177,71025,212388,653606,176944,842369,250546,540516,225851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]