SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018668 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018668 [ RunTime:0.002534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711481,612568,850293,465295,930649,15904,596022,242569,40584,736145,95948,342778,434777,502186,208592,190828,433281,132941,399565,164311,698439,1036458,830370,650293,543551,849683,970442,213202,772055,971216,1036141,140410,809068,407342,333650,546583,288738,851655,337395,1017819,724261,57343,897772,1033578,714102,183786,1019190,907723,759092,621870,231798,223824,983366,475577,573293,72003,159707,362086,465055,918361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]