SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562153 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562153 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987927,1035646,749749,884218,221192,922548,933737,675401,268320,971811,245202,155250,197715,643384,842474,840772,950152,597439,349160,439259,928733,233671,660985,356557,695981,244496,333661,178814,630968,63618,354743,350383,227403,757776,668070,1032433,919772,491190,127477,956166,704373,160566,734549,234089,688674,275479,762010,556681,1004795,456936,528040,495583,120059,739505,740457,714058,778148,162204,102340,974082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]