SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531995 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531995 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229482,562667,424417,742640,1023560,887756,232379,315857,30769,852353,1003071,643683,975881,76271,318311,698675,518905,734863,900902,738654,306582,456772,483530,393989,339237,756466,126431,983629,256014,611664,982795,965357,21026,55080,625902,688422,307489,920744,981056,676970,582454,441420,305396,678746,848355,196686,15070,171690,855486,130816,184224,142309,384367,171346,837467,728621,791757,208759,339696,472463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531995 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531995 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001871s ]