SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508902 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508902 [ RunTime:0.002322s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617562,293084,449760,189980,313657,890777,395413,978912,317089,926693,1022164,736437,721314,248014,1012678,86198,922970,531808,268166,634220,232830,413786,52005,83938,413027,713227,985322,653002,601285,655584,43957,695810,27457,668657,538178,701216,60683,753837,369277,184217,381007,548527,1009963,451414,203620,89493,1024305,435388,1012707,387229,612941,567480,590370,766885,529037,122456,604247,532326,152106,613001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]