SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40601 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40601 [ RunTime:0.006755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239616,58911,319365,595152,274420,630414,413343,932285,764784,476296,287831,211353,29261,1039807,579781,656209,656786,75115,786641,58149,769031,974660,446950,839658,508332,960469,720101,494774,379337,516133,661332,9781,636651,885828,765129,843798,931940,752403,455812,272293,599628,623220,164474,926036,203520,932445,91361,1036268,532847,425963,458202,613434,105847,225087,103258,171572,427003,437847,474237,40718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000709s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]