SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 448862 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 448862 [ RunTime:0.002043s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (493102,568700,1026341,362801,185093,33721,798305,431060,293326,975884,559786,1032877,664518,100994,712221,498434,530936,64260,597089,113615,1356,817522,581187,419044,556832,261912,821992,400693,125475,770248,122382,900285,190471,866348,552932,184435,903645,81507,835722,924332,405825,551643,289253,186614,985140,575613,1019598,397186,788833,435343,14895,88826,458408,658786,204540,601179,93182,752051,727131,273795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002883s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 448862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 448862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]