SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480930 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480930 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704231,217733,763236,1613,967019,46572,115596,173855,419317,918964,682649,112995,290080,685894,728886,693450,937955,287367,820857,87955,145581,358153,770911,852864,976902,417588,823950,873502,617405,438668,187562,720979,594549,739897,455247,369781,960456,372279,917688,1013885,1003296,944649,514392,73774,814074,586981,56311,46217,966983,918083,71209,633564,898977,648627,789457,970895,383958,374630,1047988,451144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000703s ]