SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541891 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541891 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141789,72468,324091,339583,626096,69946,184786,309238,415846,233470,925704,1005287,414845,810200,595502,828044,98909,569143,191975,422469,491454,810726,95046,193908,310689,546658,846223,437241,385216,698735,109700,175021,80787,1033369,364610,966823,698721,388464,500319,469755,635557,582979,625712,835747,131433,456510,836100,235141,39498,883882,528283,200298,594975,734359,571436,761841,577149,40760,467138,289872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]