SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48842 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48842 [ RunTime:0.002083s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12070,884653,255295,1031264,166544,752391,851001,785501,897448,620604,222677,656642,716773,122019,296787,99956,679619,905964,421447,743105,664701,194936,413037,561876,1016720,704042,364185,841404,953763,597018,534334,8998,942899,715338,132413,53991,730705,356101,99043,816377,123506,632030,194637,516232,760816,217926,27984,170267,596870,350355,659855,144285,231613,716794,675174,6210,863395,737199,859139,636782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48842 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48842 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002547s ]