SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304438 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304438 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611179,244354,709116,811580,612297,406797,644470,1001923,727987,206330,240689,249593,430254,301055,457260,345417,684421,133705,636737,684202,300280,877429,52702,254984,407419,892144,855980,766975,303529,728861,825059,571425,248579,156941,253395,99917,852927,70968,97342,213840,175101,353038,372399,695396,617972,275120,639843,330984,675957,464325,682392,922780,514309,845929,64983,853301,1032127,239175,932231,49968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000741s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]