SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427101 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427101 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351725,161686,499295,538815,857185,771669,27830,742947,786233,963643,974032,509048,190413,274200,267412,931806,364251,600331,719230,190809,1043445,473930,922181,611369,372540,797292,582779,21502,240347,989041,1048448,477171,763449,710547,738499,74901,542847,954711,454048,593732,416893,374182,998438,663966,710051,1027725,659086,1011418,396135,318819,123396,528989,221401,106599,982985,905205,682405,453370,171875,762768) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]