SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68597 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68597 [ RunTime:0.001933s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320104,787228,445494,870652,44365,39529,387237,898828,958154,1040440,471561,1023668,512602,970988,503268,385277,917552,1044422,187379,1014230,8308,575725,482109,230422,693607,195961,745125,147108,550185,435410,410614,16055,799623,709029,580664,264531,224849,213177,516086,181550,619976,891561,855412,699288,42440,697948,384111,860876,782650,851021,51939,618981,668008,427902,259471,814307,792090,121761,364451,970325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]