SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553002 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553002 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17479,782055,1007906,2497,690334,996324,326615,394640,955850,566662,52555,312593,89782,779787,745304,980110,111370,610397,544995,556794,233780,1043840,824606,86391,110005,571391,658283,616424,980910,128208,858914,784148,3491,405180,12355,961281,254354,240798,400942,366960,848721,294012,685716,934460,917542,378883,808828,553648,816072,790246,621803,420618,390893,410562,915130,967661,135364,944617,570511,115729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553002 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553002 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002524s ]