SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 17623 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 17623 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502109,552507,445454,694071,370806,629199,341204,749013,917164,601514,984540,278444,1015228,570098,728210,45351,500489,761970,386548,512467,918981,325421,87062,711790,439683,396951,678515,442594,223099,877752,1002824,11120,311411,210867,291764,1012939,183084,654216,771467,292511,689529,918574,867670,464863,570394,719497,738015,238574,969010,55078,346269,437626,540145,641588,283047,278767,246883,246357,336298,253574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 17623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 17623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]