SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54818 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54818 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515738,787516,134472,291102,453262,259145,101887,931743,356404,171121,330735,706562,921538,2649,447277,125831,133586,730622,1011766,869357,319922,958380,525869,455737,66180,193454,104686,377301,490611,441650,572326,366178,485475,97437,302298,648570,613911,397172,242887,438648,643318,981297,177327,138253,43143,836228,555407,326590,796211,977925,579343,818054,749396,882786,378904,377042,472483,861819,867358,628435) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]