SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311384 LIMIT 1 [ RunTime:0.001243s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311384 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (125161,450617,935345,42718,351472,474691,391466,372761,114511,616185,165659,856610,639192,1010048,331323,1017224,346532,984040,533224,658481,803340,159737,618912,919041,505040,981531,695085,407075,44430,462335,549357,221138,789116,327390,840487,907902,957339,749621,414820,71552,443535,122009,906003,858904,722490,615714,155722,737645,633973,342708,47363,618955,756651,349332,319628,287136,868630,290976,190595,227582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001480s ]