SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546984 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546984 [ RunTime:0.001389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522797,1030328,436870,739005,916155,189220,129360,164981,671850,601994,232076,122520,671297,919207,615933,127294,408521,836964,494013,873436,226709,35012,383892,55921,596934,860272,217549,110153,110223,866085,762610,104222,455591,579301,932803,90488,865795,611397,449093,948266,742967,454100,191614,994732,434752,297200,249173,915853,1035417,504263,140424,611102,883283,715286,694233,475580,435012,556600,938719,601307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]