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` = 291013 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291013 [ RunTime:0.004341s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138978,285482,587159,470961,70263,599936,914265,225979,614393,501278,575115,168046,696253,291237,113272,107081,569051,84720,192914,690627,996175,903179,74594,943188,451858,644275,365337,214243,44736,327270,165750,624171,941505,69036,986826,761857,628030,1003323,321950,738691,135231,3859,34414,158026,416974,193269,601485,680896,726597,527257,441358,904027,348763,907700,422194,402470,946352,685294,930454,173598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]