SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 9428 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 9428 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819458,937469,199115,932762,726571,714379,914705,292225,654690,844981,528306,648690,898938,83284,666372,48035,381763,558408,114878,902678,437769,223589,938330,682812,1024380,508476,778111,537057,589943,355954,335694,722256,953267,741438,70142,532341,592632,325421,977878,575560,23551,100560,265288,965664,365249,590173,745101,338840,550264,343863,807366,688577,1022831,775299,537296,324919,706822,104332,983047,845510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 9428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 9428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]