SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 26497 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 26497 [ RunTime:0.002762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025081,416883,150372,588146,55332,786027,283721,542678,540911,569399,548470,964231,280572,521512,99664,249810,906563,449432,326025,62585,729158,53441,220837,592523,814427,517646,944749,876469,822263,800628,633793,297505,94550,1028126,272136,734102,799499,293094,15212,550503,256970,262295,22093,176791,304283,999230,883169,901460,68362,461147,198603,851842,779795,497180,686547,243818,891229,152394,440864,867986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 26497 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 26497 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000841s ]