SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497043 LIMIT 1 [ RunTime:0.000541s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497043 [ RunTime:0.003177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706870,495538,951348,70444,927263,150423,777225,850137,256936,75153,711,930621,417913,71384,708809,76021,604497,171504,823391,297908,140096,96728,473323,1024273,919961,777790,53771,296302,204694,688983,544929,531986,1013065,618330,88591,133332,721890,892669,1033695,234255,478058,103956,479895,46692,458500,752531,609052,322806,92806,465043,569213,162063,380024,766461,768588,473326,20136,53560,187005,69908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]