SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022816 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022816 [ RunTime:0.003176s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269655,82258,466737,29600,38595,510376,716683,287448,310750,597200,682746,101404,951484,607536,200955,493151,529179,185313,329776,440712,356006,110863,935721,211670,175688,674343,963636,520204,72121,240041,28470,1022092,200489,623786,833722,932819,988992,494076,578096,894239,367859,218332,697827,649859,785377,456301,904591,193002,329212,7646,420309,485634,187752,398895,628917,274308,360592,40125,406699,599659) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]