SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201418 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201418 [ RunTime:0.002706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966510,768941,615594,551491,94723,848701,613978,835785,106376,339473,180325,992300,272638,214502,1034787,468720,324246,429721,930048,683992,458710,61361,635472,657269,817208,472801,443891,845647,596890,149961,805134,182461,594264,777917,749806,722581,886892,175921,934844,770990,56330,582187,353904,19769,1024443,374314,62886,239321,461741,486321,597835,244745,487039,643178,46407,30567,831854,1021956,797988,348263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009110s ]