SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317084 LIMIT 1 [ RunTime:0.000715s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317084 [ RunTime:0.002172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925160,337609,232440,812140,607757,783188,704949,187898,191119,136776,177821,319378,299772,777611,100307,444809,116254,338715,517190,497387,395060,439850,664504,208086,495108,43888,569565,992312,536885,718699,705200,801169,451540,275402,1015452,642880,561227,895674,546027,338159,770151,810880,700635,876612,482933,796962,1028674,978621,10227,302864,247909,345411,381953,396823,746186,744018,367208,530206,287127,636376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]