SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338918 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338918 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796062,368901,93128,707714,558001,475928,383881,1044515,624013,778031,454324,399988,519081,776390,639413,900488,845068,910969,190863,292556,901716,200785,270504,579586,439246,309118,757119,373291,156456,775522,498364,116,845264,136441,655497,649594,709799,986358,742624,967273,571802,948008,551136,24323,15230,973079,770415,678307,927688,379958,138882,160883,598135,297887,607987,653041,138732,835314,722616,88760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]