SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506801 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506801 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498229,948356,13654,203521,63669,707221,523464,387887,132745,470252,688395,366374,698757,711319,937416,965752,268927,526349,821289,401297,401076,644981,199135,557638,57946,51885,403496,77599,135236,757446,244283,955924,780889,818973,351549,399082,881636,601379,631149,635534,648614,820086,873948,933288,79082,607595,951512,486777,953204,260320,442846,51394,10931,285021,333284,713101,306135,180225,499422,990045) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]