SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512943 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512943 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862556,159356,927653,365919,268966,663678,999322,103340,350826,560423,390390,882997,205160,102629,378583,481155,217229,911352,140350,261801,38787,768367,757035,869035,700116,684097,349623,641380,491412,886614,280221,62973,22568,777302,205631,149708,16381,245743,749222,26073,555295,343353,945625,816405,990421,163892,280855,776663,98276,917264,935767,505262,89954,795004,55275,460143,822452,36094,997102,957070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004182s ]