SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194916 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194916 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700950,618179,181648,350196,114547,163137,330378,506566,297694,315646,712801,481767,887011,507428,19339,890108,791543,289138,59746,847316,614053,212229,473106,325018,810089,153107,630044,25542,425526,278811,236399,259714,300029,876003,1047367,29821,878375,995366,585270,610219,758596,362246,982528,430554,189764,889363,438757,1028670,985114,396738,88669,128316,975083,92868,338611,920550,195218,769354,147540,678763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000768s ]