SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002684s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805059 LIMIT 1 [ RunTime:0.001392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805059 [ RunTime:0.004588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338326,771111,43672,689078,180900,358607,552943,168269,512299,844658,631548,437920,820744,920295,105598,850591,570603,161678,589506,658389,773490,218138,225942,242410,295625,1045830,1033346,215370,183522,733062,894875,295233,835496,246438,908189,99883,385451,458492,465195,699627,30940,473080,243821,642473,899694,344725,888232,754774,500650,619102,424773,238774,763654,502334,259530,128312,242879,108876,838751,586978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000782s ]