SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457610 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457610 [ RunTime:0.003102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318270,490244,752791,948427,723940,192,869431,1048076,585320,422392,1024202,734406,141113,470334,271529,775880,910595,688731,278356,314617,113147,148099,515475,1016583,803412,833575,39964,683817,982352,249620,876988,674841,459187,371397,165136,132897,277088,340377,825143,451623,514162,93542,1006746,874534,249294,397968,117192,50943,129240,790122,694737,992964,952406,539909,566259,782297,897374,261184,925306,384601) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]