SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 625545 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 625545 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (622241,847827,741387,790070,202559,456309,396023,767500,354530,42870,370587,104028,935171,750541,514651,837857,821738,67270,57765,57430,272053,253957,708753,133664,310382,778594,706353,532963,5750,873558,219267,519719,184579,136170,130066,390006,31940,976988,310543,147979,261116,153430,551196,961386,13890,143341,177069,512260,918294,501013,867177,506698,1042412,554229,285527,176782,109328,909365,386343,25403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 625545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 625545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]