SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468041 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468041 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338928,989262,72781,775867,946952,162409,956362,344194,501859,724447,907922,371677,861650,493770,442189,985586,884192,890887,150437,588790,729854,320060,5166,997072,379822,614450,413879,556927,857985,486907,881570,760117,268497,29334,480722,746870,524975,296695,142077,456885,601949,894151,566905,894989,1027153,57012,553006,668083,113202,317363,1020856,770790,993241,24744,617413,486975,493182,429075,100350,183823) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]