SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201480 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201480 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116619,748366,330905,997376,760645,868324,680541,778354,931887,800870,490924,309395,655843,850191,331378,439179,716265,495251,852826,212629,985290,825419,987217,360017,1010493,851965,618270,793168,71054,939071,928372,105702,854770,467152,823883,465183,978110,844280,191790,125379,1006868,287112,909929,840259,204845,982637,120009,800179,149079,208633,627187,838193,861124,901587,205011,40468,807765,936837,821258,742132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201480 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201480 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]