SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502841 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502841 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965405,473678,691554,674333,632729,506172,853960,993815,428789,21521,961341,473214,601283,1024012,714859,908697,205392,413769,889282,838479,827415,263385,166864,949248,535885,605530,109531,495825,544590,533584,481837,303276,403576,878995,68200,295591,658807,831041,639702,759556,280757,864126,584984,940857,604120,613362,781738,49887,912488,515501,731118,903039,646796,211837,142049,140055,783418,237511,860176,61040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001100s ]