SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281100 LIMIT 1 [ RunTime:0.000872s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281100 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310934,844731,266336,496787,506999,631686,720330,718418,348557,844288,391741,971360,267969,256415,368262,76035,4748,515166,285686,8477,878496,952351,253690,824093,547614,14263,394341,309685,1043943,607453,978203,389063,680766,850492,211250,198086,170079,237824,380456,365749,521522,996015,146033,371627,653737,115368,895507,996334,18670,850641,564560,1020229,636520,980302,29167,116827,957470,336824,569131,825503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001609s ]