SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019393 LIMIT 1 [ RunTime:0.001626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019393 [ RunTime:0.004986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111745,629113,918647,891370,916940,409384,763123,146871,716200,19449,1021541,267145,183084,28140,325540,452093,282594,462552,758099,952627,982046,920227,258869,435296,256785,319130,130863,431649,317370,290,145892,901978,785032,582861,830270,324876,769353,931858,383112,629326,636898,590704,324716,938313,346839,283173,243112,1830,788475,226270,262033,274346,874186,249775,824424,116511,275390,846343,402667,821303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019393 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019393 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]